Re: Btrieve file with 2 ACS lists and Pervasive indexes
by Rok Debeljak <rok.debeljak@[EMAIL PROTECTED]
>
Apr 10, 2007 at 09:08 AM
> 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
