Devart Forums

I use UniDac for a while and I replace AdoDataset.Requery method with UniQuery.Refresh.. It seems ok for the begining..

But sometime later, I study on FetchAll = False mode. I use

Exec('SELECT * FROM SOMETABLE' + :STRPARAM )

style statements and then I realise Refresh is not doing its job. I have to use Close and Open UniQuery.. It is runing but I know in Ado Close and Open for refresh is not efficient way, ms offers Requery instead. But there is no Requery in Unidac as I know..

Is it only and efficient method close and open? Or Is there better way?

Thanks

I give an example for my question.

UniQuery1.Sql.TExt := 'EXEC('#39'SELECT * FROM SOMETABLE '#39+ ' :WHEREST)';

UniQuery1.DisableControls;
try
UniQuery1.Close;
UniQuery1.Params.ParamByName('WHEREST').Value := ' WHERE ASTRFIELD LIKE '#39 + 'C%'+#39;
UniQuery1.Open;
finally
UniQuery1.EnableControls;
end;

I would prefer like this. But for SpecificOptions.Values['FetchAll'] := 'False', this Refresh method is not do the job !

UniQuery1.Params.ParamByName('WHEREST').Value := ' WHERE ASTRFIELD LIKE '#39 + 'C%'+#39;
UniQuery1.Refresh;

I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.

Hi,

I just sent the sample delphi project and mssql data backup file to you, Dmitry.

Tugrul

Hi,

Do you confirm you got the sample delphi project Dmitry. And it seems now, it's Refresh bug with tables recordcount > 10.000...

Tugrul

This seems like serios problem.. I need urgent response

Unidac version 2.00.0.4 and Delphi2007 Ent.

We have answered you by e-mail.

I do not understand Russian. .. Thanks for fast reply anyway...