www.hkvforums.com

I have an Oracle materialized view generated by scheduled sql query that I specifically created a unique id field in the select statement using
ROW_NUMBER() Over (Order By NULL) AS Q_REC_ID.
The problem is that in the general field setup it shows as data type Numeric value (adVarNumeric) and has the checkbox greyed out disallowing Primary key selection.
I could select multiple other fields I guess to create a composite, but I thought that creating a unique row_id would have been sufficient.
Why is the box greyed out? I will never add or edit these records as the view is refreshed twice a day. I just want to be able to search the data set when required.
Using asp.netmaker 11 for this project.

Thanks

Frank

I ended up concatenating another value into the key and it changed the data type upon resynchronization.
This allowed me to select the new field as primary key.

Frank -