Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating cursor from table structure
Message
De
26/05/2003 06:29:40
 
 
À
26/05/2003 06:07:14
Alan Harris-Reid
Baseline Data Services
Devon, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00792796
Message ID:
00792799
Vues:
18
Hi Alan,

continue on this way, VFP SELECT parser is optimize for,initial false, expression with only variable/properties.

Example:
x=3
SELECT * FROM someTable WHERE m.x=2 INTO CURSOR resCursor READWRITE

execute only build resCursor phase, none someTable records is scanned.

**

Very useful for build multi joins result structure.

It is equivalent at NODATA clause on USE command.

I think NODATA add 'AND .F.' to the WHERE condition of the SQLSELECTStatement.

Fabio
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform