Problem with rowid

ivsal · Post by **ivsal** » Thu 27 Jan 2005 14:07

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?

Alex · Post by **Alex** » Thu 27 Jan 2005 16:14

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"