Devart Forums

I use SDAC 4.30.012 with Sql Server 2000

I have a problem with very large table.

i loop using Tmsquery withthis SQL

select IdPratica, stato, b.ImportoSAL, b.Id From CaricamentoPratiche a, GestioneMutui b
WHERE (a.barcode = b.bar_code) and (b.Duplicato = 'A')
and b.FilialeGaranzia = :pFilialeGaranzia and b.Garanzia = :pGaranzia
ORDER BY ImportoSAL DESC

the code used is

tmsquery.Close;
tmsquery.ParamByName(pFilialeGaranzia).AsString := test1;
tmsquery.ParamByName(pGaranzia).AsString := test2;
tmsquery.prepare;

tmsquery.open;


i retrieve only 3 (on 420 iteration) row and after the row is empty.

If i debug the program it work fine!!

Is It a timing -problem ?

If yes the correct parameter on tmsquery ??

Can you compose a small sample to reproduce the error?

i've generate the problem (and look for a solution) in this situation:

program delphi 7.x with SQL access

while the program access intensice on SQL by Select
i've execute an old bde program (like SQL Explorer by Borland) on access the same database and on the same machine.

The SQL Server respond with EOF to select on Delphi program also the rows are present on the db.

This problem is Know ?

We haven't encountered this problem before.
Please send me a complete sample at dmitryg*devart*com to demonstrate it, including script to create and fill table.