>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!
You can try to use form's Destroy method for this.
I also suggest to not use table at all, but rather a cursor. This way you don't have to worry about deleting it.
If it's not broken, fix it until it is.
My Blog