TOraTable and TOraChangeNotification/RowID

starfish4711 · Post by **starfish4711** » Mon 28 Sep 2009 14:42

Hi,

I'm using TOraTables with specified KeyFields properties (therefor not using ROWID at this place). All table objects have persistent fields.

Now I want to use the TOraChangeNotification object. Basically notification works fine.

Documentation says that I have to include the ROWID field in queries to optimize the automatic refresh (limit it to changed records instead of doing a full table refresh). For TOraTables I guess this means adding it to the field list. But how can I add the ROWID field to my field list? If I do so manually, Delphi complains on opening the table ("field ROWID unkown"). Even without using persistent fields and using FieldByName() I can not access the ROWID field.

Therefor: how can I access this field?

Plash · Post by **Plash** » Tue 29 Sep 2009 07:48

You should set the KeyFields property to ROWID. You can do this using TOraTable editor.

starfish4711 · Post by **starfish4711** » Fri 09 Oct 2009 16:40

I have changed TOraTable.Keyfield property to "rowid" and now the column can be accessed.

But I am sorry to say that the automatic refresh does work very unreliable and with bad side effects. I will send a demo app to support.