General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only