Message
From
23/07/2003 09:48:23
To
23/07/2003 09:22:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00812705
Message ID:
00812759
Views:
13
Mark, thanks for the reply.
>>Use a filter in the WHERE clause that can be optimized but returns no mathing records. For example, say I have a Primary Key field named KeyID and only contains positive integer numbers:
SELECT * FROM MyTable WHERE MyTable.KeyID = -1>>
I like it, but it would mean a different WHERE condition for each table. If possible, I would like a more generic solution. Does SQL have the equivalent of .F.? I tried WHERE FALSE, but that did not work. However, WHERE 1=0 did produce an empty cursor, but would SQL have checked every record in this case?
Regards,
Alan
>>Use a filter in the WHERE clause that can be optimized but returns no mathing records. For example, say I have a Primary Key field named KeyID and only contains positive integer numbers:
SELECT * FROM MyTable WHERE MyTable.KeyID = -1>>
I like it, but it would mean a different WHERE condition for each table. If possible, I would like a more generic solution. Does SQL have the equivalent of .F.? I tried WHERE FALSE, but that did not work. However, WHERE 1=0 did produce an empty cursor, but would SQL have checked every record in this case?
Regards,
Alan