Visual LANSA Tips

Page 1 of 8

• Guide to configuring an Oracle database for a LANSA installation
  - Visual LANSA V11 SP5 or later
  A guide to the configuration of an Oracle database for use by a Visual LANSA installation (either development or production).
• Search/Highlight Audit Stamps in RDML source code
  - Visual LANSA V11 & V12
  How to search and highlight specific lines of code based on the Audit Stamp.
• Adding shortcuts to the desktop with a Deployment Tool Package
  - Visual LANSA Deployment Tool V12
  How to use After-Install Commands to add your own shortcuts to the Desktop.
• Technique to prevent long running process windows from being "ghosted"
  - Visual LANSA V11 & V12
  A technique to prevent long running forms/processes from being 'ghosted' by Windows and marked as not responding.
• Why are my repository objects greyed out?
  - Visual LANSA V12
  Status of Objects in the Repository can now be easily distinguished based on their colour/highlighting
• How to establish that you are using SSL in your V12 Client/Server connection
  - LANSA V12
  Test to determine that you are using SSL for your connections after enabling SSL for Client/Server connections.
• Trapping and handling Active-X Exceptions at runtime
  - Visual LANSA V12
  Active-X Exception Handling now traps failed HRESULT values in Visual LANSA at runtime so that they do not cause application failures.
• Customise the "Enter" Key in to not behave like a tab key by default
  - Visual LANSA V12
  How to change the default behavior of the numeric "Enter" key to behave either as a Tab or Enter key.
• Why are the generate XSL options greyed out?
  - Visual LANSA IDE All Versions
  Compiling WAMs using the right-click menu may cause the XSL generation options to be greyed out.

Page 2 of 8

• Steps to migrate your database from ASA to SQL Server 2008 Express
  - Visual LANSA V11 & V12
  Steps to migrate your development database from V11 and ASA to V12 and SQL Server 2008 Express.
• RAMP-TS host added as a Trusted Site when executing in End User mode
  - Visual LANSA Framework & RAMP TS
  If a RAMP-TS application can be executed in Designer mode but failed in an End User mode with errors, you need to add your host into trusted sites list to execute it.
• Enabling custom End User tracing in your application
  - Visual LANSA V11 SP5 (RDMLX)
  How make use of a Visual LANSA tracing feature in RDMLX applications.
• How to create a tree view with a different background color for each level
  - Visual LANSA V11 SP5 (RDMLX)
  Sample code to create a tree view with a different background colour for each level.
• Planned Support of Windows Server 2008 R2 by LANSA
  - All LANSA Products
  LANSA support for Windows Server 2008 R2
• Planned support of Windows 7 by LANSA
  - ALL LANSA Products
  LANSA support for Windows 7
• Using Command Handlers to do simple prompts
  - Visual LANSA Framework
  How to use Command Handlers as prompting assistants in the Visual LANSA Framework.
• Getting started with RAMP-TS in EPC839
  - Visual LANSA Framework & RAMP-TS
  To get started with RAMP-TS you need to start with a framework that has no RAMP-NL details associated with it.
• Backup your screens in RAMP-TS
  - Visual LANSA Framework EPC839
  While developing in RAMP-TS it is more manageable for each developer to configure to have their own folder which keeps their screens in isolation from other developers.
• How to control the sequence of commands displayed in an instance list right click popup menu
  - Visual LANSA Framework
  To control the sequence of commands displayed in an instance list, right click, popup menu use the sequence property located in Framework -> Commands.
• How do I remove from my VL repository task IDs that have already been FINished or deleted from LANSA for iSeries?
  - Visual LANSA
  How to remove tasks from a Visual LANSA slave system when the tasks are already set to FINished or have already been deleted on LANSA for iSeries.
• 'uQueryCanDeactivate' in EPC831 can be used to check unsaved changes when running VLF applications
  - Visual LANSA Framework
  Methods in command handlers to check unsaved changes when running Visual LANSA Framework applications.
• VLF.NET Application Level Tracing
  - Visual LANSA Framework EPC831
  VLF.NET is available in EPC831 and in the same way as for VLF/Web or VLF/WAM, you can switch on the VLF Trace window to troubleshoot VLF.NET applications.
• Enabling split-view source code in IDE
  - Visual LANSA V11
  There is an undocumented feature in the V11 IDE that allows you to view two or more sections of source code in one screen.
