TOracleDataset.ROWID

[Arvid]

Hi,

I'm using Delphi 2005 and Direct Oracle Access 4.0.7.1

I can not get "TOracleDataset.ROWID" to work properly.

Basically - what I try to do....

OracleDataset1.SQL.Add('SELECT A.ROWID, A.* FROM...)
OracleDataset1.Active := TRUE;
OracleDataset1.First;
WHILE NOT OracleDataset1.EOF DO
BEGIN
Output(OracleDataset1.FieldByName('KEYFIELD')
Output(OracleDataset1.Rowid);
OracleDataset1.Next;
END;

What happens are that "rowid" is the sam for all "KEYFIELD" values. Why? How can I get the "real" ROWID?

 

[Marco Kalter]

Works fine for me when I try this in the DeptEmp demo for the DeptDataSet. Can you verify this?