Beta 16.0.74.1492, Picker button for Foreign Key values issue

Toad for Oracle - Beta
1

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.

2

Hi Paul,

I see that and will fix. Thank you.

-John

1 Like