• Possible performance increase for Visual LANSA on Sybase databases
  - Visual LANSA All Versions
  Changing the default page size from 2048 to 4096 may increase performance in Visual LANSA IDE and runtime applications.

Page 3 of 8

• Using the TAG feature in comments in source code
  - Visual LANSA
  Adding a tag allows you to use keystrokes to jump to the next or previous tagged comment line.
• Avoiding connection errors to JIT server for remote clients
  - Visual LANSA
  If the connection to the JIT Server fails, an error message is shown; this tip includes one possible way to avoid this error message.
• Making use of the PrompterActivate event
  - Visual LANSA (RDMLX)
  The PrompterActivate event is intended to allow access to the prompter form before it displays so that initialization processing can be performed.
• VLF.NET with a System i Apache Web Server
  - Visaul LANSA Framework EPC831
  Apache settings required to run VLF.NET application.
• Firewall considerations for new debugging in EPC830 for SP5
  - Visual LANSA V11
  How to avoid Windows firewall blocking the new V11 SP5 debugging service.
• How to put an option in Framework application to allow endusers to reset screen layouts to 'as shipped' defaults
  - Visual LANSA Framework EPC826
  here might be times when you want to test your Framework application with VLF shipped default layouts (e.g. the main Framework window size, location of the command tab, layout).
• Simple Encrypting and Decrypting sample using the ENCRYPT and DECRYPT BIFs
  - Visual LANSA V11 SP4
  Sample code to take a string INPUT and Encrypts the input and generates a encrypted text and then proceeds to decode the encrypted text.
• Detailed explanation of Language CCSID Mappings
  - Visual LANSA V11 SP5
  Further explanation on the new SP5 feature Language CCSID Mappings
• Detailed explanation of Enable Short Char feature
  - LANSA Version 11 SP5
  Further explanation on the new SP5 partition level feature Enable Short Char.
• Making use of the new EditorChanged event in a Grid component
  - Visual LANSA V11.3
  The EditorChanged event of a grid uses Variants which has special considerations.
• Possible improvement in Listener performance when enabling TCP_NODELAY TCP/IP socket option
  - Visual LANSA
  Enable TCP_NODELAY TCP/IP option in Listener/Host Route can improve application performance in some network configurations.
• How to enable 'Application Level Tracing' in Windows RAMP applications at End User mode?
  - Visual LANSA Framework EPC826
  It is possible to programmatically trace a Windows RAMP application as an End User (e.g. when executing UF_EXEC) either during development or after deployment.
• Making JIT deployment packages smaller
  - Visual LANSA All Versions
  Options to make the JIT download package smaller.
• How to isolate your Visual LANSA Application from Microsoft Office version incompatibilities
  - Visual LANSA V11.3
  A practical solution to check for the availability of an ActiveX control before instantiating it.
• The deployed Web RAMP application shows an "UNKNOWN FORM" indication on the target PC
  - Visual LANSA Framework V11.3
  If you have developed a RAMP Web Application and wants to deploy it for testing it should not be deployed to the RAMP development PC.

Page 4 of 8

• Improved version of the VLF Demonstration Application for use in RDMLX partitions
  - Visual LANSA Framework V11.3 and above
  LANSA is shipping a new Visual LANSA Framework Demonstration Application by using vf_sy001_system_Lastshipped.xml
• The difference between ItemLostFocus, Column LostFocus and Grid LostFocus events
  - Visual LANSA All Versions
  An explanation for why the ItemLostFocus event is not always fired when expected.
• Correct usage of ComponentControls/ComponentMembers
  - Visual LANSA V10 and V11.3
  An explanation about the subtle differences between the two properties.
• FAQs regarding user profile and password management in VLF
  - Visual LANSA Framework V11.3
  Information regarding User Profile and Password Management in the Visual LANSA Framework.
• Cut, Copy and Paste with a mouse click - example for Visual LANSA
  - Visual LANSA
  Example code to allow 'Cut, Copy and Paste' with a mouse click in Visual LANSA.
• Why do I get an error on a 'Startup' macro when running my RAMP application?
  - Visual LANSA Framework and Newlook
  What is a 'Startup' macro and why do I get an error on this when running my RAMP application?
