on 30/11/00 17:49, Ruslan Zasukhin at sunshine At public .D.OT kherson.ua 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.
In 4D, the process that initiated the transaction see the records added or
modified during the transaction, the rest of the processes/users don't see
this records.
I think that this is the correct behavior.
Best regards
Guillermo Zaballa
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2000 Guillermo Zaballa |
