Re: Btrieve file with 2 ACS lists and Pervasive indexes



I would be very grateful if anyone be able to offer any suggestions
for this problem.

Don't use the existing file in step 3!

Try it like this:
-- Step 3
CREATE TABLE MyTable USING 'temp.mkd' (...);
CREATE INDEX ...; -- NO "IN DICTIONARY"
CREATE INDEX ...;
-- At this point the value of Xi$Number in the system table
-- X$Index is correct.
butil -stat temp.mkd and butil -stat MyTable.mkd should be the same.

ALTER TABLE MyTable IN DICTIONARY USING 'MyTable.mkd';

del temp.mkd

Rokson
.