Beta, Picker button for Foreign Key values issue

Insert a record using the grid navigator buttons, if a column is FK'd you get a picker button, but if the table you pick from has a case sensitive PK, it fails.

select *
from "DEV"."NetUsers"
order by Id;
-- ORA-00904: "ID": invalid identifier

Here Id is actually case sensitive "Id" (not my design! ). Such references to columns / tables should always be double quoted.

Hi Paul,

I see that and will fix. Thank you.


1 Like