Subject Re: Release temporary table
From Bruce Beacham <bbeacham@no_plm_lowman.co.uk>
Date Thu, 8 Nov 2018 21:26:40 +0000
Newsgroups dbase.getting-started

If you do create a temporary table, use funique() to create a table name
that is unique to that instance of your report by the use of random
digits in the name.

ufn = funique(_app.userDocumentsPath + "\Retired_????.dbf")


Bruce Beacham

On 08/11/2018 13:43, Randy Waldman wrote:
> Plus 12 user.  I have a program that loops and creates a report with a temporary table.  Second time that I try to run the report, I get an error that my TempTable is "in use by another".  How do I free my TempTable for re-use?
> thanks, Randy
>