MIDAS

[simma1]

Here is the SQL on my server app:

SELECT TEST.ACTION.*, TEST.ACTION.ROWID
FROM TEST.ACTION

I'm using the TOracleDataSet component.
When I try to update a record (I change a field with the TDBGrid) I always get the error:

"Record changed by another user"

I'm sure to be the only user working in that table.

Thank you for your help,

Martin Simard

 

[Marco Kalter]

Is this the exact SQL statement, and if so, are you updating a record that was just fetched?

You can get this message if a trigger modifies column values on the server during an update or insert, or if you have defined column defaults and have just inserted the record. To fix this, include roAfterInsert and/or roAfterUpdate in the RefreshOptions. The dataset will now immediately reflect the changes made on the server.

You can also get this error if you have used expressions in the SQL statement that have an alias with the original column name, for example:

select upper(ename) ename, ...

In this situation the dataset thinks that the ename field is updated, because the value in the dataset is different from the database. To fix this, include roAllFields in the RefreshOptions.

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