System files

Certain files are required for the development environment to operate correctly. In some cases, developers will want to interact directly with stored items and the layout of these items is described here.

 

sysatt

The sysatt file acts as a storage area for any files submitted to the system through the multi-part form page option.

Pages can be defined to allow for the submission of files from the browser by setting the "file submit encoding" checkbox option of page properties and using this in conjunction with the <input type=file> HTML form option.

File layout

sysatt

Field Description Information
<0> File name  
<...> Binary data  

 

sysbp / sysdev_bp

The sysbp file contains all of the system subroutines. This filename was changed from sysbp to sysdev_bp for consistency.

Developers must not make use of this file as it is cleared out for upgrades and any programs not specifically required for system operation will be removed. The routines may be provided with source code included to facilitate debugging and problem resolution. This code must never be changed.

 

sysclasses

The sysclasses file stores the object class definitions. These definitions control the operation of run-time and development classes. Class property definitions are parameters for the object property lists used within the development environment.

Developers may add classes to the solution, but should take care not to change the system classes. In new releases some classes may be replaced or upgraded and users' changes to these objects may cause applications to fail.

File layout

sysclasses

Field Description Information
<0> Class name  
<1> Description  
<2> Run time routines  
<3.1> Edit icon up  
<3.2> Edit display routine  
<3.3> Edit launch page  
<3.4> Edit page height  
<3.5> Edit page width  
<3.6> Edit icon down  
<4> Contains sub class  (sysclasses)
<5> Stand alone item on/""
<6> Not used  
<7> Not used  
<8> Not used  
<9> Not used  
<10.1 - 10.n> Property descriptions  
<10.1 - 10.n> Property capture types  
<10.1 - 10.n> Property field positions  
<10.1 - 10.n> Default value  
<10.1 - 10.n> Parameters  

 

syscontrols

The syscontrols file contains various records storing information about the user's environment.

File layout

sysatt

Field Description Information
<0> "parms"  
<1...> As defined in common block variable sysphantom  
 
<0> "locks"  
<1.1 - 1.n> File name Name of locked file
<2.1 - 2.n> User name User who has locked the file
 
<0> "sysemail"  
<1.1 - 1.n> email filenames  
<2.1 - 2.n> email directory locations  
 
<0> "pagerr.html"  
<1> Error page Default HTML for system related errors

 

sysexports

The sysexports file a list of all the exports that have been defined on the system.

File layout

sysexports Field Description Information <0> Export ID <1> Description & Version Info Description VM Version Export VM Build No <2> Export Type MV <3> Export Container MV <4> Export Class MV <5> Export Object MV

sysexports

Field Description Information
<0> Export id  
<1.1 - 1.n> Description and version info Decription {vm} Version export {vm} Build no.
<2.1 - 2.n> Export type  
<3.1 - 3.n> Export container  
<4.1 - 4.n> Export class  
<5.1 - 5.n> Export object  

 

sysgroups

The sysgroups file contains the definitions of user groups.

The "developers" and "users" groups are default groups defined within the system and should not be altered.

File layout

sysgroups

Field Description Information
<0> Group name  
<1> Description  

 

syshelp

The syshelp file contains the HTML text records that get displayed when using the help object. Users may create their own help records in this file or create application specific help files.

File layout

syshelp Field Description Information <0> Help Record Name <1-> HTML text to be displayed for help record

syshelp

Field Description Information
<0> Help record name  
<1 -...> HTML text to be displayed for help record

 

syslanguage

The syslanguage file contains the translation records for specified words and phrases. It also contains copies of each object with the translations for the relevant properties.

File layout

syslanguage

Field Description Information
<0> Language id  
<1> Default word or phrase  
<2 -...> One translation per language specified  
 
<0> sysobjects ID:language ID  
<1 -...> Full copy of object properties as per sysobjects  

 

sysmodules

The sysmodules file contains the definitions of system and application modules.

