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