Simple table editing using VCL DBGrid

[PatrickMMartin]

Hi,

I am looking into Windows oracle access tools, and so far DAO and PLSQL developer seem to be very impressive products.

However, I'd like to replicate the ease of a simple table edit form in Oracle Forms.

Apologies if this is an RTFM question.

I would like to replicate the functionality of a BDE TTable connected to a DBGrid:
i.e. I can enter new records, edit values etc.

It's not clear to me how I do this:
I have tried TOracleDataSet connected to a TDBGrid with a "select * from emp" query, but the dataset seems to be read only, and does not allow inserts.

The Datasource and the DBGrid options are set to the values allowing edits, as far as I know.

So what should I be doing?

Cheers,

Patrick

 

[PatrickMMartin]

I've just found another similar post referring to the RowID needed in the select to allow updating.

I will have to test this when I get out of work, so I can't say yet if my problem is fixed.

Please let me know if I'm not on the right track in the meantime.

 

[Jens Fudickar]

Hi Martin,

have a look at http://www.oratool.de

It contains a module to drictly edit a table.

Greetings
Jens

------------------