Record has been changed by another user

[Jim Ashton]

Hello - I am seeing this error message persistently when I am the only user connected to the database (Oracle 8i, Delphi 5 App.).

The statement generating the exception is attempting to execute the Edit method of a TOracleDataset.

What could be causing this?
Thanks
Jim Ashton

 

[Marco Kalter]

This can happen if the query for your dataset includes an expression with an alias that renames the expression back to the base column. For example:

select deptno,
       upper(dname) as dname,
       loc
  from dept

In this case the expression upper(dname) has an alias dname, and when the dataset checks if the value has changed, it thinks that this is the case.

If this situation applies here, you can either remove the expression or use a different alias.