Numeric Values
Most of the fields are numeric. The values of the flags given below are bit maps built up from answers to the Yes/No questions. Values of other numeric fields normally correspond with the option numbers in the menus that select them in PROGMAKE.
Program Types
| 1 |
Data Entry |
| 2 |
Enquiry |
| 3 |
Batch |
| 4 |
Report |
| 5 |
Library |
Program Flags
| 1 |
For read only programs |
| 2 |
For exclusive programs |
| 4 |
Stop program if update fails |
| 256 |
Print device required |
| 512 |
Print device selected at run time |
| 1024 |
Use menus for questions |
| 2048 |
Private database |
| 4096 |
Suppress update fail |
| 16384 |
Use QXE files to load |
Procedure Types
| 1 |
Interactive |
| 2 |
Batch |
| 3 |
Menu |
| 4 |
Print |
| 5 |
Combined menu/entry |
| 6 |
Action bar menu |
| 7 |
Save/Exit menu |
| 8 |
Sub device output |
| 9 |
Device select/print |
| 10 |
Run another program |
| 11 |
Link to C |
| 12 |
Hot key set up |
Procedure Flags
| 1 |
Database procedure |
| 8 |
Allow deletions |
| 16 |
Auto inc |
| 32 |
Enforce auto inc restriction |
| 64 |
Update database |
| 128 |
Secure changes |
| 256 |
Repeated procedure |
| 1024 |
Confirm deletes |
| 2048 |
Delay print out/Clear after subsidiaries |
| 4096 |
Clear map/Top of form at end |
| 8192 |
Always execute subsidiary procedures |
| 16384 |
Confirm updates |
Procedure Modes (Access Methods for Main Table)
| 1 |
Already fetched |
| 2 |
Batch (automatic) |
| 3 |
Normal |
| 4 |
Line (Automatic + Normal) |
| 5 |
Window |
| 6 |
Cleared Window |
| 7 |
Set up mode |
| 8 |
Preview window |
Batch Access Methods/Preview Types (from map)
| 1 |
First and onwards |
| 2 |
Equal and onwards |
| 3 |
Equal and backwards |
| 6 |
Last and backwards |
Map Output Method
| |
Non print Procedures |
Print Procedures |
| 1 |
Top of screen |
Top of form |
| 2 |
Header (Retain) |
Normal |
| 3 |
Repeated (Scroll) |
Beside another |
| 4 |
Attach to another map |
Over another |
| 5 |
On screen already |
Already output |
| 6 |
Pop-up window |
|
Table Flags
| 1 |
Check parent/child match |
| 2 |
Allow join fail |
| 4 |
Update this table |
| 8 |
Verify this table |
| 16 |
Lock records |
| 32 |
Reject locked records |
| 64 |
Warning only validation |
| 128 |
Apply condition to new records |
| 1024 |
Allow existing records |
| 2048 |
Allow new records |
Validation Modes
| 1 |
Already fetched |
| 2 |
Check parent on database |
| 3 |
Join parent from database |
| 4 |
Prohibit parent |
On the main table (which must be table 1) you should set this field as follows:
| Access Mode |
Validation Mode |
| 1 |
1 |
| 2 |
3 |
| 3 |
2 |
| 4 |
2 |
| 5 |
5 |
| 6 |
5 |
| 7 |
3 |
| 8 |
5 |
Values for Table Scan_mode
| 1 |
Exact match |
| 2 |
Scan if no match |
| 3 |
Always offer scan |
| 4 |
Next match |
| 5 |
Previous match |
| 6 |
Multiple choice |
This field should be set to 1 for prevent parent tables
Field Processing Flags
| 1 |
Input field |
| 2 |
Display always |
| 4 |
Prevent change |
| 8 |
Apply formula |
| 16 |
Field is totalled |
Formula Flags
| 1 |
Warning only |
| 2 |
Continue on failure |
Totalling Types
| 1 |
Update (+ change) |
| 2 |
Downdate (− change) |
| 3 |
Report (+ value) |
Function/Macro Types
| 1 |
Macro |
| 2 |
C Function |
| 3 |
Word String |
Documentation Wordtypes
| P |
Program |
| F |
Procedure |
| T |
Procedure body |
Map Flags
| 1 |
Mnemonic selection |
| 2 |
Boxed |
| 4 |
Column major |
| 8 |
Translate function keys |
| 16 |
Wrap cursor at end |
| 32 |
Semitic (Hebrew version only) |
| 256 |
Double height |
| 512 |
Double width |
| 1024 |
Shadow |
| 2048 |
Function key area |