SQLB is a SQL Beautifier that formats SQL statements.
It has the following functionalities
If there are multiple SQL statements, each of them must end with a semicolon. SQLB treats the text starting with the string "EXEC SQL" as embedded SQL, and formats the text up to an ending semicolon, the text not in the range is kept unchanged.
This command beautifies the SQL statement text that resides in the clipboard and paste it into the edit window.
When there is no selection in the edit window, this command tries to beautify the whole text. Otherwise, it beautifies the selected text (those highlighted) only.
This command performs the function as the "Beautify" command, but it also copies the formatted text into the clipboard. It serves as a quicker access to the combination of Beautify+Select+Copy comands.
This command pops up the "Batch job" dialog box. You can browse the dircetories and add files to the list of files to be beautified shown at the bottom of the dialog box. By clicking the "Beautify" button, all the files listed will be processed. A file can be deleted from the list using the "Remove" command. The list can be saved to a file by click at the "Save List" button, this file can be loaded later by the "Load List" command.
Most of the option names are intuitive, please try them out. Here we just mention a couple of them.
Style / Multiitem in a line:
if this is checked, each line may contain multiple items, as in the floowing,
SELECT DEPT_NAME, DEPT_ID FROM DEPARTMENTS
Otherwise, the result will look like,
SELECT DEPT_NAME,
DEPT_ID
FROM DEPARTMENTS
Indentation:
This is the leading space before a SQL statement.
By pressing down the right mouse button while the cursor is inside the edit window, a pop-up menu will be displayed. This provides easy access to available editing and beautifying commands.
You may use SQLB for a 30-day evaluation period free of charge. After that, if you still like it, please send the registration form along with payment to the author. The registration form can be found in the file REGISTER.TXT came along with SQLB.
For now, please send all suggestions, bug reports and other inquiries by email to
OR to the postal address given in file REGISTER.TXT.
Copyright (C), Dongxiao Yue, 1996, all rights reserved.