|
|
|
|
VBRSGen is a handy VB 6.0 Add-In that creates formatted ADO/DAO recordset and SQL code from Access database tables and queries. Generates variables, sets objects, etc. Also includes a simple "Where" clause creator tool and a results preview grid. Code is ready to paste from the Clipboard or Notepad.
Some SQL statements aren't parsed properly, but these can be easily edited; this still saves a lot of time in repetitive ADO/DAO database coding.
I'm making this available elsewhere as shareware for $20, but because the PSC community has provided so much invaluable support and helpful code, feel free to download the open source code here for your own personal use at no charge!
This was originally posted in early April 2002 and received amazing feedback and dozens of "5-Globe" votes, until the PSC database had some problems. So please vote and leave feedback to let me know what you think!
|
 |
| |
|
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
- Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Other 26 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 5/1/2002 2:15:41 AM: Phobos
5 stars from me and hopefully you get code of the month - This is the sort of coding that deserves to win and I hope others give it deserved votes as well.
Phobos
(If this comment was disrespectful, please report it.)
|
5/1/2002 10:00:34 AM: amacneil
Looks really interesting, but it says it can't find res file when it loads up
Any ideas
(If this comment was disrespectful, please report it.)
|
5/1/2002 10:05:20 AM: Mical
Great Job!
It doesn't like field names with spaces. i.e. "Last Name"
(If this comment was disrespectful, please report it.)
|
5/1/2002 10:50:24 AM: Louis Boldt
It is nice to see code written that uses naming conventions, indentation and all the other little things that show a PRO has been at work. 5G.
By the way field names with imbedded spaces should be enclosed in [square brackets].
(If this comment was disrespectful, please report it.)
|
5/1/2002 11:28:52 AM: Brian Battles WS1O
Hmm, I think you can delete the reference to a .res resource file, that was in there for an About form taht I removed from this version.
(If this comment was disrespectful, please report it.)
|
5/1/2002 11:33:33 AM: Brian Battles WS1O
I'm working on revising the part that parses the SQL so that it keeps the brackets and properly handles words with spaces, quotes, etc. Not all done yet, but at least this version is reasonably function and still saves you a lot of time and typing! And I really appreciate all the kind words and votes! It would be nice to get into the code of the month listing for the first time ever! Please keep up the helpful feedback...
(If this comment was disrespectful, please report it.)
|
5/1/2002 11:40:14 AM: Brian Battles WS1O
I guess I missed out on the April Code of the Month contest, either this just didn't get enough votes, or that database/vote hacking problem PSC had last week blew me off. But I'll try to submit a new version of this project when I make some more changes and improvements, and then submit it and see how it goes over with the changes I plan to make. Meanwhile, keep up the great feedback and suggestions, it really is very helpful!
(If this comment was disrespectful, please report it.)
|
5/1/2002 12:55:35 PM: Oscarreño
Brian, i'm glad to see you again with one more of your quality submissions. I'll vote, absolutely.
(If this comment was disrespectful, please report it.)
|
9/18/2002 9:31:45 AM:
hey, everybody loves time-savers.
(If this comment was disrespectful, please report it.)
|
3/5/2003 11:38:48 AM:
the prg. is too cool....keep it up and special thanx to the author for providing it for free......thanks a Lot..cheers
(If this comment was disrespectful, please report it.)
|
10/7/2004 9:49:28 PM: Paul Turcksin
Thanks for sharing this excellent work. 5 big ones from me.
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
By 65 Users
