Have I found a TMyQuery Error. It Doesn't seem to clear previous DataSet!!!
Posted: 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
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