REFRESH BUG in UniDAC?

[Tugrul Tamturk]

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

[Tugrul Tamturk]

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;

[Dimon]

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.

[Tugrul Tamturk]

Hi,

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

Tugrul

[Tugrul Tamturk]

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

[Tugrul Tamturk]

This seems like serios problem.. I need urgent response

Unidac version 2.00.0.4 and Delphi2007 Ent.

[Dimon]

We have answered you by e-mail.

[Tugrul Tamturk]

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