Problem with TMSQuery Response

azago · Post by **azago** » Tue 14 Oct 2008 17:29

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 ??

Challenger · Post by **Challenger** » Wed 15 Oct 2008 10:59

Can you compose a small sample to reproduce the error?

azago · Post by **azago** » Tue 21 Oct 2008 16:30

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 ?

Dimon · Post by **Dimon** » Mon 27 Oct 2008 11:58

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.