hey, it must be the first time I get a "you are right" thing. Now I can go home.
(:-))


>You are right, I keep forgetting that ORACLE does not support BEGIN TRANSACTION.
>
>As Michel mentioned, in ORACLE transactions are implicit.
>
>>really?
>>I did not thing that would work. In fact, I think I tried before and got an error. That's the reason I said ORACLE, cause I did use it in MS SQL.
>>I'll try it again.
>>
>>>You could use SQLExec( nConnection, ‘BEGIN TRANSACTION’ )
>>>
>>>>I’m inserting into 3 tables in Oracle. Used to MS SQL server, I like to Begin transaction, End Transaction and Commit or Rollback using SPT.
>>>>The question is, how do I do that in Oracle?