Devart Forums

I want to build dinamically a query at runtime (e.g. SELECT ROWID FROM SCOTT.EMP) and then to show result in a grid. But after I open a query there is no fields in the grid. The reason is that field is not created after query is open. Is there option this field to be created automatically?

There is no any option in ODAC to automatically create ROWID field, but you can create it manually at design-time or at run-time, and the second way is to modify your SQL with ROWID alias specification, for example "SELECT ROWID AS RowID_Field FROM SCOTT.EMP"