>>Have you looked into using cursors (CREATE CURSOR etc.) rather than temp tables? When closed VFP will automatically delete them for you.
>
>I need to look at using the SYS(5)+CURDIR() command. I didn't know about that one.
>
>Aren't cursors read only prior to VFP 7? The user has to be able to update these tables during the procedure. I'm still on VFP 6.0. Haven't made the leap yet.
Cursors created with CREATE CURSOR are read-write in all versions of VFP. Ones created via SELECT - SQL are read-only prior to VFP7 but there is a workaround by opening again with USE ... ALIAS NewAlias AGAIN ...
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up