Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL select columnName isues and bugs.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL select columnName isues and bugs.
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01020220
Message ID:
01020220
Views:
66
Next code show some issues and bugs on the VFP's SQl SELECT parser.
CREATE CURSOR TT (AA I)

FieldName = 'myName'

* expected no error: BUG

SELECT 1 ('myName') FROM TT

* expected no error

SELECT 1 (m.FieldName) FROM TT

* with AS the parser can solve the tree path

SELECT 1 as ('my'+'Name') FROM TT

SELECT 1 as (m.FieldName) FROM TT

* the free position of the command components clasues open various issues

* left command components are allowed without AS
SELECT 1 SELECT FROM TT

SELECT 1 TOP FROM TT

SELECT 1 PERCENT FROM TT

SELECT 1 BUFFERING FROM TT

* these are ignored !! sure a BUG

SELECT 1 DISTINCT FROM TT

SELECT 1 ALL FROM TT

* these have a right fixed position, without error

SELECT 1 ANY FROM TT

SELECT 1 SOME FROM TT

SELECT 1 EXISTS FROM TT

SELECT 1 IN FROM TT

SELECT 1 WITH FROM TT

SELECT 1 OUTER FROM TT

SELECT 1 BY FROM TT

* these have a right fixed position, with error: bugs for me

SELECT 1 JOIN FROM TT

SELECT 1 LEFT FROM TT

SELECT 1 RIGHT FROM TT

SELECT 1 FULL FROM TT

SELECT 1 ON FROM TT

SELECT 1 UNION FROM TT

* right float command components are not allowed without AS

SELECT 1 INTO FROM TT

SELECT 1 WHERE FROM TT

SELECT 1 GROUP FROM TT

SELECT 1 HAVING FROM TT

SELECT 1 ORDER FROM TT

* AS fix they
SELECT 1 AS GROUP FROM TT
Next
Reply
Map
View

Click here to load this message in the networking platform