Jay;

Well, I am not sure. Why would you want an empty dataset? There are reasons but somehow I feel that there is more to this then meets the eye! :)

Perhaps it is that English/American English thingy and we are missing something in the “translation”.

Tom


>Ahhhh, is that all he wants? I use "WHERE .F." to get an empty cursor/table.
>
>>Mathias;
>>
>>If all you need is a blank table then I like to use SELECT * FROM MyTable WHERE 1>2. This avoids picking up a blank record. :)
>>
>>I would suggest trying this on your local machine. You have to know how much degradation is due to your network. Firewalls and antivirus programs can slow things down, on local machines as well as servers.
>>
>>What network are you using?
>>
>>Tom
>>
>>
>>>Well,
>>>
>>>The initial query is:
>>>
>>>Select a.field1 As Code, a.Field2 As Desc From TableA a Into Cursor tmpCursor
>>>
>>>The table has an index on field1 so I added:
>>>
>>>where a.Field1 = ""
>>>
>>>It's a cheat I know but the query is optimised and works as long as set exact off.
>>>
>>>The time jumps from 5 secs to under 2.
>>>
>>>Regards
>>>>>Hi Mike,
>>>>>
>>>>>Yes I can and I have by introducing a dummy where clause. It optimises and halves the time roughly 2 seconds.
>>>>>
>>>>
>>>>Hi Mathias,
>>>>
>>>>Can you expand a little on this "dummy where clause" idea?
>>>>
>>>>Regards,