• How to hide the Autosignoff window when using Visual LANSA Framework on Web
  - Visual LANSA Framework
  An Internet Explorer option is available to hide the VLF AutoSignoff window on the browser.
• The list of saved Frameworks in the 'Select Framework File' window can be customized
  - Visual LANSA Framework
  Save different Frameworks using Designer mode.
• Using Visual LANSA Framework RAD-PAD on Windows Vista requires a Microsoft Active-X component DHTMLEdit
  - Visual LANSA Framework
  You may experience problems using RAD-PADs on Vista as it requires a Microsoft Active X control which can be added in manually.
• RAMP application works in designer mode but gets an error "NL runtime manager outer wrapper on vf_sy120.htm" in end user mode
  - Visual LANSA Framework & RAMP
  How to detect JavaScript errors in RAMP applications.
• RAMP application works in designer mode but gets an error "NL runtime manager outer wrapper on vf_sy120.htm" in end user mode
  - Visual LANSA Framework & RAMP
  How to detect JavaScript errors in RAMP applications.
• Which Newlook version should I be using with the Visual LANSA Framework and RAMP?
  - Visual LANSA Framework & RAMP
  Do I need to upgrade my version of Newlook after applying Visual LANSA Framework EPC804?
• Correct use of the PositionOf and PositionIn Intrinsic functions
  - Visual LANSA V11
  PositionOf/PositionIn are useful intrinsic functions, however care must be taken when used on RDML Alpha fields.
• 50-character filename restriction in the LANSA deployment tool
  - Visual LANSA V11.3
  When deploying applications you can run into problems because of a 50-character filename restriction in the LANSA deployment tool.
• How to allow for more than 20 concurrent connections to an Adaptive Sybase Anywhere (ASA) Database
  - Visual LANSA V11.3
  How to increase the number of ASA database connections.

Page 5 of 8

• How to use GZip in the Visual LANSA Framework
  - Visual LANSA Framework EPC793
  Using GZip can significantly reduce the size of the HTM and JS files that are created as part of VLF Web browser and RAMP applications.
• Support for SQL Server 2000 and SQL Server 2005 collections in V11.3 (CU3)
  - Visual LANSA V11.3
  LANSA now allows the creation of collections with new SQL Server databases.
• Hide a business object in the Navigation Pane in Visual LANSA Framework
  - Visual LANSA Framework EPC793
  How to hide business objects from the Navigation Pane in a Framework Application.
• How to disable F1 help in the Visual LANSA Framework
  - Visual LANSA and Visual LANSA Framework V11.3
  In V11 CU3 Visual LANSA (or VLF) applications there is a way to disable (or capture) F1.
• Layout changes by the FLA (The Form Layout Assistant) can be revert back to a previous version
  - Visual LANSA Framework
  How to remove or revert changed layouts made by the FLA.
• Various ways to start a deployed VLF Web Application with a long URL
  - Visual LANSA Framework
  Options to start a deployed VLF Web Application on the browser.
• What is VF_Sy001_System_LastShipped.XML?
  - Visual LANSA Framework
  Until LANSA CU3, VLF upgrades always renamed and then replaced the standard shipped demonstration system in XML file VF_SY001_System.XML with the very latest shipped demonstration version.
• Displaying an Excel Spreadsheet/Graph on your Visual LANSA Form
  - Visual LANSA V11
  Embedding a Microsoft Office Spreadsheet ActiveX to show Excel tables directly on your Form.
• Context sensitive features including HELP have vastly improved for V11.3
  - Visual LANSA V11.3
  The Visual LANSA Editor has now advanced context sensitive features.
• Using RDMLX Webevent functions as Visual LANSA Framework Filters or Command Handlers on iSeries Web Servers
  - Visual LANSA Framework EPC773 and above
  RDMLX Webevent functions can only be used as Visual LANSA Framework filters or command handlers on systems at CU3 level or later.
• Using the Enforce user access option in Visual LANSA
  - Visual LANSA V11
  How to implement and use the Enforce User Access option.
• Technique to convert a string to "words" (i.e. separates text based on a space)
  - Visual LANSA V11 (RDMLX)
  This tip shows how to separate text based on the spaces within the text. The technique displays some simple string handling techniques available in Visual LANSA V11.0.
• Using Visual LANSA runtime tracing (Updated for V11)
  - Visual LANSA
  How to enable tracing on a runtime application when requested by LANSA support.
