Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL select columnName isues and bugs.
Message
From
04/06/2005 19:03:49
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01020220
Message ID:
01020281
Views:
15
>>>
SELECT 1 + ('myName') FROM TT
>>
>>Have I written a + ?
>>
>
>That's exactly my point.

Now i see your point.

The parser it wants protect to me from my possible errors.
If I put something that joins the two expressions, then the second one is not more a name than column.
First, you are optimistic.

Second, Sin that AS is optional, and without the lack operator the command syntactically is corrected.

With your rule,nearly all the grammar becomes ambiguous.
A simple example:
CREATE CURSOR TT (AA I)

*I could it are forgotten about +
SELECT AA    AA FROM TT
*
SELECT AA +  AA FROM TT
Previous
Reply
Map
View

Click here to load this message in the networking platform