Subject Re: cannot create unique table
From Bruce Beacham <bbeacham@no_plm_lowman.co.uk>
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