Show Bid Request
VB Class To Create SQL Insert Stmts
Bid Request Id: 48506
|
|
|
|
Posted by: |
Proz (5 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
|
Posted: |
Feb 16, 2003
10:39:47 AM EDT
|
|
Bidding Closes: |
Feb 21, 2003 EDT
|
|
Viewed (by coders): |
306 times
|
|
Deadline: |
2/28/2003
TIME EXPIRED
|
|
|
|
|
Description:
Create a VB 6.0 Class that reads data via ODBC from 1 or more tables and writes out ANSI Standard SQL Insert statements for that data.
Class has 4 methods:
1) Connect to database
2) Disconnect from database
3) Specify 1 or more tables that will be queried
4) Create the SQL insert text file, from the tables specified - with an argument that determines the pathname/filename of the output text file.
Deliverables:
1) Complete and fully-functional working program(s) in complete source code of all work done.
2) Complete ownership and distribution copyrights to all work purchased.
Platform:
Windows/VB
Must be 100% finished and received by buyer on:
Feb 28, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$100 (USD)
|
Feb 17, 2003
8:32:33 AM EDT
|
10
(Excellent)
|
|
|
Hi,
I'd like to place a bid for this work please. I attach a .zip file containing a demonstration version of the system. This contains a version of the source code of the class itself, a little VB6 test executable that makes use of the class, and an install script to install the test executable. To keep the install small I haven't bundled in the VB runtime files or the Microsoft ActiveX Data Objects library (v2.7) that I employ.
The class exposes the four methods you specify :
1. Connect - pass in your DSN name to connect to the database.
2.AddTable - add a table name to the list. I haven't yet written a means to pass in a list of table names although this would be easy enough to add on.
3. Generate - generate the file containing the SQL INSERT statements.
4. Disconnect - closes the database.
There may be some issues with the way that the data is formatted - eg. how dates are to be represented. However, these will all be small amendments and easily changed to suit.
Please get in touch if there are any problems or questions.
Simon Kewin Microsoft Certified Professional, Microsoft Certified Solution Developer. |
|
|
Attached File
|
|
|
|
|
|
