General Tips

Reset
Date Version Tip  
May 13, 2016 Visual LANSA V14 How to test your Web Configuration is running
Easy ways to test your web site is correctly configured.
 
Apr 1, 2016 Visual LANSA V14 Steps to enable debugging for Server Modules
How to enable debugging of Server Modules Visual LANSA Web
 
Mar 21, 2014 LANSA Open for .NET A LANSA Open for .NET license error can be generated if all installation steps are not completed
When setting up LANSA Open for .NET there is an import for each platform that must be completed to avoid execution issues
 
Jul 02, 2011 Visual LANSA Deployment Tool V12 Adding shortcuts to the desktop with a Deployment Tool Package
How to use After-Install Commands to add your own shortcuts to the Desktop
 
Dec 11, 2009 LANSA for the Web Using Fiddler for Internet troubleshooting
Instructions for attaining Fiddler trace details for troubleshooting
 
Dec 11, 2009 LANSA for the Web Completely clearing out the cache in IE8
Uncheck Preserve Favorites website data option in IE8 to clear the browser cache
 
Jul 28, 2005 LANSA for iSeries Installing LANSA on a French iSeries via emulation
Special characters in program library name during French LANSA for iSeries install
 
Aug 4, 2003 LANSA for iSeries E-mailing an iSeries Spooled File
How to use Client Access to email Spooled Files
 
Apr 14, 2003 LANSA for iSeries Unable to display routing table information
When attempting to display LANSA Configuration information, it may fail with a message
 
Archived LANSA V10 and V11 Gathering information about LANSA
Using the 'About LANSA' feature to generate product information
 
Archived All Platforms Data Warehousing, LANSAs Practical Solution - Part 1
Data Warehousing, LANSA's Practical Solution - Part 1
 
Archived All Platforms Data Warehousing, LANSAs Practical Solution - Part 2 Data Warehousing, LANSA's Practical Solution - Part 2  
Archived All Platforms Using database field validations in your LANSA functions
Existing database field validations can be used in a LANSA function without having to add lots of checks to individual functions
 
Archived All Platforms Using LANSA fields in SELECT_SQL WHERE parameter Existing database field validations can be used in a LANSA function without having to add lots of checks to individual functions  
Archived All Platforms LANSA and SQL Tip : Subselect parameter "ANY"
The "ANY" subselect parameter can be used to execute a sub-selection from another file, before carrying out a requested selection
 
Archived All Platforms LANSA and SQL Tip : Scalar Built-In functions
A few handy examples of scalar built-in functions in SQL
 
Archived All Platforms LANSA and SQL Tip: Scalar built in functions(2)
A few examples of the scalaire built in functions SUBSTR, CONCAT, MAX and MIN
 
Archived All Platforms LANSA and SQL Tip : Auto-Join
SQL can be used to select records from a file based on comparing values of records within the same file
 
Archived All Platforms Using binary searches on workinglists in LANSA
Binary searches are a quick method of finding particular values in a workinglist
 
Archived All Platforms Cascading Updates and Deletes in LANSA
How to cascade updates and deletes in LANSA using Triggers
 
Archived All Platforms Converting numbers to alphanumeric strings using a BUILTIN function
Sometimes negative numbers do not convert successfully to alphanumeric strings. There is a Builtin function available that will solve this
 
Archived All Platforms Formatting numeric output in LANSA
Usually when printing cheques the value is printed in words and the amount is formatted either as' $100.80', or '****100.80' instead of '0000100.80'
 
Archived All Platforms Return Codes for RDML data base access commands
Return codes for the various LANSA data base access commands
 
Archived LANSA for iSeries &
Visual LANSA
Converting Digits to Words in LANSA
Converting a number to into the corresponding word that represents the number
 
Archived All Platforms Converting an uppercase string so that just the first character in each word is uppercase
RDML code that will convert a string from all uppercase to just having the first character in each word in uppercase
 
Archived All Platforms The #PROMPT$FN field
Multiple fields sharing a common prompt function need to use the #PROMPT$FN field
 
Archived LANSA for iSeries &
Visual LANSA
Function Routing in detail
This tip provides a more detailed view of Function Routing in LANSA and how to use it
 
Archived All Platforms Creating Portable Programmed Virtual Fields
Virtual fields in RDML can be created that are then portable to various platforms
 
Archived All Platforms Validations ARE carried out on Pre-Determined Join Fields
Validations ARE carried out on Pre-Determined Join Fields
 
Archived All Platforms Identifying Built-in functions (BIFs)
It is important that developers are aware of the importance of correctly identifying any BIF
 
Archived Visual LANSA, LANSA Open,
LANSA Client
Running the Listener in a dedicated subsystem
By default, the listener job will run in the subsystems determined by the job description of the user starting the listener. You can, however, create a subsystem to run the listener(s) in
 
Archived LANSA for iSeries Command to create LANSA Listener subsystem
Creating the LANSA listener within its own subsystem by creating a user defined command and CL program to create the needed objects