by Chris Shell (4 Submissions)
Category: Complete Applications
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(7 Votes)
Formats SQL Strings so that they can be placed into you code quickly and easily. How many times have you spent several minutes formatting a SQL statement in your code.
You know, you get the SQL working in Access, SQLTalk, or Query Analyzer and then you need to add it to your code and make it do something. You have to store in a variable and in order to accomplish this you need to assign it to the variable. This means going line by line (and getting errors in VB) and formating the SQL statement so that it gets assigned to the variable.
With my new program you never have to do that again!
It does it all for you, check the screen shot and then start using it everyday! If you like it then vote for me and visit my site www.cshellvb.com!
There is a Tool out there that does this (I won't mention the company here) but is part of a suite and costs $299! I did not need the suite so I wrote the tool myself!
Inputs
NA
Assumes
As you will see, my code simply takes an inputed length and starts chopping it up. The result may not look like your result but most of the work is done for you and now you can touch it up.
Vote for me!
Code Returns
NA
Side Effects
Side Effects.... Ya, you will code faster then ever before and you will never have to format those SQL statements again!
VBcoders