Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating cursor from table structure
Message
From
26/05/2003 06:29:40
 
 
To
26/05/2003 06:07:14
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00792796
Message ID:
00792799
Views:
20
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
Previous
Reply
Map
View

Click here to load this message in the networking platform