Civic Infotech

Export Projects	Financial	ERP-MRP Solutions	Enginnering	H R Solutions

B2B Web Solutions		Data Entry Solutions	Bio Metrics Solutions	S/W Piracy & Protection

Export Projects

Export Oriented Projects

Generalized Query Builder
Year	:	2002 & 2003
Duration	:	4 Months
Role	:	Development
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). Here user can define its on generalized query depending on his own requirements with facility to make filtrations of records with OR/AND & selection criteria. Also he can transfer output as SQL or as Table & get printout. He can re-use query when-ever he wants once he saved it. The selection criteria automatically take data format according to type of data ie numeric or date or it takes from database form the list provided by us. Here user have to simply select the table/tables ,Select the filed for criteria also select the fields to be shown in output & make filtration criteria.
Main Feature	:	In this Software user friendlily interface is the basic criteria for development. Also the software is developed to be a part of big module and also it can be utilize as standalone module also. In this user has to simply select the table to which he/she wants to generate query. The table name is also user friendly. Then user has to select fields on which he wants to make query. Again the field name represents user friendly name such as instead on Dinvoice_dt it will show date of Invoice. Then according to type of field , menu for criteria appear on screen again this has user friendly name. The user has to add the criteria with AND/OR with existing added criteria if any. Then preview result shows the records which matches the criteria. Also query shown in user friendly message form as well as in SQL Query Form. The beauty of thisprogramme is that it is possible to store query build . Then stored query can be reused afterwards. This query can be stored on user base and reused by an user but modified by the user who has admin rights or the original user who has created this query.