Friday, January 18, 2013

Toad: Find Backward does not work, the Direction Forward and Backward are greyed out

Toad For Oracle 11
  • Description

    In Find dialog, the Direction Forward and Backward are greyed out.
    Only the Forward option is selected.
    Thus, only F3 works but not Shift+F3.

  • Cause

    User Setting file may have been corrupted.
  • Resolution

    As a test to localize and confirm the issue, doing the following will give you a clean User Files.

    Here are steps to get a clean User Files folder…
    1) Select Utilities | Copy User Settings.
    2) Select “Create a clean set of User Files from the base installation” and click OK.
    3) Toad will automatically restart. Once restarted, test issue.

    You will temporarily lose your connections settings.
    (If error no longer persist, with Toad for Oracle closed: The user can copy their connections.ini, connectionpwds.ini and savedsql.dat files from the 11.5_bak folder into their newly created User Files Folder.)

    Here are steps to get old settings back…
    1) Close Toad.
    2) Delete the 11.5 folder in the C:\Users\<User>\AppData\Roaming\Quest Software\Toad for Oracle directory.
    3) Rename the 11.5_bak folder, in the same directory, to 11.5.
    4) Launch Toad.