[Lazarus] SQL function within SQL statement

David Copeland david.copeland at jsidata.ca
Wed Dec 11 19:31:45 CET 2013


Perhaps you could try "UCASE(capital) as capital" ...

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
>






More information about the Lazarus mailing list