rowid lags behind

[E. van der Poll]

Situation: I am using a TOracleDataset (DOA 4.0). My query contains a rowid (select t.*, t.rowid from xxx).

Problem: When I change record I am reading the dataset.rowid and displaying it in my form. It seems the rowid I am seeing is the one for the record I have just left.

Example:
I have three records, with rowid ending on A,B and C. When I have moved from record A to record B, I get the rowid ending on A. When I move to record C I get rowid B, etcetera.

 

[Marco Kalter]

Which TOracleDataSet event handler are you using?

 

[E. van der Poll]

I use the AfterFetchRecord event to trigger what should happen when the data changes. That is where I copy all field values to internal variables.

I also have a DBGrid linked to this dataset. I wonder if that may have some side effects?

We compile using delphi 7.