-
Title
Query Builder Where conditions or calculated fields are not saved. -
Description
A Query Builder model is created with Where conditions or calculated fields and the DML file is saved. Once DML file is reopened some of these conditions and calculated fields do not appear in Query Builder.
Query was rebuild again and saved as a SQL file. The SQL files was opened in Editor and the "Send to Query Builder" option was used. Again some of the Where conditions and calculated fields do not appear in Query Builder.
Toad does not report any error messages.
These Where conditions use IN, BETWEEN, IS NOT NULL and such Oracle functions. -
Resolution
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Oracle. -
Additional Information
The Beta 9.7 release of Toad opens DML and SQL files correctly. The Beta release is available via: http://www.toadsoft.com/beta.html. Beta releases are not officially supported.