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 reference...
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...
Windows HASP Installation This document is of interest to customers installing APPX on a Windows PC or in a Windows PC network environment, who wish to register their...
Windows Client/Disk Server Configurations Note: The information in this document is generally obsolete and is only presented here for archive purposes. This document...
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...
Tech Tip by Gary Rogers, Director of Training, APPX Software, Inc. As you migrate your users to the Appx Desktop Client you will find that one advantage you gain is...
Defining Custom Fonts How to use custom fonts in PDF outputs Disclaimer: While these steps work in most cases this implementation of custom fonts is not supported...
Using CGI to Interface with the Web APPX understands how to parse CGI data into APPX variables. It picks apart the CGI data string and looks for variable NAMEs that...
Using the APPX/Sybase Connection Introduction: NOTE: The Sybase interface is no longer actively supported. This information is provided for historical purposes...
Using the APPX/Oracle Connection Introduction: This page is for APPX version 4.x earlier. For 5.x and higher, go to this page APPX allows data storage in numerous...
Using the APPX/ODBC Connection Introduction: These instructions are for APPX version 4.0.x and earlier. For APPX version 4.1.x higher, see this page. The APPX/ODBC...
Using the APPX/ODBC Connection Introduction: This page is applicable to APPX version 4.1 and higher. For older versions, refer to this page The APPX/ODBC Connection...
User Support Questions WinAppxD was replaced by the APPX Login Manager in Release 5.0.0. See this page for installing configuring the Login Manager. 4.1) How...
Uploading Spreadsheet Data to APPX You have data in a spreadsheet that you want to transfer into APPX data files. There are certainly several ways to go about doing...
Unix HASP Installation This document is of interest to customers installing APPX on an Intel/Unix platform, such as Linux, SCO, and NCR Unix. Because Intel/Unix systems...
VERIFY Statement Overview The Verify statement has been enhanced to verify characters within an alpha field based on the encoding type. RAW All 256 characters...
ILF Callable Unicode Engine Functions Overview UC STRCASECMP Performs a case insensitive comparison of two UTF 32 values, returning 0 if the strings should be considered...
Unicode Test Plan This document outlines a plan for testing the Unicode enhancements in APPX 6.0. Overview Release 6.0.0 of the APPX Utility includes support for...
STORE / RESTORE Statements Overview The STORE and RESTORE statements will work on all encoding types without any transcoding. Test Plan 1 Test STORE/RESTORE of...
Unicode STD File The STD file has been changed to include unicode values Overview The following fields in the STD record are now defined as Unicode fields:...
SET TEMP Statement Overview All TEMP fields in have been changed to have an encoding type of UNICODE. Since all TEMP fields are now UNICODE fields, SET TEMP will...
SET DAY / SET MNTH Statements Overview These statements have been revised to support all three encoding types for the destination alpha field The text for...
SET Statement Overview The SET statement has been extended to take the Encoding Type attribute of an alpha field into consideration. All Alpha fields in existing...
SCAN Statement Overview The SCAN statement should allow Unicode and National field types to be used as both a source and a destination. Test Plan 1 SCAN a National...
RUN Statement Overview The alpha operand of the RUN statement will be transcoded to the encoding of the OS shell environment before being executed . The RUN statement...
RECEIVE / LOCAL Statements Overview RECEIVE statements should follow the same rules as defined for a SET statement. LOCAL statements should follow the same rules...
Unicode Text Printing Text printing now generates UTF 8 report files. Overview Text output files are now encoded using UTF 8. Test Plan: Bugs: 1 Reports do...
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 definition...
PUSH / POP Statements Overview The PUSH and POP statements will work on all encoding types without any transcoding. Test Plan 1 Test PUSH/POP of fields with raw...
PRINT Statement Overview The PRINT statement should handle all three types of alpha fields, Raw, National and Unicode. Test Plan 1 Test PRINT with a Raw, National...
PASS Statement Overview When used with RECEIVE statement UNICODE and NATIONAL fields are supported. When used with a RUN statement UNICODE and NATIONAL fields are...
PACK / UNPACK Statements Overview Not defined in spec document. Test Plan These statements were never fully implemented, so nothing needs to be done re: Unicode...
Unicode ILF Literals The ILF editor and compiler have been reworked to support the following Unicode literals. Overview ILF Literal values are stored in the STMT...
IF DIFF Statement Overview The IF DIFF statement has been revised to compare Unicode and National alpha fields as well as compare records that contain Unicode and...
IF / AND / OR Statements Overview The GE/GT/LE/LT operators should use the Unicode collation API when UTF 32 operands are involved. This is because the 32 bit values...
ERROR / WARNING / MESSAGE / CANCEL / REFRESH Statements Overview 1 The internal storage type of all messages created by these statements must be UTF 32. 1 These...
Unicode Client Validations The client will not perform data entry validations to make sure data values entered are consistent with the field encoding types. This...
DEFINE/UNDEFINE Statement Overview DEFINE and UNDEFINE should allow National and Unicode fields to be defined and undefined. Test Plan 1 DEFINE/UNDEFINE a National...
Unicode Client Communications Client/server data flow has be reworked to support unicode data. Overview Initially, Only the Java Client will communicate using unicode...
COMPUTE / TOTAL Statements Overview The COMPUTE statement can work with Alpha fields when used with the P and M operators. It should continue to replace the non numeric...
Unicode COMPARE File Certain fields in the COMPARE file are now Unicode Overview The following field in the COMPARE file are now Unicode fields: COMPARE...
CNV PORT Statement Overview CNV PORT uses the same rules and CNV TEXT except that Date fields are not formatted using the Date Mask. Test Plan Follow the same testing...
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 Field...
CALL Statement Overview The initial implementation of Unicode will not allow passed arguments to be UNICODE Alpha fields or NATIONAL Alpha fields. A runtime...
BROWSE Statement Overview BROWSE is only applicable in character mode when viewing a report on the screen, therefore no Unicode support required. Test Plan Bugs...
BEG AT / END AT Statements Overview These statements presume that the designer has specified a field of the appropriate type or an appropriate Literal value for the...
APPEND Statement Overview Append RAW Alpha or Group or Literal to RAW Alpha or Group This is the current implementation no changes needed here. Append UNICODE...
Troubleshooting WinAppxD was replaced by the APPX Login Manager in Release 5.0.0. See this page for installing configuring the Login Manager. 6.1) WinAppxD service...
The Use of Cached Files APPX 4.1 introduces the ability to create and access a cached instance of a file in memory. The CREATE, OPEN, SCRATCH, and IF EXIST statements...
The APPX Client APPX/Linux Client Here`s how to set up an APPX/Linux Client (character based, and as opposed to a Windows or Java Client) to run against a Windows...
List of TWiki users Below is a list of users with accounts. If you want to edit topics or see protected areas of the site then you can get added to the list by...
System Administrator Questions WinAppxD was replaced by the APPX Login Manager in Release 5.0.0. See this page for installing configuring the Login Manager....
System Administration Environment / Widget File Wizards The environment variable wizard assists you in setting APPX environment variables. The Widget wizard explains...
Administrators no longer Designers Automatically Appx System Administrators are no longer automatically granted design rights. Overview As part of an ongoing process...
Speed II to APPX Conversion Instructions The following steps are necessary to migrate SPEED II applications into APPX: Please note that these instructions assume...
Special Topics Here you will find a wide range of support documents, frequently asked questions, `How To` guides, and general instructions concerning installation...
Setting Environment Variables APPX offers six levels at which environment variables may be set: General Environment Variable information can be found at APPX Environment...
APPX Printing This document will explain how to best perform APPX server side PDF printing on a Windows server. This applies to APPX 4.2.0 and above when APPX Server...
Tech Tip by Gary Rogers, Director of Training, APPX Software, Inc. In this article we will talk about how to take advantage of any extra room by designing scrolling...
Scripting Imports for Windows Prior to APPX 4.2.0 The following example batch file will import (appxutil i ) the design files for application TAP version 00 from...
Scoping Rules Subprocess/Related/Detached `Scoping` refers to what workfields and temporary files (both disk and memory) are available to a given process. There...
Runtime (,RT ) Calls WARNING: These are UNSUPPORTED features used to call operating system functions, and they may be changed or removed at any time. Although these...
Running Windows Functions from APPX Invoking Windows Shell Functions In order to invoke a Windows shell function (such as a batch file or executable) from APPX...
Removing Inactive Sessions `I connect to my customer over the Internet, running APPX on their Windows server. It works okay, but once in a while my APPX session just...
Reading SQL/Server Tables from APPX/Unix In order to access data stored under SQL Server under Windows while running APPX/Unix you have 2 choices, depending on which...
RUN in Series or Parallel When you RUN from APPX/Unix, APPX won`t resume running until the shell object called has completed. They execute in series. When you RUN...
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 Database...
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...
User Security Overrides Prints any user level security overrides. Overview: This report will print any user level security overrides you have defined. You will...
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...
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...
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 populate...
Access Control List Processes This process allows you to assign security to the processes in your applications. Overview: This process allows you to assign security...
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...
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...
Security Hierarchy List/Export Prints and exports the Security Hierarchy. Overview: This report will list the currently defined Databases, Departments, Workgroups...
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 changes...
Security Hierarchy Maintenance This process allows you to maintain the Security Hierarchy. Overview: This process allows you to maintain the Security Hierarchy...
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...
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...
Security Import Imports a previously exported Security Hierarchy and Access Control Lists. Overview: This utility will import the previously exported Security Hierarchy...
Security Export Exports the Security Hierarchy and Access Control Lists for transfer to another system. Overview: This utility will transfer the complete Security...
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...
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 copy...
Purging the USAGE File The USAGE files ($APPXPATH/0SA/USAGE. ) track numbers of endusers, designers, and users of locked applications currently logged into APPX. Prior...
The Pre Display/Verify Event Point `As far as I can see the reason that the pre display / verify event point exists is because the access/verify in Speed II was...
Passing Fields or File Names To pass FIELD(s): PASS fieldname1 FIELD PASS fieldname2 FIELD RUN ScriptName $ The `$ ` allows `ScriptName` to receive all the...
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 visible...
Optimizing Performance when using an RDBMS This page contains some tips to optmize performance when you store your data in an RDBMS. APPX performance with data stored...
What is the NT Equivalent of ... WinAppxD was replaced by the APPX Login Manager in Release 5.0.0. See this page for installing configuring the Login Manager....
Moving APPX Applications and Data Between Platforms The above title is not accurate, but it does represent a typical migration that these instructions are designed...
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...
Library Updates The APPX engine interfaces with a variety of third party libraries. Overview The APPX engine uses a variety of third party libraries to implement...
APPX Desktop Client Launched via Java Web Start This document will explain how to start the APPX Desktop Client via Java Web Start Technology. Overview When you publish...
APPX Keystroke Process Recording Playback The following information is only applicable when running APPX in character mode (ie, not using the APPX Desktop or...
Java Client Keymap We welcome any input on what our standard keymap should be. This one tries to be like a Windows keymap for other standard Windows Applications....
Invoking Windows Shell Functions In order to invoke a Windows shell function (such as a batch file or executable) from APPX for Windows, you can use a syntax similar...
Introduction to Web Server Before running out and trying to attach your APPX application to a Web Server, you need to understand the basic concepts used to get information...
Interactive Support Among the APPX Interactive Support offerings are a Message Board open to all members of the APPX community and e mail support addressing a variety...
Installation of WinAppxD WinAppxD was replaced by the APPX Login Manager in Release 5.0.0. See this page for installing configuring the Login Manager....
Importing Consecutive Files APPX Versions 5.1 higher In 5.1 a number of APIs were introduced that make the task of importing data easier. For example, if we have...
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...
Tech Tip How to create a PDF Form Overlay by Gary Rogers, APPX Director of Training and Consulting There have been a lot of inquiries on how to create a form overlay...
Displaying Google Maps in the HTML client Google does not allow any of their website to be loaded in an iframe in a web browser. It works in the java client because...
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 documented...
Foreign Language Translation Following are known issues with the Foreign Language Translation utility: 1) The mechanism that determines when an EM must be rebuilt...
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 `Arial...
Field Overrides If you do not want to use the APPX assigned data types you can override them using Field Overrides. For example, if you are mapping an APPX Data Dictionary...
External Commands from the Windows Client In Release 5.1 and higher you can use the APPX Desktop or HTML client and the .CLIENT LOAD URL API. In earlier versions,...
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 accidentally...
APPX E mail Support APPX Support List The APPX Support List is a membership mailing list, open only to supported customers with current maintenance agreements at...
Dynamic Linking and the CALL Statement Contents : Calling External Functions from APPX ILF Code It is possible for system integrators to develop and compile functions...
Displaying Date/Time Stamps `APPX has a convention of Option 98 for audit information. We would like to continue with that convention within our design. How do...
Diagnosing Strange and Generic Errors To diagnose strange or generic errors (such as bus errors, seg faults, attempting to free freed memory errors, or `an internal...
Developer Tips Displaying Google Maps in the HTML client If you want to display a Google map using the HTML client, follow this tip. Environment / Widget File Wizards...
Determining the Windows Serial Number When installed on a Windows server or stand alone PC, the APPX license is tied to the serial number of the C drive of the machine...
Designer Questions WinAppxD was replaced by the APPX Login Manager in Release 5.0.0. See this page for installing configuring the Login Manager. 3.1) How do I...
Customizing the Runtime Environment The APPX environment includes a number of standard processes. This page describes how you can customize them. Overview Your...
Converting Arrays to Scalar Data At present, only the `CNV TEXT` stmt addresses an Alpha array as if it were a single scalar variable. (Unfortunately, it also adjusts...
Configuring APPX for Windows APPX Presentation Server WinAppxD This document includes questions and hints about installing and running APPX/Server on Windows...
Configuring APPX for Unix Configuring the Login Manager This document explains how to configure the new login manager in APPX 5.0 higher Unix HASP Installation...
Combining CGI Script and APPX ILF Now that you are generating HTML from within APPX, wouldn`t it be nice to generate the new documents directly in response to web...
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 defined...
APPX Client Semi Transparent Mode This client setting controls the transparency of the entire client window as it appears on the desktop. Overview This client property...
Passing data to a Client Session This client setting allows you to pass custom data into a new Appx Client session. Overview This client property allows you to...
APPX Client Scroll Navigation Bar This client setting replace the scrollbar with a new navigation bar. Overview This client property replace the standard Scroll...
APPX Client Use Main Title Bar This client setting moves the processes title bar text to the Appx Client titlebar. Overview This client property takes the text...
APPX Client Swipe/Drag Scrolling This client setting causes mouse drag and touchscreen swipe actions to translate into Appx Panning and Scrolling options. Overview...
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 preference...
APPX Client Single Sign On (Windows Only) This allows the Appx Client to automatically use your Windows Active Directly desktop authenticated credentials to log into...
Tech Tip Client Side Printing by Gary Rogers, APPX Director of Training and Consulting With the advent of the APPX Desktop Client, a broad range of features were...
APPX Client Presentation Remote This client setting allows you to use certain keystrokes used by presentation remotes to trigger selected Appx options. Overview...
APPX Client Presentation Mode Footer Size This client setting controls the size of the footer in Presentation Mode. Overview This client property controls the size...
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...
APPX Client New Scan Button This client setting replace the scan button with a smaller scan button. Overview This client property replaces the standard Scan button...
APPX Client Map End, Tab, and Option keys This client setting allows you to map the End, Tab, and Option functions to different keyboard keys. Overview The property...
APPX Client Duplicate Session Hot Key This feature allows a user to easily start an additional APPX Client session. Overview The Duplicate Session Hot Key (Alt...
APPX Client Draw Border around Active Scrolling Region This client setting turns on or off the blue border we draw around the active scrolling record. Overview...
APPX Client Turn the Block Cursor On or Off This client setting lets you control the block cursor. Overview This client property allow you to control the block...
APPX Client Borderless Mode This client setting turns off the outermost client border. Overview This client property turns off the outermost client window border...
APPX Client Arrow Key in Scrolling Regions This client setting causes use of the arrow keys in a scrolling process to scroll records up or down the screen. Overview...
APPX Client Control Double Click Behavior This client setting allows you to control the behaviour of a double click. Overview This client property allows you to...
APPX Client Always On Top This client setting turn on the Always On Top setting in the Operating System for this window. Overview This client property will set...
Client Side Processes File Transfers This page is intended for APPX Release 5.0 and earlier. In Release 5.1 various API`s were introduced to perform these functions...
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 discusses...
.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...
.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...
.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...
.PIE SET ORIGIN This subroutine sets the x and y coordinates (horizontal and vertical) of the center of the pie for the `current` chart. Usage: PASS...
.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. Usage...
.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 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 pie...
.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 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....
.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....
Troubleshooting Tips This page describes some troubleshooting tips. Description: When creating a new chart, find an example chart that is close to the layout...
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 number...
Datasets Overview This page describes the basic steps and related subroutine calls for supplying data to the charting routines. Description: Data and the presentation...
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 chart...
Chart Design Overview This page describes the basic steps and related subroutine calls for creating a simple chart. Description: Designing a chart can be as simple...
.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:...
.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 the...
.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...
.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...
.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 effect...
.COLOR SET GLASS Assigns a special shading effect that emulates tinted glass or semi transparent plastic material to the `current` color object. Usage: PASS...
.COLOR SET BRUSH METAL Sets the strength of the texture to create a Brushed Metal Effect for the `current` Color Object. Usage: PASS texture strength...
.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 want...
.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...
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 Set...
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 allow...
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...
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 Designers...
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 each...
Installation Tips This page describes some installation tips. Description: If your server does not already have PHP installed, download and install PHP from...
Chart Director API for APPX These APIs can be used by an APPX designer to create business charts within an APPX application. Installation Tips Overview Data Routines...
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 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 some...
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 General...
.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...
.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 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 SCALE This subroutine sets the top extension, bottom extension, and zero affinity values that are to be used when auto scaling the `current` axis....
APPX Background Processing This document discusses APPX background processing. Overview Background processes refers to the ability of APPX to spawn another session...
Automating Export/Import with Unix Crontabs `Can I run an APPX process via a Unix command (one liner) to Export and Import? I would like to setup a crontab to handle...
Accessing APPX Data From VB Using AppxODBC The Appx ODBC client allows you to access APPXIO data from external applications such as Excel, Crystal Reports, and other...
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 connect...
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 allow...
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.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 allow...
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 This page gives installation instructions and an overview of the Appx HTML client. Overview The Appx HTML client is designed to allow you to connect...
APPX 6.2.0 Features This page provides an overview of the new features in APPX 6.2.x Overview This release is primarily focused on the repair of bugs, found in both...
APPX 6.1.0 Features This page provides an overview of the new features in APPX 6.1.x Overview The most significant change in this is release is support for a Unicode...
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 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 Unicode...
APPX 5.5.0 Features System Administration This page describes the new features in Application Design New Environment Variables Some new environment variables have...
APPX 5.5.0 Features SCCS This page describes the changes made to the Sourc Code Control System (SCCS) Changes Cosmetic changes: All scrolling screens now use...
APPX 5.5.0 Features Runtime This page describes the new features for the runtime environment in APPX 5.5.0. Overview The runtime environment received a facelift...
APPX 5.5.0/5.5.1 Features Application Design This page describes the new features in Application Design in Release 5.5.0 and subsequent patch releases. Note that...
APPX 5.5.0/5.5.1/5.5.2 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.5 and subsequent patch releases. Follow...
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.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.5 Installation Instructions This page provides instructions for installing APPX 5.4.5. Notes IMPORTANT: This version includes new SSL certificates...
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.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.1/5.4.2 Installation Instructions This page provides instructions for installing APPX 5.4.1. Notes IMPORTANT: APPX Desktop Client version should at...
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 4.2.9, PostgreSQL, and UnixODBC on RHEL 5/Scientific Linux 5/Oracle Linux 5/CentOS 5 Overview This document will demonstrate how to configure APPX 4.2.9 and...
APPX 4.2.9, MySQL, and UnixODBC on RHEL 5/Scientific Linux 5/Oracle Linux 5/CentOS 5 Overview This document will demonstrate how to configure APPX 4.2.9 and MySQL...
APPX 4.2.9, MySQL, and UnixODBC on RHEL 6/Scientific Linux 6/Oracle Linux 6/CentOS 6 Overview This document will demonstrate how to configure APPX 4.2.9 and MySQL...
APPX 4.2.9, MySQL, and UnixODBC on 64 bit Debian 5 APPX, MySQL, and UnixODBC will all work under 64 bit Debian, but because Debian is 64 bit and APPX is 32 bit, it...
Alignment Specification This chart explains the positioning when using the various `align` routines in the Chart Director API. Constant Description BottomLeft...
Advanced Topics Now that you understand the technique described above, there are some existing and soon to be released features to make the process a little easier...
Accessing Query Parameters Overview: The Query specifications used to produce a report are stored in three memory files, defined in the application. You can find...
Running APPX on Windows from a hand held device via a Linux Terminal Server This document will demonstrate how you can run APPX on Windows in character mode when...
APPX Usage Log The APPX Usage log gives you the ability to track session log on/off, process execution and more. Overview The APPX Usage log can be used to track...
APPXUTIL Overview This document is applicable to versions of APPX prior to 4.2.0. If you are using a later version refer to File Analysis Recovery. What is APPXUTIL...
Using the APPX/TMUNIX Scripting Feature The following information is only applicable when running APPX in character mode (ie, not using the APPX Desktop or HTML clients...
APPX Runtime Subroutine API Overview Over 100 new subroutines are available for designers to use. Overview: Release 5.1 contains over 100 subroutines for designers...
APPX QUERY Report Writer Introduction: APPX Query (formerly known as APPX SQL) is an enduser oriented Report Generator. It allows endusers trained in its use to define...
APPX Process Stack Running an APPX application consists of a series of processes calling each other. For example, the Main Menu might call a submenu, which might call...
APPX Presentation Server WinAppxD APPX Release 4.2.a and earlier This document includes questions and hints about installing and running APPX/Server on Windows...
APPX ODBC Installations Instructions This page provides instructions for installing APPX ODBC 5. Overview APPX ODBC is used by APPX customers to gain access to...
APPX/NT Operations and Administration Note: The information here is generally obsolete since WinAppxD has been replaced by the APPX Login Manager. Contents:...
APPX Login Manager For Windows This page describes how to install the APPX Login Manager command and how to use it to install, configure, and manage APPX Login Services...
APPX Login Manager For Unix/Linux This page describes how to install the APPX Login Manager command and how to use it to install, configure, and manage APPX Login...
APPX License Server NOTE Most of this information is redundant. In current versions, if a license server is not detected it will be started automatically by the...
APPX Keys AppxKEYS is a utility program embedded in APPX that allows a user to create an APPX keyboard layout for character mode connections. The keyboard layout for...
Output Process Design Raw Text Widget Effective with Release 5.0.0, Raw Text widgets on output images have a defined behavior. Overview Prior to Release 5.0....
APPX External Databases Using the APPX/ODBC Connection APPX 4.1 The APPX/ODBC Connection allows APPX Applications, through a Windows ODBC Server, to access and...
APPX Environment Variables Environment Variables are used to modify the behavior of APPX at runtime. They may be set in the Windows or Unix operating system before...
Data API The Data API provides a set of tools you can use to have your APPX applications respond to web based queries. Overview The Data API is a collection of tools...
APPX Client/Server Installation and Configuration Overview: This information only applies to very old versions of APPX (pre 4.2). Consult the installation instructions...
APPX Desktop Client Encryption Efectivamente con la liberacion de la version 5.0.0, el APPX Desktop Client incluye una opcion para permitir SSL encryption para sesiones...
APPX Desktop Client Encryption Effective with Release 5.0.0, the APPX Desktop Client includes an option to enable SSL encryption for `Remote` APPX Desktop Client...
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 caracteristicas...
APPX Audit Log Feature This page describes the APPX Audit Log feature and provides instructions for enabling the APPX Audit Log feature on either Linux or Windows...
APPX Desktop Client Installation Windows Requirements El Appx Desktop Client roda en todas las versiones de desktop Windows, incluyendo Windows XP, Vista, Windows...
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 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 Mac OS/X Requirements IMPORTANT: The APPX Desktop Client only runs on Intel based Macs with OS/X 10.5 Update 1, or higher. Older...
APPX Desktop Client Installation Linux Requirements El Appx Desktop Client debe rodar en los varios Linux, pero porque hay muchas tipos de distribucion, ni todas...
APPX Desktop Client Installation Linux Requirements The Appx Desktop Client should run on most varieties of Linux, however due to the sheer number of distributions...
APPX HTML Client Features This page provides an overview of the features in the latest HTML client The version number of the client can be determined by hovering...
APPX 6.1.0 (and greater) Windows New Installation Overview Two different methods are provided to install APPX on Windows. There is a GUI installer and a Console...
APPX 6.1 (and greater) Upgrade Instructions This page provides the information needed to upgrade an existing APPX 5.4.5 (or higher) installation to APPX 6.1 and...
APPX 6.1.0 New Installation Configure APPX Overview The first time that APPX is run after the installation wizard completes, you will need to complete the initial...
APPX 6.1.0 (and greater) Linux/Unix New Installation Overview Two different methods are provided to install APPX on Linux/Unix. There is a GUI installer and a...
APPX HTML Client Features This page provides an overview of the features in the latest HTML client The version number of the client can be determined by hovering...
APPX 6.0.0 Windows New Installation Overview Two different methods are provided to install APPX on Windows. There is a GUI installer and a Console Mode (character...
APPX 6.1 Upgrade Instructions This page provides the information needed to upgrade an existing APPX 5.4.5 (or higher) installation to APPX 6.1 Overview Release...
APPX 6 New Installation Configure APPX Overview The first time that APPX is run after the installation wizard completes, you will need to complete the initial...
APPX 6.0.0 Linux/Unix New Installation Overview Two different methods are provided to install APPX on Linux/Unix. There is a GUI installer and a Console Mode...
APPX HTML Client Features This page provides an overview of the features in the latest HTML client The version number of the client can be determined by hovering...
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 and...
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 subsequent...
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 subsequent...
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....
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....
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 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 learn...
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. Overview...
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 parenthesis...
APPX 5.3 Installation Instructions This page provides instructions for installing APPX 5.3. Notes IMPORTANT: APPX Desktop Client version should at least match...
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. Additional...
APPX 5.2 Installation Instructions This page provides instructions for installing APPX 5.2. Notes There is an issue present in the 5.2.2 release of APPX that...
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.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.1 Installation Instructions This page provides instructions for installing APPX 5.1. Notes IMPORTANT: The APPX Desktop Client for Macs only runs on...
APPX 5.1 Bug Fixes Following is a list of bugs that were fixed in Appx release 5.1. Overview The list is sub divided into categories. The bug title, bug number...
APPX 5 Special Installation Instructions for upgrading within the APPX 5.x series This page provides special instructions when upgrading an existing APPX 5.0 installation...
APPX 5.x Windows New Installation Overview Two different methods are provided to install APPX on Windows. There is a GUI installer and a Console Mode (character...
APPX 5 on Windows connectivity to Oracle How to configure APPX 5 on Windows to store data inside Oracle. Overview Release 5.0.0 or higher of the APPX Utility allows...
APPX 5 on Solaris SPARC connectivity to Oracle How to configure APPX 5 on Solaris SPARC to store data inside Oracle. Overview Release 5.0.0 or higher of the APPX...
APPX 5 on HP UX PA RISC connectivity to Oracle How to configure APPX 5 on HP UX PA RISC to store data inside Oracle. Overview Release 5.0.0 or higher of the APPX...
APPX 5 on HP UX Itanium connectivity to Oracle How to configure APPX 5 on HP UX Itanium to store data inside Oracle. Overview Release 5.0.0 or higher of the APPX...
APPX 5 on AIX connectivity to Oracle How to configure APPX 5 on AIX to store data inside Oracle. Overview Release 5.0.0 or higher of the APPX Utility allows APPX...
APPX 5 connectivity to Oracle How to configure APPX 5 to store data inside Oracle. Overview This page is for APPX version 5.x higher. For 4.x and lower, go to...
APPX 5.0.0 Open SSL This page describes how APPX uses Open SSL. Overview UPDATE : Most of this is obsolete, as the required SSL libraries are included with the...
APPX 5 New Installation Configure APPX Overview The first time that APPX is run after the installation wizard completes, you will need to complete the initial...
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/Unix...
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. Overview...
APPX 5 Installation Instructions This page provides instructions for installing APPX 5. Notes IMPORTANT: The APPX Desktop Client for Macs only runs on Intel...
Installation Instructions for APPX Server on Red Hat Linux Server This page provides instructions for installing APPX Server on a Red Hat Linux Server. APPX Server...
APPX 5.0.0 Feature Index This is the starting point to discover details of the new features found in APPX Release 5.0.0. Follow the links below to learn more....
APPX 5.0 Bug Fixes Following is a list of bugs that were fixed in Appx release 5.0. Overview The list is sub divided into categories. The bug title, bug number...
Interrupt Running Processes The user can now interrupt running processes, and designers can break into Input processes. Overview: The user can now interrupt running...
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 specification...
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 Access...
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...
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 Authentication...
More TEMP Fields Available There are additional TEMP fields available for the designer to use. Overview: There are additional TEMP fields available for the...
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...
Enhancements to Import/Export Import/Export now display record counts for total records processed, success count, and failure count. Overview: Import/Export now...
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...
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...
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...
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...
Processing This page describes the various processing and updating options. Overview: The `Processing` options give us various ways of processing and importing...
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,...
Importing Data This page describes how to import data using 0DX. Overview: Now that we have defined a mapping for our XML file, we can run the actual import step...
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...
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....
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 documentation...
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...
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 improved...
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. Overview...
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...
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 keypaths...
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...
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 fields...
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...
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 field...
HTML Editor Widget A HTML Editor Widget has been implemented in APPX 5.2.0. Overview: The HTML Editor Widget can be used to enter and edit HTML in an APPX text...
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...
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...
Flash Player Widget A Flash Player Widget has been implemented in APPX 5.2.0. Overview: The text field should contain the pathname to a flash file (swf). The flash...
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...
Design Transfer Children This Release introduces the ability to Design Transfer Automatic Children from frame to frame, or Optional Children from Image to Image....
SQL Server Interface Performance Performance enhancements have been made to the SQL server interface. Overview: Significant improvements that impact SQL Server...
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...
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 values...
Better Warning and Error Control The method of displaying multiple Error, Warning and Message commands has been improved. Overview: The Message Status area on the...
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...
.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...
.UTIL PROCESS QRY REC This subroutine adds the current PCF record to the query pointer file. Usage: GOSUB .UTIL PROCESS QRY REC Description: This subroutine...
.UTIL MOD SCROLL BEHAV This subroutine allows the user to select a record on a scrolling display by just clicking it. Usage: GOSUB .UTIL MOD SCROLL BEHAV...
.UTIL MAKE DYNAMIC KEY This subroutine is not implemented. Usage: Description: Not implemented, just returns. Comments: Read what other users have said about...
.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 deliver...
.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...
.RBS REGEN Rebuilds the internal RBS cross reference file for the selected apps. Added in 5.4.7 and 6.0.1. Not present in 6.0.0 Usage: PASS Application...
.RBS PROCESS SECURITY Allows the designer to invoke `Access Control List Processes` for a particular parent / child pair (System Administration Role Based Security...
.RBS HIERARCHY MTCE This subroutine invokes the `Security Hierarchy Maintenance` program, bypassing the System Administrator requirement (System Administration...
.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...
.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 ENCODINGS...
.DATA WRITE STREAM This subroutine allows you to return data to the caller. This is only useful when working with the Data API (Release 5.5.0 higher) Usage:...
.DATA GET PARAM VALUE This subroutine allows you to get the value of a field from the URL. This is only useful when working with the Data API (Release 5.5.0 higher...
.DATA DEBUG LOG This subroutine allows you to write a free format messages to the debug log. This is only useful when working with the Data API (Release 5.5.0 higher...
.DATA BAD REQUEST This subroutine allows you return an error message to the caller. This is only useful when working with the Data API (Release 5.5.0 higher)...