No Record Found with GUID Primary Key on Oracle Table

ASP.NET Maker General Discussion (ASP.NET Maker)
1

ASP.NET Maker 2020.0.5

I have an Oracle table with a Guid primary key. The data type in Oracle is RAW(16) and the data type in ASP.Net Maker shows Binary value (adVarBinary) with size 16. When I start the webapp and bring up the the list, the PK/Guid field is blank. If I click on the Edit or View button the list refreshes and I get a toast message saying No records found. There is no record value in the url for these buttons.

I have a string version of this column (using RAWTOHEX) in the table that gets set by a database trigger. If I set the HREF field on another field to this string version of the GUID and set the prefix to the edit page, then I can open the edit page with the record data.

Is there a way to use Oracle RAW/GUID columns as PK’s or can I tell ASP.Net Maker that this primary key column is a Guid?

Thanks,
Craig

2

RAW is probably not supported as primary key. Show your table schema for further verification.

Alternatively, try using other data types as primary key if possible.

3

I was able to work around this by converting the existing primary key to a unique constraint and adding an identity primary key.
Thanks,
Craig