Have I found a TMyQuery Error. It Doesn't seem to clear previous DataSet!!!

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
TheLion
Posts: 39
Joined: Thu 25 Nov 2004 11:28
Location: Copenhagen/Denmark

Have I found a TMyQuery Error. It Doesn't seem to clear previous DataSet!!!

Post by TheLion » Mon 07 Nov 2005 21:29

Hi :-)

I am using Delphi5 Enterprise, MyDAC 4.00.1.6 and MySQL 4.0.22 & 4.0.24

In a while loop I have a Select that returns 95 rows in the first loop and 0 rows in the second loop. But the second loops rowcount is still 95!! The Eof is True, but if I give it the MyQuery.First command, I can access the Data from the previous loop???

I actually have 31 loops and several of them should return 0 rows, but takes on the previous loops data.

I have recompiled one of my services, it normally runs fine with an old MyDAC 3.55 version. But now it makes a lot of errors and I get the wrong data :-(

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 08 Nov 2005 09:51

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create and fill table.

Post Reply