Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Result set in edbmgr??
Thu, Mar 12 2020 12:47 AMPermanent Link

Ian Branch

Avatar

Hi Team,
Given the attached..
Should I be able to edit the entries?
Regards & TIA,
Ian



Attachments: Screenshot_1.jpg
Thu, Mar 12 2020 12:57 AMPermanent Link

Ian Branch

Avatar

Hmmm.  I see in the Execution Plan that the Result Set is insensitive and read-only.
Why?
Thu, Mar 12 2020 1:06 AMPermanent Link

Raul

Team Elevate Team Elevate

On 3/12/2020 12:57 AM, Ian Branch wrote:
> Hmmm.  I see in the Execution Plan that the Result Set is insensitive and read-only.
> Why?

Most likely because of group by

However here is docs on how that is determined :
https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Result_Set_Cursor_Sensitivity

Raul

Thu, Mar 12 2020 2:49 AMPermanent Link

Ian Branch

Avatar

Ahhh.  Thanks Raul.
I'll have to rethink it.
Regards,
Ian
Image