Torben,
The TOracleDataset component uses the ROWID internally to update the table when you post updates to a record. It hides the value from you (making the assumption, I suppose, that the only reason you included a ROWID element in your query was because the DOA docs said to <sigh> ). You can access the ROWID value for the current record using the ROWID property for the dataset.
i.e.
myDataset := TOracleDataset.Create(Self);
myDataset.Session := mySession;
myDataset.SQL.Append('SELECT t.*, t.ROWID from myTable t');
myDataset.Open;
while not myDataset.eof do
begin
// vvvvvvvvvvvvvvv
Memo1.Lines.Append(myDataset.ROWID);
// ^^^^^^^^^^^^^^^
myDataset.next;
end;
myDataset.close;
FreeAndNil(myDataset);
It's a pain, but it works. This even works if the only element in your dataset is the ROWID. It looks like you don't have any fields in your dataset, but you do get records and the navigational commands (next, first, etc.) seem to work ok.
Hope it helps...Michael