Subject Re: Rowset at the end of Set From Mervyn Bick <invalid@invalid.invalid> Date Sun, 18 Feb 2024 13:57:21 +0200 Newsgroups dbase.getting-started On 2024/02/18 13:02, Akshat Kapoor wrote: > Good Evening Mustansir, > I may be wrong, > Is your form trying to do a implicit save? > Is the grid editable? > > Have your tried making the grid readonly. > > The rowset is linked to grid. There is nothing in the rowset, it may be > null. But the field in grid may not be retaining the null value. It may > be a space. > > When you try navigation dbase tries an implicit save to save the > changes. But there is no row to save the changes and hence the error. > > I would have loved trying your code but I am not coding much these days. My money is on a bug in the ADOquery and/or the ADOrowset object. I no longer have access to MySQL but using an ADOdatabase with an ADOquery and Firebird to display an empty table or empty GTT in a grid also causes an "End of rowset" error when the form closes. Accessing the same table and GTT using standard database and query objects to access Firebird via the BDE does not cause an error when the form is closed. A work-around is to null the ADOquery object before closing the form. Mervyn