I need a delphi 4 program that can read database structure. It should work as follows:
1. User selects ODBC driver/username/password OR enters connection details for his chosen database. Ideally it should be able to connect to RDO databases also - please indicate in your bid whether this is possible.
2. The program connects to the database - warning the user if there is a problem.
3. Upon connection, 1 list box should be populated with names of tables, a 2nd list box should be populated with names of views/queries.
It should also display whether the database is capable of "paged" recordsets, and whether it supports SQL queries. (An easy way to do this would be to try it within a try...except).
4. When the user clicks on one of the table/views, it should populate another list box with a list of fields. It should also show on a panel whether it is updatable or read only. (Without actually writing data), and what type of table it is (system, user, view etc).
5. When the user clicks on one of the fields it should display information about that field on a panel - e.g. datatype (string,integer,decimal, boolean...) and relevant size (e.g. 10 chars, 2 decimal places etc), comments, etc.
Important Notes:
It can use 3rd party components if need be, but please let me know in your bid which one you intend to use.
It should be compatible with as many databases as possible particularly Access, SQL Server, Oracle (8 and 9), MySQL. Please indicate in your bid which of these databases you can test it with.
It should be able to handle "linked" tables in access databases.
It doesn't need to look nice - I will take the functionality and incorporate it into another program.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Delphi 4