Hello Rudy,
Here, VFP is optimizing queries using RushMore and not creating temporary table. You just include NOFILTER clause which disables the Rushmore and try.
Bye
Jayesh
>First off, let me say we appreciate the feedback from everyone on previous messages we have sent. The input has been very useful.
> Today, I've got a really strange issue. In order to assist us with a File Management screen in our applications, we created an index in each of our tables with DELETED as the name and using DELETED() as the expression. All of a sudden, a few SQL SELECT statements that had been creating cursors just fine started coming back with the message " 'cursor' must be created with SELECT ... INTO TABLE (Error 1815)". When I removed the new DELETED index from the main table in the SQL, it started working again (I left the DELETED index on all other tables).
> Can anyone provide some insight here?
>
> Bryan A. Jackson
> for Rudy Nieves
- Jayesh