on 30/11/00 17:47, Aaron Bratcher at aaronbratcher .AT. mac D.O.T com wrote:
> So if Im in the middle of a transaction and I do this:
>
> START Transaction
> t1.add ...
> select from t1 ...
> COMMIT
>
>
> Will my SQL select reflect the just added record even when I have not done a
> commit yet?
All my life I did think that you will see it in selection,
and I become mad when try invent how to implement this.
But several weeks ago, in discussion with our Windows developer which is
good SQL Server developer, he said that NO(!!!) you will not see it in
selection, because this record is not added to original table.
So it become EASY implement this requirement of transaction: other users do
not see your changes until you commit changes, as payment you don't see them
also...
I still not sure if this is correct and will check later.
In any case there are limitations on operation which you can do inside of
transaction.
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on .AT. lists D.O.T macserve.net
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2000 Ruslan Zasukhin |
