Devart Forums

after using Oraquery->Edit() method on the query result, I received Ora Error: cannot modify a read-only dataset.

In BDE there is a property requestlive for TQuery, it works when this is true. But how can I successfully excute this method( Edit() ) for Qraquery?

Thanks.

TOraQuery is editable only if you set its SQLUpdate property. To delete and insert rows in dataset you should set also SQLDelete and SQLInsert properties. These properties contain SQL that component executes to modify data in database.

To easily create editable dataset you can use TSmartQuery component, which generates these SQLs automatically. For TSmartQuery component to be editable set its KeyFields property or include ROWID in list of SELECT fields.