Cannot Edit in DBGrid

[Marco]

Hello all,

question:

i have a dbgrid that is connected to the Delphi Component DataSource. The DataSource is connected to the DOA OracleDataSet Component and this component is connected to the DOA OracleSession component.

When i set Connected to true and Active to True the DBGrid displays the result of the query i put in the OracleDataSet component so that works fine. But if i want to edit the data in the DBGrid i cannot Update it nor can i Insert a new line.

The readonly properties are set to False

If i do this with BDE component then i can Update and insert Data.

please help,

greetz Marco

 

[Marco]

SOLVED: just put a rowid in the query and the data in the DBGrid is editable

so SELECT rowid, *.tablename from tablename does the trick