• How to export selected columns of a list/grid to a file
  - Visual LANSA V11
  How to export specific columns from a list/grid (Version 11 only).
• How to upgrade a deployed application (including VLF) to a V11 runtime environment
  - Visual LANSA V11
  How to upgrade your existing (deployed) applications from V10 a V11 runtime environment including steps for upgrading VLF applications.

Page 6 of 8

• Processing Tree Items in the order that they are displayed
  - Visual LANSA V11
  SelectList processes tree items in the order that they were added, not the order in which they are displayed. Use this method to process items in the correct order (Version 11 only)
• Debugging tiered applications using an application level tracing strategy
  - Visual LANSA V11
  How to use application level tracing for a more rapid and effective way to locate a problem in RDMLX environments (especially useful in production environments).
• How to access ASA 9.0.2 documentation
  - Visual LANSA V11
  ASA 9.0.2 is shipped in V11 without documentation but can be downloaded.
• Convert a string to proper case
  - Visual LANSA
  Convert a string to first character upper case, all others lower case.
• How to create a Columnar tree view
  - Visual LANSA V11
  In Version 11 it is now possible to now create a Columnar tree, that is a tree with multiple columns above and beyond the main tree column.
• DEF_LIST - Dynamic vs Static for RDMLX components to avoid memory errors
  - Visual LANSA V11
  Static DEF_LIST may cause memory errors.
• Using Microsoft C++ 6.0 compiler with Visual LANSA Version 11
  - Visual LANSA V11
  How to correct issues with Visual LANSA 11.0 when compiling on a system with Microsoft Visual C++ 6.0.
• The x_err.log file in Visual LANSA
  - Visual LANSA All Versions
  Getting the most from the x_err.log file.
• How to deploy an external ActiveX control with your LANSA Application
  - Visual LANSA V10 and above
  Using Post Installation Commands to register ActiveX controls after application installation.
• An alternative way to send mails using Visual LANSA with Microsoft Outlook
  - Visual LANSA
  How to send mails using Visual LANSA without having to open the Microsoft Outlook window.
• Dynamically assigning button images
  - Visual LANSA
  Method for dynamically assigning images to buttons.
• Deployment Tool Package naming convention and Package Dependencies
  - Visual LANSA
  The use of Pre-requisite and Co-requisite packages should be used to ensure that packages are installed in the correct order, if package dependencies exist.
• How to reference a particular cell in a Grid and set it to ReadOnly
  - Visual LANSA
  This example code allows any cell to be set to Read Only.
• Visual LANSA Framework with latest EPC – Partition Initialisation
  - Visual LANSA Framework & the latest VLF EPC
  For Partition Initialisation and Partition creation, remove necessity of multiple imports of Visual LANSA Framework.
• How can I delete the values saved with the VF_SAVEAVALUE BIF during a session?
  - Visual LANSA Framework
  Making sure the saved values are deleted during a session in the Visual LANSA Framework.

Page 7 of 8

• How to set Debug Mode on for Visual LANSA execution environment
  - Visual LANSA
  There may be times where it is advantageous to debug an application at execution time rather than with in the development environment.
• The CreateAccessor and CreateIterator methods on Keyed Collections
  - Visual LANSA
  Descriptions of the CreateAccessor and CreateIterator methods in Keyed collections.
• How can I send email from Visual LANSA via Microsoft Outlook without getting the security message?
  - Visual LANSA
  When sending e-mails from within Visual LANSA, is there a way of getting over the Microsoft Outlook 2002 security block that pops up the message for the user to confirm.
• Imports for Visual LANSA run very slowly
  - Visual LANSA
  Imports running very slowly for Visual LANSA.
• Difference in ActiveX methods/properties between Office Suites
  - Visual LANSA
  Specific code written in a Visual LANSA component which allows integration with an Office 2000 application via ActiveX may not work for the same application integration with Office XP.
• Visual LANSA in a Citrix environment | Visual LANSA 10.0 and above
  This document containing installations instructions and findings when using Visual LANSA (based on Visual LANSA V10 with EPC715) in a Citrix environment.
• Easy demonstration on global scope and locally scoped components
  - Visual LANSA
  This tip demonstrates the difference between a locally scoped component and a globally scoped component.
• Closing forms that are "realized" but not shown
  - Visual LANSA
  Closing a form that is realized but not shown does not end the instance of the form.
