General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
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