General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
As in VFP Help for Select -SQL command:
"AS Column_Name
Specifies the heading for a column in the query output. This option is
useful when Select_Item is an expression or contains a field function and
you want to give the column a meaningful name. Column_Name can be an
expression but cannot contain characters (for example, SPACES) that aren't
permitted in table field names"
>select fieldname as "field name" from tablexx
>result in an error
>
>select fieldname as field_name from tablexx
>work fine.
>
>am I doing anything wrong or it can not be done, yet.
>I thought we used to be able to do that. or I am mixing VFP with other tool.
>
>Mo
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only