When you want to make an OracleDataSet updateable, rowid must be added to the query. However when rowid is added to the query, the behavior of a linked data control (such as a dbedit) is not correct. In Browse mode, the dbedit should be read only automatically (the data source AutoEdit is false). There is however one button that works - the Delete keyboard button. It does not change the underlying data, but it does clear the edit box. When rowid is not in the query, the behavior of the dbedit box is correct - no button effects a change even the Delete button.
How can I fix this? Thanks.
How can I fix this? Thanks.