Subject Re: Rowset at the end of Set
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Fri, 16 Feb 2024 05:10:23 -0800
Newsgroups dbase.getting-started

On 2/16/2024 1:01 AM, Mustansir A Ghor wrote:
> 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.

You note that there is no data. Something in your code is trying to to
navigate which is causing the problem ... check for that.

Ken

--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
dBASE DOS to Windows Tutorial:
http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm