Transactions - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> Transactions

Reply

#1 (permalink)

Old

01-06-10, 10:35

xotesa

xotesa is offline

Registered User

Join Date: Jun 2009

Posts: 16

Transactions

Hey.

I have 3 insert statements in my transaction.

Is it ever possible that 1 insert is done and 2 others inserts aren't done? Is the probability 0% or not?

Reply With Quote

#2 (permalink)

Old

01-07-10, 04:56

aflorin27

aflorin27 is online now

Registered User

Join Date: Apr 2008

Location: Iasi, Romania

Posts: 304

Depends how you wrote that transaction:
- see if you have nested transactions
- set chained on/off
- savepoints

__________________
Florin Aparaschivei
Iasi, Romania

Reply With Quote

#3 (permalink)

Old

01-07-10, 05:26

mike_bike_kite mike_bike_kite is offline

mike_bike_kite is offline

vaguely human

Join Date: Jun 2007

Location: London

Posts: 2,517

Perhaps providing a little code might not be a bad idea

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules