VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

Format SQL Strings Format String v1.0

Chris Shell  (4 Submissions)   Complete Applications   Visual Basic 3.0   Advanced   Wed 3rd February 2021

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!

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!

Rate Format SQL Strings Format String v1.0 (7(7 Vote))

Download Format SQL Strings Format String v1.0

Format SQL Strings Format String v1.0 Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters