jeu. 27 février 2014, 11h29
eddymaue
atoutfox.public.association
Re: textmerge() et sous-requête
as tu essayé avec
Text to SqlExpression TEXTMERGE NOSHOW
select;
Padr("<<Trim(company_.company)>>
(<<Transform(company_.invoiceCount, '999,999')>>)", 60) as company;
, company_.companyID;
from (;
;
select;
company.company;
, company.companyID;
, Count(uploadshistory.uniqueID) as invoiceCount;
from ip!uploadshistory;
join ip!division on uploadshistory.divisionID =
division.divisionID;
join ip!company on division.companyID = company.companyID;
group by 1,2;
) as company_ ;
order by 1
EndText
&SqlExpression
a+ eddy
FoxInCloud vient de nous annoncer :
> Bonjour,
>
> Pour information,
>
> en exécutant cette requête, VFP dit
> "Alias company_ is not found"
>
select;
Padr(Textmerge([<<Trim(company_.company)>>
(<<Transform(company_.invoiceCount, '999,999')>>)]), 60) as company; ,
company_.companyID; from (;
;
select;
company.company;
, company.companyID;
, Count(uploadshistory.uniqueID) as invoiceCount;
from ip!uploadshistory;
join ip!division on uploadshistory.divisionID = division.divisionID;
join ip!company on division.companyID = company.companyID;
group by 1,2;
) as company_ ;
order by 1
>
> celle-ci marche parfaitement:
select;
Padr(Trim(company_.company)+ ' ('+ Ltrim(Transform(company_.invoiceCount,
'999,999')) + ')', 60) as company; , company_.companyID;
from (;
;
select;
company.company;
, company.companyID;
, Count(uploadshistory.uniqueID) as invoiceCount;
from ip!uploadshistory;
join ip!division on uploadshistory.divisionID = division.divisionID;
join ip!company on division.companyID = company.companyID;
group by 1,2;
) as company_ ;
order by 1
>
> Conclusion: Textmerge() ignore les alias temporaire
>
> Bon à savoir ...
>
> ++
--
Merci de partager avec moi votre immense savoir que je me ferai plaisir
d'absorber...
il va de soi que je vais vous en laisser un peu
Politesse et savoir vivre oblige ;0)
Permalink : http://www.atoutfox.org/nntp.asp?ID=0000014045