Hi All
I'm using C# and Firebird Database 2.5 and Firebird Client 2.5.1
I'm trying to read a specific record that is currently being updated but the
same record appears to be locked. I cant read it. My code just hangs.
This is an example code I've put together:-
FB_Connection AnotherConnection = new FB_Connection(tbDB_Path.Text,
Con_DB_Default_DataSource, Con_DB_Default_UserID,
Con_DB_Default_Password, Con_DB_Default_Port);
AnotherConnection.Connection.Open();
// Start our Transaction
FtrUpdate = My_FB_Connection.Connection.BeginTransaction
(System.Data.IsolationLevel.ReadUncommitted);
ApplySQL("UPDATE EMPLOYEES_TABLE SET DISPLAY_NAME = 'TOM' WHERE ID = 26",
FtrUpdate);
FdaGeneral = new FbDataAdapter("Select * from EMPLOYEES_TABLE WHERE ID = 26",
AnotherConnection.Connection);
FdaGeneral.Fill(FdsGeneral);
MessageBox.Show(FdsGeneral.Tables[0].Rows.Count.ToString();
It doesn't matter what type of isolation level I use the specific record seems
locked.
I've used Delphi in the past and had no problems.
I'm not even explicitly locking the record when updating.
Any Ideas?
Thanks
