Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT and Oracle
Message
 
To
11/05/2001 10:56:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00505621
Message ID:
00506229
Views:
14
You are right, I keep forgetting that ORACLE does not support BEGIN TRANSACTION.

As Michel mentioned, in ORACLE transactions are implicit.

>really?
>I did not thing that would work. In fact, I think I tried before and got an error. That's the reason I said ORACLE, cause I did use it in MS SQL.
>I'll try it again.
>
>>You could use SQLExec( nConnection, ‘BEGIN TRANSACTION’ )
>>
>>>I’m inserting into 3 tables in Oracle. Used to MS SQL server, I like to Begin transaction, End Transaction and Commit or Rollback using SPT.
>>>The question is, how do I do that in Oracle?
Hector Correa
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform