Hi Team,
   I have a table with an EDBQuery, Dataset & DBGrid.
   If I set the Active True the ReadOnly sets True, even though it wasn't to start.  This happens in Design & Run time.
I don't want it Readonly, RequestSensitive is true.
   The data displays OK, just can't do anything with it.
   None of my other tables exhibits this behaviour.
   Any thoughts/suggestions appreciated.
Regards,
Ian

Further observation..

The original sql is - "Select * from UsersLog order by userid"

If I remove the "order by userid" the RO doesn't set??

Ian,

Is there an index on UserID ?

--
Fernando Dias
[Team Elevate]

On 9/18/2018 8:43 PM, Fernando Dias wrote:
> Is there an index on UserID ?
>

+1

See
https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Result_Set_Cursor_Sensitivity

Specifically

Queries that retrieve data from a single table will generate a sensitive
result set provided that:
....
There is no ORDER BY clause in the SELECT statement, or there is an
ORDER BY clause that minimally matches the columns, and the collations
defined for the columns, in an existing index in the source table.
....

Raul

Raul wrote:

> There is no ORDER BY clause in the SELECT statement, or there is an ORDER BY clause that minimally matches the
> columns, and the collations defined for the columns, in an existing index in the source table.

Ahhhhh.

Thanks Fernando & Raul.