Pages

Pages

The are 2 types of pages

Menu pages

Defined in configuration file spcmd.def with a unique key, they are only containers for others menu pages or script pages
HR;FN_MENU;INTERNAL;Human Resources;I
Item can be assigned in Menu pages with a relation definition on file spcmd.def
REL;HR;HRD;D;NULL;HRD;G
You can browse menu moving cursor and choose an item by pressing ENTER or corresponding shortcut key
The initial page (level 0) is named ROOT
page "Connection Selector" is a particular page of menu type, and contains links to connection scripts

Script pages

A script page il scrictly related to a sql script file.
Every script page must be defined in configuration file spcmd.def with a unique key and have a related sql script, with 2 optional parameter &1, and &SQL_ACTION
HRE;HR_employees;SQL;HR EMPLOYEES;I;
First 2 rows resulting from execution of script will be considered as data header and are fixed
Initial blank rows or starting with "H;" will be hidden

Links

In addition to pages assigned to menu pages, you can link pages each others, by rules bases on the presence of a specific column in reports
For example, every time your browse a report with the column LOCATION_ID, and press key S, spcmd will open the script defined with code HRL, passing the value of LOCATION_ID present in the selected row, with parameter SQL_ACTION=HRLD
C;LOCATION_ID;S;HRL;HRLD;COL_KEY
This will work in all the reports containing the column LOCATION_ID, with a single line in configuration file spcmd.def

back to [Home]