Hi All


I upgraded my app to vfp9 from vfp8 sp1 and I am not having problems loosing data. I am using Sybase Adaptive Server Anywhere as my database ODBC SQL pass through for data access. The program has been working fine until I upgraded to vfp9. Now, intermittently, I have users say that data just disappears that they entered. I have verified this by seeing sequence numbers missing in my PK. It acts alike the commits are not happening and the database does rollback a rollback when the connection is closed. Here is what I am doing:

SQLSETPROP(this.nconnection,"Transactions",2)

Do my inserts updates … here.

If success
SQLCOMMIT(this.nConnection)
Else 
SQLROLLBACK(this.nConnection)
End 

Is this the proper way to do this?

Thanks