Subject |
Re: Rowset at the end of Set |
From |
Mustansir Ghor <mustan31@hotmail.com> |
Date |
Fri, 16 Feb 2024 13:30:32 -0500 |
Newsgroups |
dbase.getting-started |
Attachment(s) |
igdata.dmd, lpo2.wfm |
Dear Ken Sir
I am thankful to you for your guidance.
By eliminating possible errors, I left in the form with only ADOQUERY, GRID and Close button that closes the form. when we close the form the alert message still appears.
I have put a dmd procedure in the form that has a connection string and creates temporary table which is been used in the form.
I will appreciate at your convenient time to have a look at my code.
For me I cant trace the problem.
Thank you once again
Best Regards
Mustansir
Ken Mayer Wrote:
> 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
>
|
|