>Hello,
>I have to append records to a FoxPro Dos table.
>Some problems did occur which we weren't able yet to identify.
>One question:
>How are indexes handled when appending to a Dos table? The table in question has an index on DTOC(datefield)+CharacterField. Can this cause problems? Are there more secure ways of exporting records to a DOS table?
You would probably be better off with DTOS(datefield)+CharacterField, if the purpose of the index is to order the records by date. It would also work well for lookup purposes, and is not affected by SET CENTURY ON/OFF.