HALLOGRAM PUBLISHING
SHOPPING CARTSITE MAPCONTACT USPRODUCTS
HOMEBARCODESDEVELOPER TOOLSUSER TOOLSTRAINING
Query Maker

Data Dictionary Specifications

Query Maker is controlled by a two table data dictionary system. Currently both tables are local Paradox tables. In the future, a special Corporate Edition will offer the ability to store the dictionary as SQL server files. Both editions, however, will be able to query SQL server databases as well as local Paradox and dBASE tables. In fact, any database that can be accessed with the Borland Database Engine via Delphi's TQuery component can be queried by Query Maker.

The parent dictionary table, contains one record for each separate data dictionary. A dictionary consists of a set of database tables that are linked together by common fields. When your users work with Query Maker, they will only see a filtered list of those saved queries belonging to the currently selected data dictionary. You can give them the option of switching between dictionaries or you can control this yourself.

The parent dictionary table contains the database alias or paths, the table relationships (or join) information and security parameters. The dictionary's table structures are below.

___________________________________________________________
QM_DICT.DB - The Data Dictionary Field Specifications
___________________________________________________________
                          Structure for Table: QM_DICT.DB    
                                  Primary Key: FIELD_DICT  
                              Secondary Index: FIELD_ID    

____________________________________________REQUIRED FIELDS
Field        Type  Size  Description
___________  _____ _____ __________________________________
FIELD_TABLE  Alpha   40  Name of table that field is in.
FIELD_NAME   Alpha   40  Actual name of the field.
FIELD_TYPE   Alpha    9  Field's data type.
FIELD_LEN    Integer     Field's length.
FIELD_DESC   Alpha   50  Description shown to the user when 
                         selecting this field.

_____________________________________FILTER BUILDING FIELDS
Field        Type  Size  Description
___________  _____ _____ __________________________________
FIELD_MASK   Alpha   24  Value for EditMask property.
FIELD_HINT   Alpha   60  Hint for entering a comparison value.
CODE_FIELD   Alpha   24  Code to trigger a lookup picklist.
FILTER_WITH  Boolean     If true, user can pick field for filter.
FIELD_CASE   Boolean     If true, match UPPER/lower case exactly.
CAN_USE_EXPR Boolean     If true, user can enter expression
                         for the comparison value.

___________________________________REPORT FORMATTING FIELDS
Field        Type  Size  Description
___________  _____ _____ __________________________________
FIELD_CAPT   Alpha   16  Caption for report columns.
OUTPUT_EXPR  Alpha   70  Expression for calculated fields.
COL_ALIGN    Alpha    1  Report column alignment (L=Left,C=Center,R=Right).
ACCESS_CODE  Alpha       Security clearance access code that
                         user must be assigned to see field.

_____________________________AUTOMATICALLY GENERATED FIELDS
The following two fields are automatically assigned and 
maintained by Query Maker.  

Field        Type  Size  Description
___________  _____ _____ __________________________________
FIELD_DICT   Alpha    5  Used to sort the field pick list.  
                         The first two characters hold the 
                         data dictionary identifier that 
                         must match the field DB_DICT_ID 
                         from QM_DB.DB below. The remaining 
                         three characters hold a sequence 
                         number that can range from '001' 
                         to '999'.
FIELD_ID     Alpha    9  Unique field identifier.  Used to 
                         link this record to the field's 
                         selected for a query.

___________________________________________________________
QM_DB.DB - The Data Dictionary Headers
___________________________________________________________
  Each dictionary is defined by one record in the QM_DB.DB
  table.
                          Structure for Table: QM_DB.DB     
                                  Primary Key: DB_DICT_ID

Field Name   Size  Width Description
__________   _____ _____ ________________________________________
DB_DICT_ID   Alpha     2 Unique Data Dictionary identifier that
                         links this record to the above 
                         QM_DICT.DB table via QM_DICT.FIELD_DICT.
DB_ALIAS     Alpha    75 Database alias or path.
DB_DESCRIP   Alpha    55 Database description.
DB_TYPE      Alpha     1 Database Type: L = Local (Paradox or dBASE)
                                        C = Client/Server (SQL Server)
DB_LOCATION  Alpha     1 Location where database tables are stored:
                         P = Single path, A = Alias, M = Multiple paths
DB_JOIN      Memo    240 Table join string.
DB_SECURITY  Alpha     1 Security code needed for access.
DB_PATHS     Alpha   240 Optional individual table paths if an
                         alias is not defined and the tables are
                         stored in more than one folder.
_________________________________________________________________


Return to the Query Maker for Delphi Main Page
User Interface for Creating Queries
Driven by a Data Dictionary
Database Storage Enables Quick Access to Prior Queries
Easy to Integrate and Call
Disabling the User Interface

A version is also available for FoxPro/Visual FoxPro


Prices include full source code and a royalty-free license.

Query Maker for Delphi ... $249

Home || Shopping Cart || Site Map || Newsletter/Blog
Search HALLoGRAM || Request More Information
CALL TOLL FREE 1-866-340-3404

©Copyright 1997 HALLoGRAM Publishing, Aurora CO. All Rights Reserved.