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)"