Subject Rowset at the end of Set
From Mustansir A Ghor <mustan31@hotmail.com>
Date Fri, 16 Feb 2024 04:01:01 -0500
Newsgroups dbase.getting-started
Attachment(s) Capture.PNG

Dear All

I getting an alert message (attached screenshot) in a form that I open and without doing anything even if  I close it.

There is rowset created from a MySQL temporary table xyz with ADOQUERY which has no records in it but it is linked to a grid and so is activated at the opining of the form.

So while form is open if I make this query active property to false , I get this alert message (this is what happens when I close the form without doing anything).

When i add a record to this query using executeSQL for the first record and requery() the rowset I get this alert. Later for subsequent additions all works fine.

Can anybody throw an idea how to avoid this alert message.

Best Regards
Mustansir