Re: CommandTimeout - TDataSetProvider/TADOQuery

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 06/30/04 

Date: Tue, 29 Jun 2004 22:48:30 -0500

>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: DefaultExpression broken
    ... It is not implemented for TADOdataset or TadoQuery ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: TADODataSet using outer joins and delete method !!!
    ... >>While testing I assigned a query assigned to TADODataSet using outer ... > Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Verify if field is unique in BatchOptimistic
    ... >Is there a way to check if a field is unique in TADODataset ... You could clone the dataset and iterate through the records in the clone to ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: D7.1 - MSSQL7 problems with @Return_value
    ... >What can I do to solve this, or there is workaround for it? ... Are you changing the storedProcedure you are using in code? ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: E_FAIL with TADOTable
    ... that conflicts with an SQL key word. ... You might try using a TadoDataset and adding one field at a time to the SQL ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)