Hi
Is there anyway to find out which is the update pending commit from System tables.I will check my application for those uncommitted update.

Is it possible to Rollback this pending update?

--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> sivahari33 wrote:
> >
> > Symptoms which we are getting are
> >
> > 1) Unable to select a particular record from our application. Since 'lockwait' property is true the query shows a waiting cursor.
>
> The easy answer is not to set "lockwait" so your application sees the
> version of the record that was current when the transaction began.
> That has two advantages. It eliminates the wait and gives your
> transaction a consistent view of the database.
>
> > 2) If we try to update this record from Ibexpert then It shows 'Deadlock' message
>
> Some other transaction has modified the record and not committed.
> Eventually the connection for that transaction times out. Find the
> place in your application with the uncommitted update.
>
> >
> Best regards,
>
> Ann
>