Civic Infotech

Export Projects

Export Oriented Projects

Programme to generate database for Query Builder system
Year	:	2003
Duration	:	1 Months
Role	:	Development & Design
Company	:	Project O/s Company Location: Export Project (Paris)
Language	:	Visual Basic-6 / Ms Access/ADO DSNLESS & ADODX.
Team	:	2 Person
Description	:	This is external generalized utility developed for Overseas client (PARIS) This is backend programme which takes MDB/Database files for which query to be developed. Here System Analysis selects the table to be used for query. Gives them User friendly name. Make one table as master table & others as sub tables. Gives relation to them. Also selects the fields to be displayed when user select any table for query. Also the order of fields can be changed at time of display.
Main Feature	:	This software is backbone of Query Builder. As user of query generation doesn't know how to utilize the query for different databases. But the System Administrator can use this software to generate the database which can be used by query builder and then in turn user can use any no of new database table. Both the programme is developed in such a manner that with changes in messages, caption can be utilize in another languages like English(default),French/Protégées. Similarlly store query stores full path, table information, field information so if any thing not found or tempered in original database then the stored query then in list this particular query won't appear for selection.