You should use a cursor instead
SELECT * from parts WHERE ponum=mponum INTO CURSOR partstank READWRITE
...
USE IN partstank
>I create a table with:
>SELECT * from parts WHERE ponum=mponum INTO TABLE partstank.dbf
>
>After using this table as a record source for a grid, I can't get the thing to close no matter what I do, and no matter where I do it! Is there any way apart from USE to close a table?
>
>The code I have tried is:
>SELECT partstank
>use
>
>Also tried:
>
>USE in SELECT("partstank")
>
>After trying to close the file, I try to delete the file with:
>DELETE FILE('partstank.dbf')
>and get a VFP error "File in use..."
>
>ANY ideas welcome!
>Thanks!
--sb--