In the Schema Browser, when the Data tab is selected for a table, the following error occurs:
"qryData: Key field 'ID' not found "
Although the Primary Key has been dropped on the table, the error propagates amongst all servers in DEV, TST and PRD environments. A SELECT statement can be executed on the table, in the SQL Editor, and return a dataset. Thus, this is a problem on this table, in each environment ONLY in the Schema Browser. An ID field was created in a development environment, but not migrated to other environments and it has since been removed from that environment.
WORKAROUND 1:
In the Toad Options, go to Schema Browser | Data and Grid section. If the option "Save Layouts" is checked, then search for the file below and delete it:
C:\Program Files\Quest Software\Toad for Oracle\User Files\
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy