Access Templates
System Utilities Access Templates
27. TCL <\?~. Here is where you can key in a TCL statement to execute when 'a? is entered into this field.
28. password. If you have not allowed maintenance of this field by choosing "4" from field #24 (Entry/ Maintenance), here is where you can key in a password to allow maintenance of this field.
31. Verifv File. This is where you enter the name of a file you want the system to verify against before it will accept an entry with the attribute. For example, in the program GL.Suspense (the General Ledger Suspense Program) the account number attribute should verify its existence against the GL.MASTER file so that false GL account numbers will not be recorded.
32. Display Attribute. This is where you key in the number of the attribute (from the Verify File) that you want the system to display as a response to this entry. For example, you may wish to display Attribute #2 (GL.MASTER Description) as the response to entry of a GL.MASTER number.
33. DisDIav Parameter. This is where you will enter the parameter number you want to build the display fc. the Verify File Attribute.
2. ACCESS TEMPLATES
NOTE: You must have knowledge of TCL statements to use this utility.
Selection #2 from the Program Maintenance Utilities Selector brings you to the PROX Utility Program Generator Screen (Access Templates Screen). This selection allows you to translate a TCL status into a program that can be chosen from a menu. Once you have created an Access Report using this utility, you can re-enter this screen at any time to review or maintain the information.
Next is an example of an Access Templates Screen .
System Utilities Access Templates SY.80
FIG. SY.46 EXAMPI.F.SY.ACCESS
PROX utility program generator
Prox Name |
1. Pgm Title
2. Rev. Date
3. Run Prmpt
4. P/S/R
5. Headings
6. TCLVerb
7. Filename
SORT
PRODUCT
8. BYfields
9. WITH rids
10. LIST flds
11. Repon Options
12. Stack Options
13. Display Access Statement
14. Background Process
15. Available Port #
IC*REORDRP
Inventory Reorder Repon
12119/92
Do you want to print this repon?Footings |
(for sorting the repon)
(for selecting only specified data)
(fields to print on reporVinquiry)
(output modifiers 1 ID-SUPP, DET-SUPP, etc.)
(PROC commands)
Time and Date
Profi'C Software (tm)
Next we will Be through step by step of writing an Access Report.
The system will place the cursor in the Prox Name field and display the Prompt:
|Enter program name or End |
Prox Name
From Prompt |KEY IN | "Y" <RTN>.
| KEY IN | the name of the PROX (Access Report) file you want to create
<RTN>. The naming convention for PROX files is: 12*456 . .,
where 1 and 2 represent the MODULE CODE (ea. IC = Inventory
Control). "*" always appears in the thirdcharacterposition. "456
. represents the parameter name (ea. REORDRP).
The system will display the Prompt
|DO YOU want to add this
record? Y/N |
SY.390101
