Picture the visual SQL builder inside MS Access and SQL Server. That is what I'm looking for. I need to be able to connect to the database, and visually build/generate Select/Insert/Update/and update queries.
This should be able to connect to and work with any DAO, ODBC, ADO source (SQL Server/MS Access/MySQL/Oracle)
Contact me for any questions or suggestions on making this do-able.
I have the connection interface, so this app should be able to receive connection string/database platform info to do its work
It needs to build parameterized queries in the way each DB platform uses them, and include a 'Test' bed, where the user can test the resulting statement by entering data via the parameters. The list of resulting parameters should be available programmatically, in order to build complete query interfaces in whichever ending platform is desired.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Should be able to run on Windows 32 bit platforms (98/2000/NT/XP)
***VB6 SP5 only***