Hi All!
I Have a strange problem on a form that manage a Main Table with a Child Table. The backend is SQL Server but i think that this is irrilevant!
The Main table is a Cursor SPT with row Buffer
The Child table is a cursor SPT with a table buffer
1) I insert a new record on the main table that will conflicts with some rules when i'll try to insert on server
2) I insert a record on the child table in grid (this is important) with some value on some fields (this is important)
3) Now i try to update the server inserting the record in main table, this is the pseudo trace :
Begin a transaction on VFP client
Try to insert the record on server with sqlexec
--> server respone: (Rule Violation on server
rollback the transacion on vfp client
4) From Now, if i try some replace on the child cursor VFP emit this error:
Errore 114 - Index does not match the table. Delete the index file and re-create the index.
The rollback operation (i'm sure of this, i try somereplace before the rollback and there isn't the error) had corrupt the index.
This problem there wasn't on VFP 7.0 (the form is used actually on VFP 7.0 and all work perfectly).
Someone have some suggestion ?
Thanx in Advance!
I know that my English is horrible ... but i hope in yours beatyful minds 8)
bye, Emanuele!
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.