Long Text/SQL Builder

Many developers consider the Long Text / SQL Builder to be the most commonly used feature within Total Visual CodeTools. It's a very common need to convert SQL text from a query and assign it to a variable in your VB6/VBA code. But it's a real pain to manage issues like quotes inside quotes, word-wrapping, and formatting the text.

The Long Text / SQL Builder handles these issues for your SQL strings or any text that you want to convert to a variable assignment. Simply paste your text in the top box, and it is automatically assigned to a variable and word-wrapped according to your settings. Our SQL parser understands SQL strings and can wrap SQL on key words like FROM, WHERE, GROUP BY, etc. to make it much more readable:

Details...