[Lazarus] SQL function within SQL statement

Eric Kom erickom at metropolitancollege.co.za
Wed Dec 11 19:41:14 CET 2013


On 11/12/2013 20:31, David Copeland wrote:
> Perhaps you could try "UCASE(capital) as capital" ...
ooh! Thanks
>
> Dave Copeland.
>
> On 12/11/2013 01:16 PM, Eric Kom wrote:
>> Hi all,
>>
>> Please I got small issue with lazarus on how to pass SQL statement
>> with a function as above:
>>
>> SELECT city, UCASE(capital) FROM country;
>>
>> the capital column doesn't show on the DBGrid
>>
>> Thanks
>>
>
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>






More information about the Lazarus mailing list