Alias a field in SELECT

Gunnar Swan GunnarSwan at PracticeToPass.com
Fri Feb 21 15:09:59 CST 2003


the Aggregate Function COUNT in SELECT , when used with GROUP BY,
produces output field name ... COUNT ... in a list.

Director Lists also have function named COUNT. 

So when I go ResultList[1].Count ... expecting the aggregate COUNT,
I get the count of items ... not the value returned ..

>No alias for SELECT now.
This may be important. Are you going to do this ?




More information about the Valentina mailing list