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