Having read the entire thread now, including your comments to Helen
(which are undeserved IMHO), I have a more concrete suggestion.

Scalable apps uses a "pseudo-conversational" model when talking to the
backing database. That is, you retrieve the data into a local store
(TClientDataSet, for example) and commit, perform your work locally,
then apply changes and commit in a separate transaction later.

At no point in time is a lock held.

I have delphi apps sharing a mission-critical real time database that
processes well over a million transactions per hour with 8,000
concurrent users and an indeterminate number of real-time automated
processes.

The model is reliable - my last Delphi app,supporting roughly
$300,000,000 per year in business, has gone for three years now without
any support. The team that "owns" it now had to get my help to
recompile it because it had been so long since it was touched and they
don't have any Delphi skills on that team.

This is also the model used by all CICS and web development, so it is
not a new or novel concept.

I hope this helps.

On Tue, 2006-03-07 at 11:12 +0000, colincoleman2002 wrote:
> Every now and then our Delphi 7 app, running against a FB 1.5.x
> server
> decides to throw a lock conflict at the users, up till now the
> solution has been for all the users to log out one by one untill the
> lock is released and then they can all carry on again, bit of a pain
> when 70 users plus are logged in.
>
> Is there a way of asking the server what lock conflicts are active
> and
> which connections caused them?
>
> would make my life very easy then to tell the locking connection to
> save / abort.
>
> Thanks
> Colin
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> Computer technical
> support
> Compaq computer
> technical support
> Compaq technical
> support
> Hewlett packard
> technical support
> Microsoft technical
> support
>
>
> ______________________________________________________________________
> YAHOO! GROUPS LINKS
>
> 1. Visit your group "firebird-support" on the web.
>
> 2. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> 3. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ______________________________________________________________________
>