Subject Re: converting tables back from level 7 to 5 From Rouke <moc.liamg@rekkabrg> Date Fri, 17 Sep 2021 22:41:55 -0400 Newsgroups dbase.getting-started Hi, thanks both for your replies. I got it fixed, but the manual way. There was still a level 5 backup which I used for the structure. I wrote the data from the level 7 table to a text file and then appended them back into the old level 5 structure. Rouke Mervyn Bick Wrote: > 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. > > Mervyn. > >