![]() |
![]() |
| Query Maker |
Data Dictionary SpecificationsQuery 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 A version is also available for FoxPro/Visual FoxPro Prices include full source code and a royalty-free license. Search HALLoGRAM || Request More Information CALL TOLL FREE 1-866-340-3404 |
| ©Copyright 1997 HALLoGRAM Publishing, Aurora CO. All Rights Reserved. |