SQLdb TSQLQuery.IsEmpty problem on MySQL 4.1.11

[RudieD]

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