Displaying RowID

[ThomasPfister]

hello,
I use a table belong to someone another (mean only read-only and without alter-table possibilty).
In this table there are now PK-Information (like ID, sequence-number). In the Grid-component (devExpress Grid V4) I need a unique field. How can I use the hidden RowID of the doa-dataset for the grid (without showing the information for the user).

thanks for any hint!

thomas

 

[jpickup]

If you explicitly select the rowid and alias it then it is accessible. For example
SELECT rowid AS UniqueID, ...

 

[ThomasPfister]

thanks for your help, but the TOracleDataset hidden the RowID or UniqueID...

:-( thomas

 

[Marco Kalter]

You can use:

select rowidtochar(rowid) as uniqueid

Now it is no longer a ROWID type, and will be treated like any other string field.

------------------
Marco Kalter
Allround Automations

 

[ThomasPfister]

thanks,
it works as planned!!

thomas