• Differences between #Com_Owner, #Com_Ancestor and #Com_Self
  - Visual LANSA V9.1 and above
  The generic name #Com_Owner can be used to refer to the current component. In the context of inheritance there are two other generic names you can use for components: #Com_Ancestor and #Com_Self.
• Debugging Windows Server functions
  - Visual LANSA V9.1
  How to debug Windows server side functions that are executed by the CallServerFunction BIF.
• Potential reason for 'License not available' using *Licenses process
  - Visual LANSA
  Specifying the license code in lowercase can cause a 'Not Available' license message.
• Example of using SELECT_SQL in a remote procedure
  - Visual LANSA V9.1 and above
  Example code to invoke a server function using SELECT_SQL that can return up to 9999 entries to a client system.
• Using the deployment tool to export object source and all its dependent objects
  - Visual LANSA
  It is possible to use the Deployment Tool to make sure all objects are included.
• New System Variable *VISUAL_LANSA
  - Visual LANSA and LANSA for iSeries
  A new system variable called *VISUAL_LANSA has been introduced to distinguish between program execution on LANSA for iSeries and Visual LANSA.
• Using VAL_ERROR(*LASTDIS) in subroutine, Evtroutine and Mthroutine
  - Visual LANSA and LANSA for iSeries
  Application failure when using VAL_ERROR(*LASTDIS) in a subroutine does not occur when used in methods and events.

Page 8 of 8

• Conditioning grid cells for data entry
  - Visual LANSA
  A common requirement when using a grid for data maintenance, is to limit the pieces of data that can be changed conditionally e.g. a user does not have authority to change certain fields.
• Improving Client/Server data retrieval performance
  - Visual LANSA RDML Only
  Improve the performance for record retrieval when running Client/Server applications.
• Setting up the translation table for correct translation of characters used by Web
  - Visual LANSA and LANSA for the Web
  Setting up translation tables to avoid incorrect translation of '!'.
• Use Space BIFs to improve performance in Visual LANSA applications
  - LANSA for Windows V9.0 and above
  Performance improvements in Visual LANSA applications by using the SPACE BIFs.
• Upgrade LANSA for Windows on multiple client machines using Just-In-Time upgrade
  - LANSA for Windows V9.0 and above
  JIT scenarios to upgrade LANSA on client machines using JIT Upgrade.
• Options when using the Tab key with Grid Component in Visual LANSA
  - Visual LANSA
  Options when using the Tab key with Grid Component in Visual LANSA.
• Difference between ItemGotFocus and ItemGotSelection
  - Visual LANSA
  There is a difference between ItemGotFocus and ItemGotSelection and it only becomes evident in MultiSelect and Extended Selection situations.
• The Height property in Combo Boxes
  - LANSA for Windows
  How to enable a Visual LANSA user to change the Height property of a combo box.
• Setting Component Properties to their defaults at runtime
  - Visual LANSA
  Setting properties back to their default values at runtime.
• What RDML commands cannot be used in RDMLX?
  - LANSA for Windows
  Existing RDML commands that cannot be used in RDMLX based components.
• Keystrokes available in the LANSA for Windows Component Editor
  - LANSA for Windows V7.52 and above
  The Component Editor supports the standard range of keyboard keystrokes for editing programs.
• New parameter DASO= on X_RUN command
  - LANSA for Windows
  The Data Area Storage Option parameter allows you to emulate data area value storage and locking using flat files.
• What objects are displayed in the Check-in list dialog
  - LANSA for Windows
  Criteria by which objects are listed in the Check in dialog.
• Reporting Deployment Tool issues
  - LANSA for Windows
  A checklist for efficiently reporting issues to do with the Deployment Tool.
• LANSA for Windows Printing Enhancement to direct output to a file
  - LANSA for Windows
  LANSA for Windows reports can now be directed to a file rather than just to a printer.

Archive

• How to debug an RDMLX function executing on iSeries using the VL IDE Debugger
  - Visual LANSA V11.3
  Steps to debug RDMLX functions executing directly on an iSeries using the Visual LANSA IDE Debugger.
• Gathering information about LANSA
  - LANSA V10 and V11
  Using the 'About LANSA' feature to generate product information.
• Inserting Carriage Returns in a string
  - Visual LANSA V10
  This tip highlights how to insert a carriage return into a LANSA string/alpha field.
