[SQL] Naming returned fields
Deane Venske
dean at eduss.com
Fri Sep 12 10:16:13 CDT 2003
Hi Everyone,
Does Valentina support naming your fields through the SQL query?
For instance "SELECT `firstName` AS `First Name` FROM userDetails"
One other thing that would be great is the ability to do :
"SELECT `firstName` & ' ' & `lastName` AS `Client Name` FROM clients"
This would make it very handy to fill grids and the like by
automatically having a function that sets the grid column headings by
the field name specified in the query.
Regards,
Deane Venske
More information about the Valentina
mailing list