Index on free tables

[r***@home.nl]

Hi,

i use free tables on wich i have indexes. When i close vfp (6) and
reopen it, the indexes on the tables are gone.
If I use a select on this table and use the command set order to
i_art_isbn. I get an error variable i_art_isbn is not found.
If i then modify the table, try to insert the index i get the message,
make structure changes permanent on which i say yes. Then i get the
message that this index file already exists, so i cancel the operation.
If i then again use the command set order to i_art_isbn, everything
works fine????

Rotsj

[Olaf Doschke]

Do you use INDEX ON ... TO ...?

Then you create a IDX index and
that isn't automatically opened together
with the table.

Create cdx indices and everything works
fine.

Bye, Olaf.