The "sysdev" module is pre-defined and should not be removed or modified.

File layout

sysmodules Field Description Information <0> Module Name <1> Description

sysmodules

Field Description Information
<0> Module name  
<1> Module description  

 

sysobjects

The sysobjects file contains the definitions of objects.

File layout

sysobjects

Field Description Information
<0> Object class:Object name class from sysclasses
<1> True class sysclasses
<3.1> Created by  
<3.2> Creation date  
<3.3.1 - 3.3.n> Last update date  
<3.4.1 - 3.4.n> Last updated by  
<3.5.1 - 3.5.n> Last updated time  
<4.1> Field number 0/1 - 9999 / s1 - s9999/ p1 - p9999 / r1 - 9999 (.x)
<4.2> Dependant field number as above
<4.3> Ignore field replication For tables only
<4.4> Invisible Yes / No
<5> Application module (sysmodules)
<6.1 - 6.n> Security groups (sysgroups)
<7> Not used  
<8> Locked by (sysusers)
<9> Default cell LOWERed once
<10> Object properties Structured according to class definition (sysclasses)
<11> Not used  
<12> Child object properties LOWERed three times. Stored as row {am} column {vm} ordinal {svm}
<13> Row composite LOWERed twice. Stored as row {vm} row {vm}

 

syssessions

The syssessions file contains various records storing information for user sessions.

File layout

syssessions

Field Description Information
<0> session no  
<1.1 - 1.n> CGI variable names  
<2.1 - 2.n> CGI variable values  
<3> Connection script name  
<4.1 - 4.n> Child sessions  
<5> Parent session number  
<6> Session start date:start time  
<7> Last interaction date:time  
<8> IP address of client  
<9> Root session id  
 
<0> sessionno : sequenceno  
<1> DATE() : TIME()  
<2> Page name from syspage
<3> Parent sequence number from sysbackseq
<4 - 10> Not used  
<11 - ...> sysvar LOWERed twice
 
<0> sessionno : global  
<1 - 50> sysglobal LOWERed twice

 

sysusers

The sysusers file contains the user definitions.

File layout

sysusers

Field Description Information
<0> User name  
<1> User name  
<2> Password Encrypted through syspwdenc
<3.1 - 3.n> User groups  
<4.1 - 4.n> Menu names  
<5.1 - 5.n> Menu descriptions  
<6> Location  
<7> Telephone number  
<8> Fax number  
<9> Mobile telephone  
<10> Reserved History stack
<11> Email address  
<12> Occupation  
<13> Post logon page  
<14> Default printer  
<15> Password expiry In days. 0 means it doesn't expire
<16> Last password change Set to -1 to force a password change
<17> Last password change time  
<18> Last logged on date  
<19> Last logged on time  
<20.1 - 20.n> Preview users List of users that this user can preview pages as
<21> Session timeout in minutes, blank indicates no timeout
<22> Timeout action 0 - default logon page, 1 - Error page (pagename)
<23> Language ID numeric position or language
<24.1> Editor font name  
<24.2> Editor font size  
<30 - 35> Usable for applications  

 

 

sysversions

The sysversions file contains the version copies of the objects listed in the version exports. This file can grow reasonably large, but clearing it will result in the loss of all version information.

File layout

sysversions

Field Description Information
<0> Export version name  
(:) 1 Program / object  
(:) 2 Object class Program filename / Object class
(:) 3 Object name  
<1 - ...> Object specific  

 

syswork

The syswork file stores the information required by the development environments undo and redo commands. This file keeps a copy of each object/program file before it is updated.

This file can grow very large when developing an account. A function has been created called syspurgewk that can be used to clear out records from this file. This file can be cleared in the run-time environment.

File layout

syswork Field Description Information <0> Program File/Object ID <1-> Object Copy

syswork

Field Description Information
<0> Program file / Object ID  
<1 - ...> Object copy