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