[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