Subject Re: cannot create unique table
From Bruce Beacham <>
Date Mon, 19 Oct 2020 19:09:29 +0100
Newsgroups dbase.getting-started

There is a maximum of 1,000 temp tables labelled _qsql??? that you can
have in a directory.

Bruce Beacham

On 15/10/2020 12:54, Akshat Kapoor wrote:
> On 15.10.2020 17:03, jude ojo wrote:
>> Hi all,
>> I am having problem of 'cannot create unique table' when I want to run
>> a report.
>> What should I do please.
>> Jude
> Good Evening Jude,
> Please provide us a screen shot of the error. (If it is not in English
> please provide a translation as it will be difficult to copy and paste
> translation from a image file)
> Primarily it seems that there are mutiple _qsql???? files in your
> directory.
> Close all sessions and delete all _qsql?????.dbf files in your directory.
> If this does not solve your problem then insert the following just
> before you run your report.
> msgbox(set('Directory'))
> If it shows the directory of your app then clean that directory of _qsql
> files.
> If it shows some reserve directory like program files or windows then
> you will have to change directory.
> Regards
> Akshat