SQLdb TSQLQuery.IsEmpty problem on MySQL 4.1.11
lazarus / 16-Databases

----------------------------------------------------------------------
RudieD · 2006-04-06 18:15

Hi,

Do anybody else have this problem ?
I have a TSQLQuery that I Open first time and it shows the single
record.
I then close it and change the where clause. When I open it again,
there should be no records, but the dataset shows RecordCount = 1.
That record doesn't exist, so If I call first, last, Insert or Edit I
get a AV error.

It seems if the previous buffers were not Clear.

I'm using FC4, Lazarus 0.9.15 from Last weakend and MySQL 4.1.11.

Any Suggestions Welcome.

Thanks in advance