Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL select columnName isues and bugs.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL select columnName isues and bugs.
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01020220
Message ID:
01020220
Vues:
67
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform