Hello.
The correct sequence would be:
=CursorSetProp("Buffering",5,"Customer")
Begin Transaction
Insert into Customer (Fields) values (Values)
=TableUpdate(.T.,.T.,"Customer")
End Transaction
Note that the insert IS part of the transaction. I didn't got this error, but I suposse it is about trying to commit changes inside a transation that were made outside of it.
Hope this helps.
>I have a database and a customer table in it. There is no unique,primary nor candidate key for the table,
>just several regular indexes. When i issued following code to append the table:
>
>=CursorSetProp("Buffering",5,"Customer")
>Insert into Customer (Fields) values (Values)
>Begin Transaction
>=TableUpdate(.T.,.T.,"Customer")
>End Transaction
>
>There is no record appended to the table and if i issue "set order to ..." command and browse the table,
>I got "Index does not match the table. Delete the index file and re-create the index" message.