Subject Re: [firebird-support] What another transaction do?
Author Martijn Tonies
Hi,

> I've a multithreaded server application that update a FB1.5.1 ss from
> xml files.
>
> All refresh sql statement, are in a transaction that set field of a
record
> to '1' at beginning.
> I want see this '1' from another transaction...
>
> 1. Start trans A
> 2. trans A set 1 to record
> 3. trans A update database
> 4. trans A set 0 to record
> 5. Commit trans A
>
> Between step 2 and 4 there is a way for see '1' in that record?
(RecVersion)

Only if you use the same transaction and connection.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com