Hi Andrus,

> Unfortunately, if backend returns error as response to SQLEXEC(), VFP automatically sends ROLLBACK command to backend!

How have you determined that VFP sends a ROLLBACK command? I'm asking, because I haven't seen this behavior yet, and I too, have code that first fails, picks an alternative and completes successfully.

Are you, by chance, disconnecting from the server? In this case, the following line might help:

SQLSetProp( This.nHandle, "DisconnectRollback", .F. )