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