• Possible issues when deploying a LANSA application to Linux
  - Visual LANSA on Linux
  Possible import or compilation issues after deploying a LANSA application to Linux via SFTP.
• How do I know what EPCs are applied when I am running a run-time application?
  - Visual LANSA
  How to find out what EPC level a run-time Visual LANSA application is on.
• Visual LANSA Form Size proportionately increases
  - Visual LANSA
  Every time a form is saved or compiled, the size of the form proportionately increases.
• Deploying User Defined RDML BIFs using the Deployment Tool
  - Visual LANSA
  Manually created User Define RDML BIF's are not visible in the User Defined Built-in Functions section when adding objects to a Deployment Tool Package.
• Field Visualization in V10
  - Visual LANSA V10
  Downloadable document of Field Visualization usage in Visual LANSA V10.
• You must have a common 'Root' directory in Visual LANSA V10
  Visual LANSA V10 introduces the concept of the common root directory for a LANSA installation on Windows.
• Using Microsoft C++ .NET 2003 compiler with Visual LANSA V10
  What you need to set-up before using the Microsoft C++ .NET 2003 compiler with Visual LANSA V10 for compilation.
• Refreshing Explorer Component Content
  - Visual LANSA
  Example of how to refresh Explorer Component content i.e. new files and directories.
• Common reason for "packaging system is at earlier..." message
  - Visual LANSA
  Common reason for Deployment Tool package creation error "Packaged Execution Environment is at an earlier version than packaging system".
• Visual Modeler won't open with IE 5.5 and IE 6.0 security updates installed
  - Visual LANSA V9.1
  Internet Explorer and Security Update Q313675 will display a File Download Dialog Box when trying to start Visual Modeler.
• Using ActiveX Enum Constants and Visual LANSA
  Using MS Outlook ActiveX and ENUM Constants in a Visual LANSA Application.
• Questions regarding Active X ProgID
  - Visual LANSA
  On some development systems will not compile with a message that no component with Progid('Excel.Application.8') is enrolled.
• Sybase Connection timeout settings
  - Visual LANSA
  Applications may get database errors after being idle for a long time due to Sybase connection timeout settings in Client/Server environment.
• RichText32 OCX ActiveX control is needed when using the Visual LANSA Framework
  You need Microsoft RichTxt32.OCX ActiveX Control in order to use the Mock Up RAD-PAD filter handlers and the Mock Up RAD-PAD command handlers.
• One possible cause of the error "X_Put_To_Exchange_list" at the Host Repository Explorer
  - Visual LANSA
  Error messages for an invalid SuperServer (LXX) license on iSeries.
• When to use Package and when to use DLL JIT Upgrade
  - LANSA for Windows
  There are scenarios where a DLL Upgrade is the most efficient and suitable deployment model and there are scenarios where a Package upgrade is more suitable.
• The CONNECT_FILE BIF, Relative record number and last record read
  - LANSA for Windows
  The CONNECT_FILE BIF is used to direct Client server I/O to one or more database files.
• Possible compilation failures due to Anti-Virus software
  - LANSA for Windows
  Errors such as "General failure reading device .." can be generated during a compile in LANSA for Windows when Anti-Virus Checking software is enabled.
• Using MS ADO in Visual LANSA
  A sample and considerations when using Microsoft's ActiveX Data Objects (ADO) in Visual LANSA.
• Debug of Treeviews is dependent on focus
  - Visual LANSA
  When debugging a treeview in Visual LANSA sometimes it may seem that the debugger is faulty, when in reality it is dictated by how the focus moves when in debug.
• Object Locking and how it affects performance in LANSA for Windows
  Object Locking and its effects on performance.
• Deploying a SuperServer client application to another partition
  - LANSA for Windows
  Steps for deploying a SuperServer client application to another partition.
• Help files and the F1 key in Visual LANSA
  How to use customized Help files and the F1 key in Visual LANSA.
• Changing the Checkpoint time in SQL Anywhere
  - LANSA for Windows
  How to change the period between checkpoints in the SQL Anywhere database.
• Sorting dates in lists and grids
  - Visual LANSA
  Sorting DMY date fields in lists and grids.
• Visual LANSA Layout Managers
  - LANSA for Windows
  Layout Managers automatically manage the layout of a form. (Layout Managers is part of LANSA for Windows release 7.84)
