Search Tools Links Login

Format SQL Strings - Format String v1.0


Visual Basic 6, or VB Classic

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!

Original Author: Chris

Inputs

NA

Assumptions

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!

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 92 times

Categories

Visual Basic 6

Attachments

Format SQL188254252001.zip
Posted: 9/3/2020 3:45:00 PM
Size: 13,800 bytes


Loading Comments ...

Comments

No comments have been added for this post.

You must be logged in to make a comment.