Subject Re: Rowset at the end of Set From Ken Mayer <dbase@nospam.goldenstag.net> Date Fri, 16 Feb 2024 12:05:49 -0800 Newsgroups dbase.getting-started 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