Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ORACLE, Commit and Rollback
Message
From
12/06/2002 03:17:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
ORACLE, Commit and Rollback
Miscellaneous
Thread ID:
00667236
Message ID:
00667236
Views:
60
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)"
Next
Reply
Map
View

Click here to load this message in the networking platform