Thanks Larry

I know that, so I only work on one table at the time.

>Benn,
>One thing to add here is that you won't be able to specify a specific table to perform the Commit/Rollback on. These commands have session-wide functionality. If you had the following:

>sqlsetprop(nHandle,'Transaction',2)   && 1-Auto, 2-manual, see help
>sqlexec(nHandle,"INSERT INTO COUNTRY_ZONE VALUES ('12345','ABC')")
>sqlexec(nHandle,"INSERT INTO SOME_OTHER_TABLE VALUES ('Kilroy was here')")
>sqlexec(nHandle,"INSERT INTO SOME_OTHER_TABLE_AGAIN VALUES ('George Washington slept here')")
>sqlexec(nHandle,"commit/rollback")

>The other tables would be affected as well.
>
>Regards.
>
>>Hi Wilfred
>>
>>Perfect.................
>>
>>>Hi,
>>>
>>>Have you set the "transaction" to manual ?
>>>

>>>sqlsetprop(nHandle,'Transaction',2)   && 1-Auto, 2-manual, see help
>>>sqlexec(nHandle,"INSERT INTO COUNTRY_ZONE VALUES ('12345','ABC')")
>>>sqlexec(nHandle,"commit/rollback")
>>>

>>>
>>>:) Wilfred
>>>
>>>>Hi
>>>>
>>>>I have succesfullily added a new record to a ORACLE database using the following function:
>>>>
>>>>?SQLEXEC(nHandle,'[INDERT INTO COUNTRY_ZONE VALUES '12345','ABC'])
>>>>
>>>>If I want to perform a ROLLBACK I do as follows:
>>>>
>>>>?SQLEXEC(nHandle,'ROLLBACK')
>>>>
>>>>The returncode is 1, but nothing is rolled back. How do I specify that it is in COUNTRY_ZONE I want to pedform a ROLLBACK ????
>>>>
>>>>The same goes for COMMIT
>>>>
>>>>Regards
>>>>Benn