General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Sergey,
Thanks, I'd forgotten about NOFILTER.
Regards,
Gavin...
>Hi Gavin,
>
>In case when select is fully Rushmore optimizable foxpro doesn't create cursor but instead opens source table with command similar to USE AGAIN and uses SET FILTER to filter records. Removing index on DELETED() makes select only partialy optimizable. You can add NOFILTER clause to the Select to force foxpro to create a cursor as a temporay file.
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