Hi Dore,

We just experienced for the first time that running a SELECT INTO CURSOR did not create a new temporary file, but a filtered version of the original table. This does however only happend with a specific table.

Do you know why this is happending? Have we set some property without knowing it??


Thanks...

Klas Nygren


>A stab in the dark. Is your cursor, cDl_dfltl, merely filtered versions of the underlying DBF, Deal , created with an SQL SELECT command? If so, the actual DBF is in use in the cursor work area, not a separate temporary table. You can easily tell by checking DBF('cDl_dfltl'). If it returns a full path to Deal.DBF instead of a temporary table, you will know that you are using a filtered version of the underlying DBF. If so, just add the NOFILTER keyword to your SQL SELECT statement to insure that a new temporary table is used for the cursor.