>hi all
>I use cdx file for indexing. If other way to indexing please tell me
>
>Use student
> Index On descr Tag descr
> Index On code Tag code
> Index On lcode+descr Tag lvldes
> Index On surn Tag surn
> Index On scode Tag scode
> Index On lcode Tag lcode
> Index On sex Tag sex
> Index On fname Tag fname
> Index On joind Tag joind
> Index On dbirth Tag dbirth
> Index On roll Tag roll
> Index On tobt Tag tobt
> Index On mont Tag mont
> Index On ldate Tag ldate
> Index On aattend Tag aattend
>Index On scode+lcode+sec Tag sls
>

I create all my indices with the MODIFY STRUCTURE command.

To update changes to the database - new fields, changes in indices, etc. - I use the following method:

All changes to the database are done in a copy of the database that has zero records. To merge (combine) this with the user data, I have a program that does an APPEND FROM for each table.

This is done in temporary folders, and then copied back to the location of user data.