Hello together,

I do have some problems using Borland's DB-Aware component. I am connected to an Oracle Server through a TOracleSession object, and I'm working with a TOracleDataSet which calls "select * from mytable".

So, I putted an TDataSet on the form, linked it to the TOracleDataSet and tried to use the DB-Aware components - That work's fine, but all the components are read-only. I can't modify anything, though I'm sure the connected user has all neccessary privilegues on the database. The ReadOnly property on the TOracleDataSet object is set to false.

Is this the wrong way to use the DB-Aware components for editing data ? I would be glad if you could help me.

Greetings

Dominik

This is indeed the wrong way. For your SQL, use
select mytable.rowid, mytable.* from mytable
This makes the dataset updatable.
I gather you have jumped in without looking at the help. Have a look - it's is really good!

------------------
Frans

This is indeed the wrong way. For your SQL, use
select mytable.rowid, mytable.* from mytable
This makes the dataset updatable.
I gather you have jumped in without looking at the help. Have a look - it's is really good!

------------------
Frans

Well, I guess I should have done this before... *sighs*

But at all, it works great, thank you really very much.

Greetings

Dominik