Subject Re: grid problem
From maurizio S. <mau@mau.it>
Date Sat, 16 Dec 2017 14:51:06 +0100
Newsgroups dbase.getting-started

usually, order by in sql causes readonly rowset, unless table is indexed
on field (in your case 'location' field)

eny way, I would suggest  grid just to display data (rowSelect= true)
and use different approach to edit



tks
Maurizio

Il 16/12/17 11:48, Charlie ha scritto:
> 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
>