[SQL] Naming returned fields

Ruslan Zasukhin sunshine at public.kherson.ua
Fri Sep 12 08:11:54 CDT 2003


on 9/12/03 3:16 AM, Deane Venske at dean at eduss.com wrote:

Hi Deane,

> Hi Everyone,
> Does Valentina support naming your fields through the SQL query?

Not in 1.x

> 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.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list