Subject Re: Rowset at the end of Set From Mustansir A Ghor <mustan31@hotmail.com> Date Sat, 17 Feb 2024 02:21:20 -0500 Newsgroups dbase.getting-started Dear Ken Sir I found the error. The datalinked field in the grid  was associated with memo type field. When I change it to entryfield type, there was no error. so now poses the issue if on the fly the grid field type can be changed? Regards Mustansir Ken Mayer Wrote: > On 2/16/2024 10:30 AM, Mustansir Ghor wrote: > > 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. > > I don't have MySQL up and running in a test mode. > > create temporary table tempsal5 (like tempsal1) > > I also don't have "tempsal1" ... this is not a standard SQL command, it > may be a feature of MySQL that I am unfamiliar with. > > However, for whatever reason, with an empty table (and the datamodule > and so on commented out), the form is returning that error. > > Checking the count() and state of the rowset, they return expected > values (0 records, and 1 for state means it is in browse ...) > > If I add even one record, and try this, it works as expected, the form > closes, no message. I can't tell you why this is an issue. > > 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 >