Problem with TMSQuery Response

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 6
Joined: Fri 04 Jul 2008 08:25
Location: Italy

Problem with TMSQuery Response

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

the code used is

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

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

Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Wed 15 Oct 2008 10:59

Can you compose a small sample to reproduce the error?

Posts: 6
Joined: Fri 04 Jul 2008 08:25
Location: Italy

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 ?

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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.

Post Reply