>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?
DTOC() probably doesn't make much sense as a sort order; DTOS() generates a string in the form YYYYMMDD which makes sense for sort order.
I have systems which have FPDOS 2.5, VFP5 and VFP6 sharing a table with no problem; the one thing we have to ensure is that any modification of the tgable layouts and structural indexes are done from FPDOS to avoid ambiguity; I do not have specific errors that occurred when things were done from VFP, but because of differences in the header layout, it's probably safer to use FPDOS for these tasks.