Higher table level required, problem with rebuild

[Juha Santikko]

pdx10.

I am trying to run a simple query that would delete certain records in a
table. Running the query results to an error message: "Higher table level
required". The table level is 5. If I try to change it to 7 using the repair
feature and rebuild it there comes the following error message: "File or
directory does not exist." Still, the verify feature shows "Table and Header
verify OK".

Any clue what to do?

Juha

[Tony McGuire]

: feature and rebuild it there comes the following error message: "File or
: directory does not exist." Still, the verify feature shows "Table and
Header

Do you have Lookup Tables or Referential Integrity defined?

Make sure the BDE is set with the table level you want. Create a new table,
borrowing that other table's structure.

Then add the records from the level 5 table to the new table.


--
--
Paradox Support http://www.thedbcommunity.com/support/

Tony McGuire
_____________

[Bertil Isberg]

To change the the table level to 7, you can add a unique secondary index,
save the table, and then remove the index.

[Juha Santikko]

Bertil,

that worked.

Thanks guys, I donŽt know how I could manage without you!

Juha