>Use NOFILTER if you want a new table as opposed to a filtered view of the original table.

Does this work in FPD25?
It does not show in the help of Fox2.6, I thought it was only in Visual.


>>Please note the following SELECT
>>

>>	SELECT mitem.subhead, mitem.uniqueid ;
>>		FROM a09mitem mitem ;
>>		INTO CURSOR abc
>>

>>
>>This is the DISPLAY STATUS after the SELECT is run
>>

>>Select area:  1, Database in Use: C:\VSO2\SW\A09\CMP00001\A09MITEM.DBF    Alias:
>> A09MITEM
>>           Code page:   0
>> Structural CDX file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.CDX
>>           Index tag:   UNIQUEID   Collate: Machine   Key: UNIQUEID
>>           Memo file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.FPT
>>       Lock(s): Exclusive USE
>>
>>Currently Selected Database:
>>Select area:  2, Database in Use: C:\VSO2\SW\A09\CMP00001\A09MITEM.DBF     (Read
>>only) Alias: ABC
>>           Code page:   0
>> Structural CDX file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.CDX
>>           Index tag:   UNIQUEID   Collate: Machine   Key: UNIQUEID
>>           Memo file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.FPT
>>       Lock(s): Exclusive USE
>>

>>
>>The CURSOR abc is my original file reused shouldn't it be a temp file???
>>
>>
>>Now notice this SELECT
>>

>>	SELECT mitem.subhead, mitem.uniqueid ;
>>		FROM a09mitem mitem ;
>>		WHERE .T. ;
>>		INTO CURSOR abc
>>

>>
>>This is the DISPLAY STATUS after the SELECT is run
>>

>>Select area:  1, Database in Use: C:\VSO2\SW\A09\CMP00001\A09MITEM.DBF    Alias:
>> A09MITEM
>>           Code page:   0
>> Structural CDX file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.CDX
>>           Index tag:   UNIQUEID   Collate: Machine   Key: UNIQUEID
>>           Memo file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.FPT
>>       Lock(s): Exclusive USE
>>
>>Currently Selected Database:
>>Select area:  3, Database in Use: C:\TRASHCAN\81557496.TMP     (Readonly) Alias:
>> ABC
>>           Code page:   0
>>       Lock(s): Exclusive USE
>>

>>
>>What say!!!