Alias a field in SELECT

[Gunnar Swan]

I'm so used to the list dot syntax. Your technique worked.
I was just about to go back to the .GetAProp() or .GetProp()

Thank you.

Ruslan, whenever you can alias fields, will be great. Between
now and then, I'll find a way.


2/21/03 4:15:42 PM, Nathan Friesen <nfriesen at dyton.com> wrote:

>> 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 ..
>
>If I follow you right, you're getting a property list, and one of the 
>items in the list is #Count. If that's the case, I think you can get the 
>value from the database with ResultList[1][#Count]
>
>
>Nathan Friesen
>Dyton, Inc.
>2302 West 1st Street
>Cedar Falls, IA 50613
>P: 319.277.8418
>F: 319.277.8417
>
>www.dyton.com
>
>
>------
>    Where there is no vision, the people perish.
>      - Proverbs
>------
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>


Best Regards,
Gunnar Swan
http://www.PracticeToPass.Com
Software Built For Statutory Courses