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