• Transaction log file is very large – LX_LANSA.log
  - LANSA for Windows and Adaptive Server Anywhere
  The LANSA for Windows transaction log file is very large.
• Tree view HasChildren property
  - Visual LANSA
  A simple example of a tree showing department, section and employee data.
• Troubleshooting and reporting communications problems
  - LANSA Open and LANSA SuperServer
  A step by step guide to help determining the cause of a communications problem and what information is required by LANSA Support when it comes to reporting such a problem.
• How to use special characters in password type fields in the Visual LANSA component of LANSA for Windows
  A different method for putting password type characters on fields in the Visual LANSA component of LANSA for Windows.
• Connecting in SuperServer mode to a Windows server
  - LANSA for Windows and LANSA Open
  Some things to look at before trying to establish a SuperServer connection from either a LANSA for Windows application or a LANSA Open one to an NT Server box.
• Ending LCOTP.EXE jobs with Task Manager
  - LANSA for Windows
  Manually deleting lcotp.exe jobs will impact seat based licences.
• Backup LANSA for Windows database
  A solution to back up LANSA for Windows database via Windows NT scheduler.
• Keyboard Shortcuts must be attached to Menu Items
  - LANSA for Windows
  Shortcuts (eg. Ctrl+E, Alt+B, Ctrl+Shift+F, etc. etc.) on a popup menu will only perform the action if the popup menu item is also included as a submenu item on a menu bar.
• Computer Node Name in LANSA For Windows
  - LANSA for Windows
  The LANSA/PC Computer Node Name is not the same as the workstation's Computer Name.
• Using the LANSA Open non-English language translation file
  - LANSA Open - All Versions
  When using LANSA Open in a non-English environment, a translation file is used to handle the PC - AS/400 data translation.
• Copying tables between SQL Anywhere and MS SQL Server Databases
  - LANSA for Windows
  Procedure for copying individual tables between SQL Anywhere and MS SQL.
• Forming PC based DBMS performance expectations
  - LANSA for Windows
  Forming PC based DBMS performance expectations.
• What are the new RDMLX commands?
  - LANSA for Windows
  New RDMLX commands have been added to LANSA to support component definition and execution.
• Report does not print using Windows extended printing
  - LANSA for Windows
  Specifying a default font that the printer doesn't support in extended printing causes no report to be printed.
• Using SELECT_SQL WHERE with negative numbers
  - LANSA for Windows
  Workaround for when the SELECT_SQL's WHERE clause uses negative numbers, the sign has to be at the front.
• LANSA for Windows performance with local PC database
  - LANSA for Windows
  Improving performance of LANSA for Windows Applications with a local PC database.
• Passing a "full" working list between a client and a server system using PCX
  - LANSA for Windows
  Passing a large list from the server to the client with SuperServer has to make allowance for the space limitation which will affect the maximum number of entries which can be passed.
• Using % on the LIKE keyword on SELECT_SQL on LANSA for Windows
  Special consideration when using the % wildcard character on the LIKE keyword on the WHERE clause on the SELECT_SQL.
• Column heading width on screens and reports in multilingual partitions
  - LANSA for the AS/400 and LANSA for Windows
  When adding a field to the screen or a report, the column headings are wider than necessary. This could be caused by the column heading widths in other languages.
• Tricky things you can do with the Function Routing Table in LANSA for Windows!
  Use the function routing table on the PC to route a function call to actually calling a function on the AS/400.
• How to use system variables on the AS/400 from LANSA for Windows
  You can use any system variable on the AS/400 from LANSA for Windows when operating in a Client/Server environment.
• Finding the length of a string in LANSA | LANSA for the AS/400 and LANSA for Windows
  A couple of different ways to find out how many characters there are in a string.
• Conditioning the execution of virtual code | LANSA for the AS/400 and LANSA for Windows
  Conditioning the execution of virtual code based on whether a field has been requested in a LANSA I/O command. This can improve the execution of an I/O module.
• Editing the Function Routing Table
  - LANSA for Windows
  It is easy to edit the Function Routing Table.
• What is Function Routing in LANSA?
  - LANSA for the AS/400 and LANSA for Windows
  Function Routing allows the automatically (re)routing of invocations of a function to another function at execution time without changing a program.