General Tips
| 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 |