Stupid new user...

[codwilco]

I apologize in advance. I am a new user to Delphi and to the DOA component. My questions are simple though...

1. I have defined my dataset with a TOracleDataSet Query and attached the req'd datasource. I see my records in a ttable. I cannot edit anything in my ttable though. I have checked every Read Only option and they are all false. I don't know where to go.

2. It is related to #1. When I make a call to the datasource: dmMain.dsRunner.DataSet.Delete;
where dmMain is my data module and dsRunner is my data source, I get the following error:
'A lock, refresh, or check cannot be performed without a rowID. Provide a rowid in the query or handle this action in the OnApply record event.'

I don't know what that means.

Thanks in advance.
Dave

 

[Eric^2]

From the DOA help on TDataSet...

Making a dataset updateable

To be able to update records, a dataset needs to know the 'rowid' of every retrieved record. A rowid is an internal Oracle structure that uniquely identifies a record in the database. As long as you do not include it in the query, the CanModify property of the dataset remains False. To make an updateable dept dataset, the SQL property would be: select dept.*, dept.rowid from dept