On Tuesday, July 26, 2022 at 9:26:49 AM UTC-7, Marco wrote:
> Hi, the insert is done with PHP\ODBC not from xharbour, but
> the table and the index is created by xharbour. Any idea to
> prevent the error? Other query under PHP\ODBC on the same
> table doesnt give the error.
Wrong newsgroup. You must use Foxpro resources, with Foxpro ODBC connection issues. When you do that, I think you will find out that the current ODBC code no longer supports what was a REALLY bad idea.
Since you appear to have missed my obvious advice: use APPEND [add to the end of the file], rather than INSERT [copy the existing file to a new file up to recno()-1, append this record, append the rest of the records from the original table, close the original table, delete the original table, reopen the indexes, reindex all the indexes, position the record pointer to recno()].
David A. Smith