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!!!