From: Helen Borrie
Sent: Friday, November 25, 2011 12:43 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Locked records


At 12:38 PM 25/11/2011, you wrote:

>Hi,
>
>Can I recognize locked records from PSQL in FB 1.5.6 ?

Perhaps explain what you mean by "locked records" ?

./heLen


Hi,

The first case is “select * from table with lock” and the second is when some process begin transactions make some updates for records and before transaction is commited another process make updates for some records (the same). There is no problem from my application to maintain concurrency , but some times i need massive updates from stored procedure and in this case i have deadlocks. I can prepare simply mechanism to maintain updates from stored procedure but i need to know “locked” records .

Thanks in advance.


Regards,
Jacek

[Non-text portions of this message have been removed]