Re: CommandTimeout - TDataSetProvider/TADOQuery

From: FaithNoMore (carlos.rodrigues_at_recall.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 11:41:29 -0300

Is there any pack or update to solve this timeout problem with TadoQuery in
D5?

"Brian Bushay TeamB" <BBushay@Nmpls.com> escreveu na mensagem
news:m4d4e0dg3uq932jridopgl12b48oup7e1a@4ax.com...
>
> >I have a provider linked to a TADOQuery. The property ResolveToDataSet is
false (in this case it canīt be true), so it will use TSQLResolver to update
de Database. The TSQLResolver uses the TCustomADODataSet.PSExecuteStatement
to execute the SQL statements. The problem is that this method doesnīt use
the CommandTimeout value of the TADOQuery. So if a statement takes more than
30s to execute a "TimeOut Expired" exception will be thrown. Does anyone
know how can i change the Time Out for this meth
> >od?
> What version of Delphi are you using? CommandTimeout doesn't work with
> TadoQuery in D5. The workaround is to use TadoDataset
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com

Relevant Pages

  • Re: CommandTimeout - TDataSetProvider/TADOQuery
    ... where Qu is name of the TADOQuery or TADOtable. ... >>Is there any pack or update to solve this timeout problem with ... --- posted by geoForum on http://delphi.newswhat.com ...
    (borland.public.delphi.database.ado)
  • Re: CommandTimeout - TDataSetProvider/TADOQuery
    ... It's an 'undocumented feature' of the TADOQuery. ... The TSQLResolver uses the TCustomADODataSet.PSExecuteStatement ... to execute the SQL statements. ... 30s to execute a "TimeOut Expired" exception will be thrown. ...
    (borland.public.delphi.database.ado)
  • Assisting end users
    ... I want to provide an easy way for end users to generate SQL statements ... that will be used by a TADOQuery to select from and update a remote ... that could assist with this task Do not want to reinvent the wheel ...
    (borland.public.delphi.database.ado)
  • Re: Reducing Command Timeout Property for ADO Connection Object
    ... Use the commandTimeout property of TadoDataset or TadoCommand. ... TadoQuery and TadoStoredProc in D5 had a bug with Commandtimeout so that this ...
    (borland.public.delphi.database.ado)