Join statements in Query Builder are all on one line, instead of each one starting on a new line (4242084)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Join statements in Query Builder are all on one line, instead of each one starting on a new line
Description

There is an issue with the way the Query Builder formats the SQL for INNER JOIN statements. Instead of dropping down to the next line to start the INNER JOINs, it just keeps adding to the same line and extending to the right.
Cause

This issue has to do with the QP5.dll formatting file.
Resolution

RESOLUTION #1:
Upgrade to version 3.3 or higher.

To download an installer, to upgrade, click here.

RESOLUTION #2:
Replace your current QP5.dll file with the one that is attached to this solution. This file is located in your installation folder, C:\Program Files (x86)\Quest Software\Toad Data Point 3.2 by default. Make sure that Toad Data Point is closed and the file is unzipped, prior to placing it in the folder.
Attachments

QP5
Additional Information

Was only able to replicate this issue with SQL Server and DB2 tables. Oracle formatted correctly.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title