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@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 - 08:23:00 CDT