Programming => Databases => Topic started by: RudieD on April 06, 2006, 08:15:23 pm

Title: SQLdb TSQLQuery.IsEmpty problem on MySQL 4.1.11
Post by: RudieD on April 06, 2006, 08:15:23 pm

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
TinyPortal © 2005-2018