Re: computational model of transactions
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Sun, 06 Aug 2006 13:23:00 GMT
Message-ID: <U2mBg.35724$pu3.465368_at_ursa-nb00s0.nbnet.nb.ca>
>
> PMFJI. Can you tell us why you didn't bracket the two operations above by
> something that would indicate that they are both part of the same
> transaction? Or are they separate transactions?
Date: Sun, 06 Aug 2006 13:23:00 GMT
Message-ID: <U2mBg.35724$pu3.465368_at_ursa-nb00s0.nbnet.nb.ca>
David Cressey wrote:
> "Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
> news:SzlBg.35718$pu3.465255_at_ursa-nb00s0.nbnet.nb.ca...
>
>>How about: Delete from table a where id = 1 and x = 2; insert into table >>a values (id=1, x = 7); ?
>
> PMFJI. Can you tell us why you didn't bracket the two operations above by
> something that would indicate that they are both part of the same
> transaction? Or are they separate transactions?
I was using something akin to SQL syntax so I assumed SQL semantics with transactions ending at a COMMIT statement. If I were using Tutorial D, I would have used a comma to make them a single statement.
I apologize for not being clearer. Received on Sun Aug 06 2006 - 15:23:00 CEST