Subject Re: converting tables back from level 7 to 5
From Mervyn Bick <invalid@invalid.invalid>
Date Fri, 10 Sep 2021 11:23:52 +0200
Newsgroups dbase.getting-started

On 2021/09/10 11:05, Akshat Kapoor wrote:

> Changing level in BDE adminsitrator will NOT change the level of
> existing tables.
> BUT NEW tables will be of level 5
> They will have to be created fresh.
> The easiest commands are
> use tableA
> copy all to tableB
> OR
> use tableA
> copy stru to tableB
> use tableB
> append from tableA
> The above commands are untested and may contain typos or similar errors.
> Hopefully the newly created table will be level 5

No typos but it won't work. :-(

COPY, COPY STRUCTURE or COPY TABLE all retain the original table level
for the new table.

One needs to create the new table from scratch with the BDE set to the
desired table level and then append from the original table.