Insert problem :(

[progress]

I use TOracleDataSet component, which contains the following query: Select * From CLIENTS. Then I call the function Insert() in order to insert new record.
But I get the message:
Cannot modify a read-only dataset. The property "Read only" is set to false. So what's going on? !!!

Best regards,
Tomek

 

[Marco Kalter]

See this topic .

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 01 July 2002).]

 

[sersicom]

Originally posted by progress:
I use TOracleDataSet component, which contains the following query: Select * From CLIENTS. Then I call the function Insert() in order to insert new record.
But I get the message:
Cannot modify a read-only dataset. The property "Read only" is set to false. So what's going on? !!!

Best regards,
Tomek

From sersicom

you need add this SELECT statement

Select c.*, c.rowid From CLIENTS.

the ROWID identifie field to control the insert, edit or delete record from a table