> Thanks

> Dwaine Horton
> York International
> dwaine.hor...@york.com

>    Blocking can be caused by a number of different factors and without
> knowing more information, it is difficult to troubleshoot the problem.

> What does clicking "apply' or 'OK' do?  What SQL is being sent to the
> server?
> Are you using TTables or TQuerys?  RequestLive, CachedUpdates, Midas?
> BDE, ODBC, ADO?
> Is Microsoft's Client Network Utility configured for TCP/IP or Named
Pipes?

> Good luck,
> krf

> Dwaine Horton <dwaine.hor...@york.com> wrote in message
> news:3c42564b_1@dnews...
> > I have a program that runs okay, but on occassion if two or more users
> > click's apply or Ok at the same time it will take like 5 minutes or
longer
> > for all to clear out and it will sometimes lock up completely.  When I
> look
> > at SQL server I see that one or two processes have been locked.  Is
there
> a
> > way error trap for this and have the program retry every 5 seconds or
so?
> I
> > am using Delphi 4.0 and SQL 7.0.

> > Thanks

> > Dwaine Horton
> > York International
> > dwaine.hor...@york.com

>    What version of Delphi/BDE?
>    Are you using TQuery.RequestLive, CachedUpdates, your own script?

>    Using MSSQL's Profiler, you can find out exactly what SQL is being
used,
> so from that, you can tweak your apps accordingly (the 'how do I do
that?',
> depends on the above questions).

> Good luck,
> krf

> Dwaine Horton <dwaine.hor...@york.com> wrote in message
> news:3c4455bd_2@dnews...
> > When they click Ok or Apply the program is trying to insert or update a
> > record through tqueries.  I have set several ODBC connections to point
to
> > SQL and then they are used within BDE.

> Is there a sql statement that I can execute to check and see if a table is
> currently locked by another user.  I am thinking that I might could run
this
> before I run my other SQL statements and if the result is true then I can
> use a timer to tell the system to wait.

> If your not using RequestLive, then how are you updating?   CachedUpdates?
> Midas?  Your own scripts?  What components are you using?

> krf

> Dwaine Horton <dwaine.hor...@york.com> wrote in message
> news:3c459cf0$1_1@dnews...
> > I am using Delphi 4 and BDE 5.  I am not using request live.

> > Is there a sql statement that I can execute to check and see if a table
is
> > currently locked by another user.  I am thinking that I might could run
> this
> > before I run my other SQL statements and if the result is true then I
can
> > use a timer to tell the system to wait.