We are using german Foxpro SP5, english SQL-Server 7.0 SP and have the following reproducable error on different machines, having the sql-server local or on a different machine:

We insert 10 records in a empty table on sql-server, after deleting the fourth the data is corrupted. There are chr(0) in the local cursor, on sql-server the data is ok. Sometimes the active row of the cursor is restored to the correct values after scrolling, sometimes not. When data is requiered, all recors are ok.

We found out, the setting of delete influences the behaviour. When deleted is ON, the error occurs. When deleted is OFF, the error doesn't occur (if TableUpdate() after delete is executed, the erroc does occurs).

Has anyone experience or a solution with this "random" behaviour?

Thanks in advance,
Andreas

P.S. we allready tried sys(3050,1) and sys(3050,2).