>I am creating a program in which I create tables to preview reports. I delete the temporary tables after the report is done being viewed/printed. The program is a multi-user program and if it so happens that User A is previewing the report and User B wants to view the same report they would get an error because it tries to create a table with the same name.
>
>I have thought of two options. One would be creating a different name for the table everytime it's created (based on a datetime stamp or something), but the question is how do I refer to it in my create table command?
>
>create table (blah);
>
I'd look at creating a cursor rather than a table; they clean up after themselves when you close them.
The nice thing about cursors is that you can give them the name you'd want to refer to them by; VFP takes care of all the temp file name issues.