>dear all,
>
>i would like to know how can i creat cdx files from dbf outsite the tables creation time by code, the reasone for that i made long time a go inventory system with pos system using the idx file and now the system become slow so i need to increase the speed of the database by using cdx files while they are in multi user network system.
I doubt that switching from IDX to CDX alone will improve performance. Anyway, to create CDX index you've to open table exclusively and use index command.
USE mytable EXCLUSIVE
INDEX ON <key expr 1> TAG <tag name 1>
INDEX ON <key expr 2> TAG <tag name 2>
...
INDEX ON <key expr 3> TAG <tag name 3>
It'll create a structural index that opens automatically with table.
--sb--