ETL and Data Integration tools - Modern ETL software for everyone

I want to open a dbf file with its indexes. I do not see where I can specify the indexes and their order. I also need to know how I can change the actual index used for the sorting.

Hello

It is not very clear for us what you are trying to achieve
If you want to sort data in the grid you can just click on the filed header and it will be sorted for you.
Or you can use \"select * from tablename order by fieldname\"

If you want to use indexes you can find further information here
msdn.microsoft.com/en-us/library/ms710251%28v=VS.85%29.aspx

We use Microsoft Foxpro ODBC driver for dbf files

Peter

I may modify fields in the table. if one of these fields in part of the index, normally the index file must be opened in order to allow the file to be updated with the new field value. So I need to specify these files to have them opened with the dbf table.

are you getting any errors when you try to modify the data?

Is your index cdx?

Mike

I have not event try to modify the field as I am using a clipper dbf file with ntx indexes. i know that the index has o e opened to be updated. I must a choice to indicate which files are used as index for the dbffile

Can you email us your files please

Mike