QP5.dll & FmtOptions.exe parser issues (4250675)

Formatting issues with QP5.dll and FmtOptions.exe.

====================
Formatter issues (15 total):
====================

55,343
Options GUI: Changing the margin tab should enable the save button.

55,221
When a chunk doesnt get formatted then the trailing newlines cached by the previous chunk are lost causing its text to stick to the previous chunk text.

55,158
Options GUI: Create a missing FmtOptionsExampleCode directory automatically instead of prompting to user to do it.

55,070
Formatter options GUI: changing the margin fails to enable the save button.

54,604
Options GUI: Add command line param to specify the app data path

54,120
Formatter options GUI: users want global example texts, not changing when changing option panes.

56,264
Large packages take a very long time to format (1+ hours)

56,940
Parameterized OPEN statements prevent proper formatting

56,939
Long condition lists in CASE statements are not wrapped when formatted

55,865
Formatter hangs when more than 65,536 items in a statement list.

59,007
Hangup after formatting a specific large file.

59,632/60,309
Oracle FETCH INTO doesnt format.

60,046
Formatting issues with TYPE .... IS RECORD.

Other

Change: Options GUI: In the list parentheses control a 6th mode has been added, as it was missing. Mode 2 corresponds to mode 4, and mode 3 to mode 5. A mode matching mode 1 was missing. Now this mode has been created as mode 4, and the former 4 and 5 have moved to 5 and 6. So matching pairs are now 1-4, 2-5 and 3-6. INI values are updated automatically.

Fix: List folding issues fixed: Table style formatting was broken (both Table and Column adjusting Table) The default list options didnt work When the margin is very small then wrapping mode will now properly stack items RETURN(ING) INTO

==================
Syntax issues (18 total):

WORKAROUND:

A hotfix is available on SupportLink that addresses this issue.

Follow the link to the Patches section of 9.7.2 on SupportLink:

https://support.quest.com/SUPPORT/index?question_product=Toad+for+Oracle&xmlattribute%3ASOLUTIONS%2FPRODUCTS=PR268435520&page=downloads&category=3&version=268452139

NOTE:Please download and reviewthe ReadMe.htm before applying the hotfix.

To install this hotfix,follow the steps below:

1.) Shutdown all instances of Toad for Oracle. Go to your installation directory of Toad for Oracle 9.7.2.5 and rename QP5.dll, FmtOptions.exe to QP5.old , FmtOptions.old.

2.) Extract QP5.dll and FmtOptions.exe from the zip file to your desktop. NOTE: If you extract directly to your Toad 9.7 installation Directory then skip step 3

3.) Copy both the QP5.dll and FmtOptions.exe to your Toad for Oracle 9.7.2.5 install directory (where the current QP5.dll and FmtOptions.exe reside).

4.) Windows will ask if you want to replace the files. Click Yes button.

5.) Start up Toad for Oracle.

To determine if this hotfix is installed, do the following:

1. Check that version on both the QP5.dll and FmtOptions.exe is 5.126

STATUS:
Waiting for fix in a future version of Toad for Oracle.