SQLRollBack() reset error
Just found out that SQLRollBack() will reset error occured during SQL Server transaction. IOW, we would not able to get the error occured during transaction after rollback.
I believe it is design of ODBC driver, nothing to do with VFP. (Is it true?)