Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2013-12

SQL function within SQL statement

3 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Eric Kom

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

Reply by email

David Copeland
to Eric Kom

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

Dave Copeland.

Eric Kom wrote 11 lines
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

Reply by email

Eric Kom
to David Copeland
David Copeland wrote
Perhaps you could try "UCASE(capital) as capital" ...

ooh! Thanks

Show quoted text 23 lines
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 http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Reply by email