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)
>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)
>>>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
Benn Kjaer
MS Certified Professional - Visual Foxpro
"There is something rotten in the state of Denmark"
"Why make user-friendly programs, when there aren’t any friendly users :o)"