Devart Forums

Delphi XE2, ODAC 8.2.7
I see all columns (t.*) without 2 rowid columns (rowid and "myrowid") in DBGrid.
What I did not do?
Or this is bug?

hello,

Since this field is "service", its visible property is set to False, if you want to display such fields, you should add these fields in the editior:
OraQuery.Fields - > Add All Fields

My dataset is dynamic and sql statement in this dataset can be any, and should not be have design time fields.

1) How I can do this in runtime after dataset.open?
2) May be necessary to add a property for this (ShowServiceFields)?

hello,

1) For displaying this fields after opening the table, you should set the Visible property of this fields to true

OraQuery1.Open;
OraQuery1.FieldByName('ROWID').Visible := true;

2) We will review the possibility to add such option in the future.

Hi AlexP,

Have you guys created anything to allow "service fields" to have the visible property set to true by default?

And also is there a way to check if a field is a service field?
If I execute a statement like this "select rowid as RW from dual" you guys know that RW is a alias for the service field rowid.

Is there a way to know original field name and alias name?

Hello,

To retrieve the real field name, you can use the following code:
We have added the HideRowId option (True by default), that is responsible for displaying the ROWID field. This option will be included in the next version..

Excellent thanks

If you have any further questions, feel free to contact us.