Subject Re: grid problem From Charlie <tm@tc.com> Date Sat, 16 Dec 2017 05:48:51 -0500 Newsgroups dbase.getting-started Hi Akshat.. I'll bet that is it.  I don't know how to use beginedit() and beginappend().  I think I encountered this before but can't remember how it was resolved.  Here is the sql code:  this.CONVSHOP1 = new QUERY(this)    with (this.CONVSHOP1)       left = 56.0       database = form.train1       sql = "select * from CONVSHOP order by location"       active = true    endwith Thanks for your help!!! Akshat Kapoor Wrote: > On 16/12/2017 05:12, Charlie wrote: > > Hi.. I'm working with a grid in which I want the user to be able to edit the rows.  For some reason I can't edit anything on the grid even though allow edit property is true.  What could be causing this??  Thanks > > > > Check the status of your rowset. > Try issuing a beginedit()/beginappend() > > If they return true then your rowset is readonly. > Many things in the sql cause the rowset to become readonly. > > If this is the case then please send the sql you are using to generate > the rowset. > > I am not an expert on SQL but others may be able to help you out. > > But please do check this out. > Regards > Akshat