General information
Category:
Coding, syntax & commands
>>>> ... WHERE ... AND .T. = .T. ...
>>>>
>>>>This force VFP to create a temp table for the cursor and will speed up your grid display.
>>>
>>>I use the field AS fieldname which also forces a cursor.
>>>
>>>SELECT *,0 AS DUMMY FROM ...
>>Michel,
>>
>>That works too.
>>
>>Except if the result strucutre is critical, then WHERE .T. = .T. doesn't add a field to the result. NOFILTER is the best way in my book (if we are talking VFP 5.0).
>
>Thanks, but is .T.=.T. still fully optimizable?
Yes, if you have an index on the .T. field. :)
Vlad
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