Download Total Visual CodeTools Manual

The new code is displayed in the “Reformatted Text” section.
The following options are available:
Define Variable
The “Define Variable” option adds a Dim statement for the variable name.
Double Quotes to Single Quotes
If your string contains double quotes, you cannot simply put quotes around
the text and assign it to a variable. For instance, your text may be:
WHERE (Categories="BOOKS")
The builder automatically converts double quotes to two double quotes so
that your string assignment works:
"WHERE (Categories=""BOOKS"")"
However, the duplicate double quotes can be hard to read.
Selecting this option converts all the double quotes to single quotes:
"WHERE (Categories='BOOKS')"
Replacing Tabs and Eliminating Extra Spaces
There are two options for eliminating tabs and extra spaces:
By checking “Replace Tabs”, any tabs in the text is converted to a space.
This is helpful for standardizing a block of text containing a combination of
spaces and tabs for indenting.
By checking “Eliminate extra spaces”, only single spaces are permitted.
When more than one consecutive space is encountered, the extra spaces
are deleted.
82  Chapter 4: Code Builders
Total Visual CodeTools