Primary Key checkbox greyed out for ROW_NUMBER() (v11)

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
Frank Miramonti
User
Posts: 4

Primary Key checkbox greyed out for ROW_NUMBER() (v11)

Post by Frank Miramonti »

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


Frank Miramonti
User
Posts: 4

Post by Frank Miramonti »

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 -


Post Reply