>Mark.
>What happens if in the middle of a transaction Vfp appl gives an error and i can't issue Sqlrollback() and the connection is lost, or the client goes down ???
>In my opinion i think that Oracle knows that a transaction is not completed and should be rolled backed.
>In several tests i can't reproduce this situation.
>Some idea to do ???. thanks in advance
OK, this time I issued several inserts to one of my Oracle tables FROM VFP using SQLExec() with transactions set to manual [2]. Then I shut off power to my computer. In this case, since the connection to Oracle was abnormally [and brutally] terminated, the inserts were rolled back.
This is consistent with the Oracle documentation. Only an abnormal loss of the connection will rollback changes. Unfortunately, most disconnects from within VFP will result in a commit because they are not
abnormal with respect to Oracle. In any case, the client going down does create an abnormal termination.
Mark McCasland
Midlothian, TX USA