.ENV GET ENCODINGS This subroutine populates the ENCODINGS memory file with a list of all known encodings. Added in 6.0. Usage: GOSUB .ENV GET ENCOD...
.ENV GET ENV (ALL) This subroutine returns the value of all environment variables. Available in Release 5.4.7 higher (except for 6.0.0) Usage: GOSUB ...
.RBS HIERARCHY MTCE This subroutine invokes the 'Security Hierarchy Maintenance' program, bypassing the System Administrator requirement (System Administration ...
.RBS PROCESS SECURITY Allows the designer to invoke 'Access Control List Processes' for a particular parent / child pair (System Administration Role Based Se...
.UTIL CHECK RBS This subroutine is called to check the security access for the specified user when Role Based Security is used. Added in 5.2.0 Usage: PASS ...
.UTIL EMAIL This subroutine is called to send an email. Multiple addresses are allowed, as are attachments. This relies on the public domain program 'mutt' to del...
.UTIL MAKE DYNAMIC KEY This subroutine is not implemented. Usage: Description: Not implemented, just returns. Comments: Read what other users have said abou...
.UTIL PROCESS QRY REC This subroutine adds the current PCF record to the query pointer file. Usage: GOSUB .UTIL PROCESS QRY REC Description: This subro...
.UTIL SECR REST This subroutine will restore the Security codes for the selected application(s) from the archive. Release 5.5 and higher only Usage: PASS ...
Add Mode No Longer Clears Screen When adding records to a scrolling display, the image is no longer cleared. Overview: When adding records to a scrolling display...
Better Warning and Error Control The method of displaying multiple Error, Warning and Message commands has been improved. Overview: The Message Status area on th...
Bonus Features A collection of miscelleanous features that were added in 5.2.x. New Values for OPTION The predefined field OPTION now allows the following va...
Client Window Sizing New client property to give you more control over window sizing. Overview: There are two client settings which provide the user with control...
SQL Server Interface Performance Performance enhancements have been made to the SQL server interface. Overview: Significant improvements that impact SQL Server d...
Design Transfer Children This Release introduces the ability to Design Transfer Automatic Children from frame to frame, or Optional Children from Image to Image. ...
Drag Drop Support You can now define a Widget as the target of a drag drop operation. Overview: You can now define certain Widget types (Buttons, Labels, etc.)...
Friendly C Assert Screen The old C Assert error screen has been replaced with a hookable input process. Overview: The old C Assert error screen has been replaced...
Generate Subroutines via ILF New utilities have been added for the ability to create a subroutine process via ILF code. Overview: Four new utilities (API's) have...
New GUI Events This Release introduces some additional GUI events. Overview: You can now be notified when a user tabs into, out of, or changes the value in a fie...
New Table Widget This Release introduces a new type of Widget Table Widget. Overview: The Table Widget allows the designer to present information to the user i...
New Widget Types For TEXT Fields Several new Widget types are included in this Release. Overview: Five new Widget types are included in this Release for TEXT fie...
Role Based Security (RBS) This release of Appx includes a new method of managing security, known as 'Role Based Security'. Overview: The new Role Based Security ...
Select Access Path Uses Buttons The Select Access Path dialog box now uses buttons Overview: The Select Access Path dialog box will now display the various keypa...
Verify SET with Group Fields A new utility has been created to check group field size mismatches used in SET statements. Overview: A new Utility has been added ...
New Import/Export Format In order to support Unicode data, the Import and Export Utilities for Data and Design Files now support UTF 8 encoding in csv format. Ov...
Client Window Sizing The way the client handles different Window sizes has been improved. Overview: The way the client handles different Window sizes has been im...
New Connection Manager A new connection manager allows a user to reconnect to dropped sessions. Overview: A new connection manager allows a user to reconnect to ...
Data Exchange Application A new application (0DX) is included with 5.3. This application facilitates the exchange of data between Appx and external systems.This d...
Define File/Field Map This page describes how to map incoming data to Appx files/Fields. Overview: This option allows you to maintain existing File/Field maps. Y...
Define File/Field map from Source File This page describes how to map incoming data to Appx files/Fields using an existing XML file as a guide. __ Overview: In o...
Importing Data This page describes how to import data using 0DX. Overview: Now that we have defined a mapping for our PROSPECT.XML file, we can run the actual im...
Mapping Files Fields This page describes how to map incoming data to Appx files/Fields. Overview: In order to map the incoming data to Appx files and fields, y...
Processing This page describes the various processing and updating options. __ Overview: The 'Processing' options give us various ways of processing and importin...
Transfer Maps This page describes how to transfer or copy mappings. __ Overview: This option allows you to copy a mapping from another database, or an existing m...
View Raw Data This page describes the options for viewing the processed data. __ Overview: These options provide various ways to examine the source data after it...
New Group Around Widget Color Fields There is a new group field around WIDGET color fields for the designer to use. Overview: There is a new group field around...
HTML Editor Improvements The HTML Editor has been changed to make it easier to use with small text fields. Overview: The HTML Editor has been changed to make it ...
Enhancements to Import/Export Import/Export now display record counts for total records processed, success count, and failure count. Overview: Import/Export now ...
New Maximum File Sizes Release 5.3 includes increased maximum file sizes. Overview: The internal pointers that Appx uses in the Appx I/O files are only 32 bits i...
More TEMP Fields Available There are additional TEMP fields available for the designer to use. Overview: There are additional TEMP fields available for the d...
Login Manager PAM Capable The Appx Login Manager can now use PAM to validate user ids/passwords. Overview: The Appx Login Manager can now use PAM (Pluggable Auth...
READPREV A new ILF command 'READPREV' has been added. Overview: A new ILF command 'READPREV' has been added. This command is similar to READNEXT, except it reads...
Select Access Path A 'Select Access Path' icon appears in the toolbar if there is more than 1 path to the current file in a scan screen.. Overview: A 'Select Acc...
Table Fill Attribute A 'Float' option has been added to the width specification on Table Sources. Overview: A 'Float' option has been added to the width specific...
Interrupt Running Processes The user can now interrupt running processes, and designers can break into Input processes. Overview: The user can now interrupt runn...
APPX Linux/Unix APPX 5 Upgrade Instructions This page provides the information needed to upgrade an existing APPX 4.2.a Linux/Unix installation to APPX 5. Over...
APPX Linux/Unix APPX 5 Upgrade Instructions Esta pagina tiene contenidos que usted necesita para hacer un upgrade de APPX 4.2.a para una instalacion de Linux/Un...
APPX 5.2 Bug Fixes Following is a list of bugs that were fixed in Appx release 5.2. Overview The list is sub divided into categories. The bug title, bug number (...
APPX 5.2.0 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.2.0. Follow the links below to learn more. ...
APPX 5.3.0 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.3.0. Follow the links below to learn more. Add...
APPX 5.3 Installation Instructions This page provides instructions for installing APPX 5.3. Notes * IMPORTANT: APPX Desktop Client version should at least mat...
APPX 5.3.1 Patch Bug Fixes Following is a list of bugs that were fixed in Appx patch release 5.3.1. The bug number, from APPX Bug Tracker (SIRID) is in parenthesi...
APPX 5.4.0 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4.0. Follow the links below to learn more. Ov...
APPX 5.4.0/5.4.1 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4.0/5.4.1. Follow the links below to lea...
APPX 5.4.0/5.4.1/5.4.2 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4.0/5.4.1/5.4.2. Follow the links ...
APPX 5.4.0/5.4.1/5.4.2/5.4.3/5.4.4 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4.0/5.4.1/5.4.2/5.4.3/...
APPX 5.4.0/5.4.1/5.4.2/5.4.3/5.4.4c Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4.0/5.4.1/5.4.2/5.4.3...
APPX 5.4.0/5.4.1/5.4.2/5.4.3/5.4.4c/5.4.5 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4 and subsequen...
APPX 5.4.0/5.4.1/5.4.2/5.4.3/5.4.4c/5.4.5/5.4.6 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4 and sub...
APPX 5.4.0/5.4.1/5.4.2/5.4.3/5.4.4c/5.4.5/5.4.6/5.4.7 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.4 a...
APPX Desktop Client Installation Linux Requirements The Appx Desktop Client should run on most varieties of Linux, however due to the sheer number of distribut...
APPX Desktop Client Installation Linux Requirements El Appx Desktop Client debe rodar en los varios Linux, pero porque hay muchas tipos de distribucion, ni tod...
APPX Desktop Client Installation Mac OS/X Requirements IMPORTANT: The APPX Desktop Client only runs on Intel based Macs with OS/X 10.5 Update 1, or higher. Old...
APPX Desktop Client Installation Mac OS/X Requirements IMPORTANT: El APPX Desktop Client solamente roda en Intel Macs con OS/X 10.5 Update 1, o mas alto. Intel...
APPX Desktop Client Installation Windows Requirements The Appx Desktop Client runs on all versions of desktop Windows, including Windows XP, Vista, Windows 7. ...
APPX Desktop Client Installation Windows Requirements El Appx Desktop Client roda en todas las versiones de desktop Windows, incluyendo Windows XP, Vista, Wind...
APPX Audit Log Feature Esta pagina muestra el APPX Audit Log y prove informacion para seleccionar el APPX Audit Log feature. Overview APPX Audit Log caracterist...
APPX Runtime Subroutine API Overview Over 100 new subroutines are available for designers to use. Overview: Release 5.1 contains over 100 subroutines for designe...
APPX Runtime Subroutine API Overview Descripcion general de API Mas de 100 nuevas subrutinas estan disponibles para los disenadores a utilizar. Informacion gene...
Alignment Specification This chart explains the positioning when using the various 'align' routines in the Chart Director API. Constant Description Botto...
APPX 5.4.x Installation Instructions This page provides instructions for installing APPX 5.4.x. Notes * IMPORTANT: APPX Desktop Client version should at least...
APPX 5.4.3 Installation Instructions This page provides instructions for installing APPX 5.4.3. Notes * IMPORTANT: APPX Desktop Client version should at least...
APPX 5.4.4 Installation Instructions This page provides instructions for installing APPX 5.4.4. Notes * IMPORTANT: This version includes new SSL certificates...
APPX 5.4.5 Installation Instructions This page provides instructions for installing APPX 5.4.5. Notes * IMPORTANT: This version includes new SSL certificates...
APPX 5.4.6 Installation Instructions This page provides instructions for installing APPX 5.4.6. Notes * IMPORTANT: This version includes new SSL certificates...
APPX 5.4.7 Installation Instructions This page provides instructions for installing APPX 5.4.7. Notes * IMPORTANT: This version includes new SSL certificates....
APPX 5.5.0/5.5.1/5.5.2/5.5.3/5.5.4 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.5 and subsequent patch...
APPX 6.0.0 Features This page provides an overview of the new features in APPX 6.0. Overview The most significant change in this is release is support for a Unic...
APPX 6.0.0 Installation Instructions This page provides instructions for installing APPX 6.0.0 Notes * IMPORTANT: This version includes new SSL certificates....
APPX HTML Client This page gives installation instructions and an overview of the Appx HTML client. Overview The Appx HTML client is designed to allow you to con...
APPX HTML Client 5.4.2 This page gives installation instructions and an overview of the Appx HTML client. Overview The Appx HTML client is designed to allow you ...
APPX HTML Client 5.4.3/5.4.4 This page gives installation instructions and an overview of the Appx HTML client. Overview The Appx HTML client is designed to allo...
APPX HTML Client 5.4.5 This page gives installation instructions and an overview of the Appx HTML client. Overview The Appx HTML client is designed to allow you ...
APPX HTML Client 5.4.6/5.4.7 This page gives installation instructions and an overview of the Appx HTML client. Overview The Appx HTML client is designed to allo...
APPX HTML Client This page gives installation instructions and an overview of the Appx HTML client. Overview The Appx HTML client is designed to allow you to con...
.AXIS SET AXIS SCALE This subroutine sets the top extension, bottom extension, and zero affinity values that are to be used when auto scaling the "current" axis. ...
.AXIS SET AXIS RND MAX This subroutine controls whether or not the maximum value of the "current" axis should be rounded to correspond with a tick value. Usage: ...
.AXIS SET AXIS RND MIN This subroutine controls whether or not the minimum value of the "current" axis should be rounded to correspond with a tick value. Usage: ...
.AXIS Y ON RIGHT This subroutine is called to interchange the position of the primary y axis and the secondary y axis. Usage: GOSUB 0CD .AXIS Y ON RIGHT...
Base Chart Routines These subroutines allow you to set various attributes of your chart, regardless of the type of chart you are creating. Base Chart Routines ...
Color Routines These subroutines allow you to set or change the color of the "current object". In most cases, you have to have assigned a color to an object via s...
Data Routines These subroutines allow you supply the data you want on your chart. See Datasets Overview for an overview on using these subroutines. Dataset Routi...
Installation Tips This page describes some installation tips. Description: * If your server does not already have PHP installed, download and install PHP from...
Instalacion Esta pagina describe algunos consejos de instalacion. Descripcion: * Si su servidor no tiene ya instalado PHP, hay que bajar y instalar PHP de h...
Known Issues * The Linear Meter chart type has a few problems: * The pointer files (PTR1/2) are not initialized when .CHART INITIALIZE is called, so eac...
Overview Release 5.1.0 of the APPX Utility includes a new designer API which can be used to create charts within an APPX application. This API provides APPX Desig...
Pie Chart Routines These subroutines are used to create a Pie chart. Pie Chart Routines General .PIE SET DATASET Associate a dataset with the pie chart. .PIE...
Text Object Routines All the text that you place on the chart is considered a 'text object', such as axis labels, chart titles, legends, etc. These subroutines al...
XY Chart Routines These subroutines are used to create an XY chart. General .XY SET PLOT AREA Set the position and size of the plot area. .XY SET PLOT AREA:X S...
.CHART SET BG IMAGE This subroutine sets the background image of the "current" chart spec. If you want the image to be tiled across the background, use .CHART SET...
.CHART SET BG WALLPAPR This subroutine sets the background image of the "current" chart spec. The image will be tiled across the background of the chart, if you w...
.COLOR SET GLASS Assigns a special shading effect that emulates tinted glass or semi transparent plastic material to the "current" color object. Usage: PAS...
.COLOR SET GOLD Sets the color of the "current" Color Object to be Yellow (FFEE44) and sets the direction for brightness modulation to create a Gold Metal color e...
.COLOR SET SILVER Sets the color of the "current" Color Object to be Gray (DDDDDD) and sets the direction for brightness modulation to create a Silver Metal color...
.LEGEND SET KEY COLS This subroutine sets the number of columns to be used with the "autogrid" Key Layout method for the "current" Legend Box. Usage: PASS ...
.LEGEND SET KEY GAP This subroutine sets the horizontal gap between two legend entries for horizontal legend layout and the vertical gap (line spacing) between th...
.LEGEND SET KEY GAP:H This subroutine sets the horizontal gap between two legend entries for horizontal legend layout for the "current" Legend Box. Usage: ...
Chart Rendering Overview This page describes the process for rendering a chart and using it in your Appx program. Description: After you have initialized your ch...
Chart Rendering Overview Resumen Representacion de Tablas Esta pagina describe el proceso de presentacion de una chart y utilizarla en su programa APPX Descripc...
Datasets Overview This page describes the basic steps and related subroutine calls for supplying data to the charting routines. Description: Data and the present...
Datasets Overview Informacion general de conjunto de datos Esta pagina describe los pasos basicos y las llamadas relacionadas con el subprograma para el suminis...
Key Concepts This page describes de key concepts you should know before using the API's. Description: The API's have been designed so that you have a minimum num...
Conceptos Clave Esta pagina describe los conceptos clave que usted debe saber antes de usar el API's. Descripcion: Las APIs se han sido disenado para que tenga ...
Troubleshooting Tips This page describes some troubleshooting tips. Description: * When creating a new chart, find an example chart that is close to the layou...
Consejos para solucionar problemas Esta pagina describe algunas sugerencias para solucionar problemas. Descripcion: Al crear un nuevo grafico, encuentra un gr...
.PIE SET SECT 3D DEPTH This subroutine sets the sector 3D Depth for all pie sectors, a range of pie sectors, an individual pie sector, or the current pie sector. ...
.PIE SET LBL DISTANCE This subroutine sets the label layout for all pie sectors, a range of pie sectors, an individual pie sector, or the "current" pie sector. U...
.PIE SET LBL FORMAT This subroutine sets format for pie sector labels for all pie sectors, a range of pie sectors, an individual pie sector, or the "current" pie ...
.PIE SET LBL JN LN CLR This subroutine sets the color of the lines that join the pie sector perimeter with the pie sector labels for all pie sectors, a range of p...
.PIE SET LBL JN LN W This subroutine sets the width of the lines that join the pie sector perimeter with the pie sector labels for all pie sectors, a range of pie...
.PIE SET LBL LAYOUT This subroutine sets the label layout for all pie sectors, a range of pie sectors, an individual pie sector, or the "current" pie sector. Usa...
.PIE SET LAYOUT This subroutine sets the starting angle of the first sector and the direction for subsequent sectors for the "current" chart. Usage: PASS ...
.TEXT SET TXT MAX SZ This subroutine sets the maximum size (width and height) of the text that can be displayed in the "current" Text Object. Usage: PASS ...
.XY SET BAR LBL MIN SZ This subroutine sets the minimum height (or width for horizontal bars) of the bar segments below which data labels will be hidden. Usage: ...
.XY SET BAR SHAPE This subroutine sets the shape of the bars in the current Data Point, Data Set Template, Data Group, or XY Bar Layer. Usage: PASS ...
Calling O/S API Functions By using the PASS and CALL statements in APPX, O/S libraries and functions can easily be accessed from APPX subroutines. This paper disc...
Process ID is part of Client Title The Process ID is now part of the default Client Title. Overview By default, the title for the client window now includes the ...
Client Startup Preferences File You can now specify a preferences file for the client on the command line. Overview This setting allows you to set any client pre...
Working with Color Specifications Various API's allow you to pass a 'color_spec_name' or 'color_value' to set a color. A 'color_spec_name' refers to a previously ...
End User Selection can now be Required You can now designate certain End User Selections as 'Required' on a Query. Overview To help prevent users from accidental...
Font Specifications Font Location In Chart Director, the font name is simply the file name that contains the font. For example, under the Windows platform, the "...
APPX Runtime Subroutine API This page lists all the available API's in the current version of Appx. Various API's have been released at different times and are do...
HTML Client Remote Troubleshooting If you're having trouble with remote HTML Client connections, here are some things you can try. Client doesn't load or run cor...
ILF Debugger allows Scanning of Field Names You can now scan for field names in the debugger. Overview You can now scan for field names in the debugger. Usage: ...
A LogMonitor is a special background process that records changes in data files. It is controlled using the same mechanisms as appxLoginMgr. Using FMS groups, you...
Option Numbers Visible in Image Editor Option Numbers for auto GUI buttons are visible in the Image Editor Overview Option Numbers for auto GUI buttons are visib...
Copy Security This utility allows you to copy the Security Hierarchy and Access Control Lists from one entity to another. Overview: This utility allows you to co...
Create Access Control List This utility will create the initial Access Control List for the selected application(s) and database(s). Overview: The Create Access ...
Security Export Exports the Security Hierarchy and Access Control Lists for transfer to another system. Overview: This utility will transfer the complete Securit...
Security Import Imports a previously exported Security Hierarchy and Access Control Lists. Overview: This utility will import the previously exported Security Hi...
Inactivity Report Prints a list of users sorted by the number of days since last login. Overview: Prints a list of users sorted by the number of days since last ...
Locked Users Prints a list of users who are locked out due to inactivity. Overview: This report will prints a list of users who are locked out due to inactivity....
Security Hierarchy Maintenance This process allows you to maintain the Security Hierarchy. Overview: This process allows you to maintain the Security Hierarchy. ...
New/Changed Objects Prints a detailed list of any changes or additions to the selected Applications. Overview: This report will print a detailed list of any chan...
Security Hierarchy List/Export Prints and exports the Security Hierarchy. Overview: This report will list the currently defined Databases, Departments, Workgroup...
Setting RBS Configuration This process allows you to activate/disable RBS, and set defaults. Overview: The Parameter file for RBS controls various aspects of how...
Access Control List Files/Fields This process allows you to assign security to the files and fields in your applications. Overview: This process allows you to ...
Access Control List Processes This process allows you to assign security to the processes in your applications. Overview: This process allows you to assign sec...
Create Access Control List The next step in setting up RBS is to create the initial Access Control List. Overview: The Create Access Control List utility will po...
Defining Your Databases, Departments, Workgroups, Roles Users The first step in setting up RBS is to define your company's structure. Overview: The first step ...
Setting RBS Configuration The final step in setting up RBS is to set the configuration parameters. Overview: The Parameter file for RBS controls various aspects ...
User Security Overrides Prints any user level security overrides. Overview: This report will print any user level security overrides you have defined. You will b...
User Rights Prints a detailed list of the access rights for Processes, Files and Fields, by user. Overview: This report will print a detailed list of the access ...
Users Lists the users and their membership in the Hierarchy. Overview: This report will list the users and show their membership in the hierarchy, ie, what Datab...
Administrators no longer Designers Automatically Appx System Administrators are no longer automatically granted design rights. Overview As part of an ongoing pro...
CALL Statement Overview * The initial implementation of Unicode will not allow passed arguments to be UNICODE Alpha fields or NATIONAL Alpha fields. A runtime...
CNV BIN Statement Overview o UNICODE Alpha Field from Numeric field or NATIONAL Alpha Field from Numeric Field * Converts the value of the specified Numeric F...
DEFINE/UNDEFINE Statement Overview DEFINE and UNDEFINE should allow National and Unicode fields to be defined and undefined. Test Plan 1 DEFINE/UNDEFINE a Na...
ERROR / WARNING / MESSAGE / CANCEL / REFRESH Statements Overview 1 The internal storage type of all messages created by these statements must be UTF 32. 1 ...
PDF Printing Overview Test Plan: Bugs: 1 Appx crashes with C Assert " 1504 PDF Show Invalid UTF 8 String" if 'Print Grid' is checked in the form definiti...
SET DAY / SET MNTH Statements Overview * These statements have been revised to support all three encoding types for the destination alpha field * The text ...
Only Show License Warning to Administrators You can now control who sees license expiry warnings. Overview You can now set whether or not regular users will ever...
Cross Reference for Literal Values A new Cross Reference for Literals option has been added. Overview You can now run a cross reference for literals. Usage: On ...
Cross Reference Specific Occurrences of a Field You can now optionally get a field cross reference by occurrence number. Overview When running a field cross refe...