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
>
|
|