Your Feedback

Visual LANSA Tutorials

About the Tutorials

Tips for using the Exercises

How many Developers can use the Exercises?

What Partition should I use?

Using Long Names

Tutorial Installation

User Interface Tutorials

VUI001 – Starting LANSA

Step 1. Starting the LANSA Development Environment

Step 2. Online Documentation

Step 3. F1 Context Sensitive Help

Summary

VUI002 – LANSA Editor Parts

Step 1. Editor Parts Overview

Step 2. Repository, Favorite, Outline, Details Tabs

Step 3. Docking/Undocking a Tab Sheet

Step 4. Reset Editor Settings

Summary

VUI003 – Repository Tab

Step 1. Repository Tab Contents

Step 2. Turn Alphabetical Grouping Off/On

Step 3. Arranging Columns in Repository

Step 4. Object Properties

Step 5. Accessing a Field

Summary

VUI004 - Details, Outline, Favorites Tab

Step 1. Copy the ADDRESS1 Field

Step 2. Details Tab

Step 3. View Errors

Step 4. Open Another Object in Editor

Step 5. Outline Tab

Step 6. Favorites Tab

Summary

LANSA Editor Tutorials

VED010 - Format Source Code

Step 1. Create a Copy of Form XDXSettingsDialog

Step 2. Create a Process and a Function

Step 3. Turn on Autohide

Step 4. Change Formatting Options

Step 5. Editor Source Settings

Step 6. Word Wrap

Step 7. Submit a Compile

Step 8. Display Error Log

Step 9. Display Feature Help Text

Summary

VED020 - Edit Source Code

Step 1. Cursor Position

Step 2. Position the Current Line

Step 3. Comment Lines

Step 4. Copy and Paste

Step 5. Find Text

Step 6. Use the Toolbar Find Button

Step 7. Use the Find Dialog

Step 8. Find and Replace

Step 9. Search Text in Several Objects

Summary

VED030 - Auto Complete and Command Assistant

Step 1. Display the Command Assistant

Step 2. Use the Command Assistant

Step 3. Use Auto Complete Prompter

Step 4. Use the Online Help Command

Summary

VED040 - Execute Applications

Step 1. Determine Compile Status

Step 2. Execute a Form

Step 3. Review the XDXExamples Application

Step 4. Execute the Application from the Execution History List

Step 5. Execute the Form from the Windows Start Menu

Summary

Repository Development Tutorials

REP000 - What is the LANSA Repository?

REP001 - Create Fields

Step 1. Prepare Your System

Step 2. Copy Fields

Step 3. Manually Create Fields

Step 4. Reference Fields

Step 5. Delete a field

Step 6. Create a Dynamic List for Your Fields

Step 7. Create and Execute Test Form

Step 8. Change your field definitions

Summary

REP002 - Field Visualizations

Step 1. Review iiiStartDate Field Visualization

Step 2. Review iiiEmployNotes Field Visualization

Step 3. Review iiiSalary Field Visualization

Step 4. View the Test Form

Step 5. Execute the Form

Step 6. Adjust the Form

Summary

REP003 - Validation Rules

Step 1. Review Existing Rule for iiiDeptCode Field

Step 2. Adopt Rule from Reference Field

Step 3. Create a Rule for the iiiSalary Field

Summary

REP004 - System and Multilingual Variables

Step 1. Review an Existing System Variable

Step 2. Create a System Variable

Step 3. Assign the System Variable as a Default Value

Step 4. Test System Variable using form iiiTestFields

Step 5. Review the System Variable (Optional)

Step 6. Review an Existing Multilingual Variable (Optional)

Summary

REP005 - Creating Files

Step 1. Create File Definition

Step 2. Compile the File

Step 3. Create Department Maintenance Form

Step 4. Execute Department Maintenance Form

Step 5. Create the Employee File

Step 6. Create Employee Maintenance Form

Step 7. Execute Employee Maintenance Form

Step 8. Database Attributes

Summary

REP006 - Logical Views

Step 1. Add a Logical View to Department File

Step 2. Create Department Test Form

Step 3. Execute Search by Description Form

Step 4. Add a Logical View to Employee File

Summary

REP007 - File Validation Rules/Triggers

Step 1. Add a Rule to file iiiDepartments

Step 2. Recompile the File and Test Department Rules

Step 3. Referential Integrity Rule in iiiEmployees File

Step 4. Add Rules to iiiSalary Field

Step 5. Recompile the File and Test Employee Rules

Step 6. Complete Referential Integrity

Step 7. Know about File Level Triggers

Summary

REP008 - Virtual Fields

Step 1. Add Virtual Fields to Employee File

Step 2. Calculation Virtual Field

Step 3. Concatenation Virtual Field

Step 4. Code Fragment Virtual Fields

Step 5. Create Test Form

Summary

REP009 - Access Routes and Predetermined Join Fields

Step 1. Understand the Database Relationship

Step 2. Create Access Route from Department File

Step 3. Create Access Route from Employee File

Step 4. Create Fields in the LANSA Repository

Step 5. Add File Lookup PJF to Employee File

Step 6. Test New PJF in Employee File

Step 7. Add PJFs to Department File

Step 8. Modify Test Form

Summary

REP011 - Repository Summary

Step 1. Create the File Definition

Step 2. Modify Field Definitions

Step 3. Add Rules to the File

Step 4. Create and Execute a Test Form

Step 5. Add a Virtual Field to Your File

Step 6. Create an Access Route and a Predetermined Join Field (PJF)

Step 7. Recreate Employee Holidays Application

Step 8. Create a Logical View and Test

Summary

REP012 - Check In Objects (Optional)

Step 1. Confirm Connection to LANSA Master System (Optional)

Step 2. Check in the Department File and Fields

Step 3. Verify Objects Exist on the Server

Step 4. Execute Your Application Client Server

Summary

Programming RDML with Visual LANSA Forms

FRM015 - Getting Started with Forms Programming

Step 1. Editor Settings

Step 2. Create a Component

Step 3. Add Components to the Form

Step 4. Change the Properties of a Component

Step 5. Add Remaining Push Buttons and Set their Properties

Step 6. Add a Field to the Form and Set its Properties

Step 7. Create Event Routines for the Push Buttons

Step 8. Add Logic to the Hello Button Click Event

Step 9. Add Logic to the Other Click Events

Step 10. Compile the Form

Step 11. Execute the Form

Step 12. Align and Size Components

Step 13. Component Definitions

Step 14. Understanding Events

Step 15. Using Component Properties

Step 16. Understanding Component Methods

Summary

FRM025 - Insert a Database Record

Step 1. Create form iiiAddEmploy – Add Employee

Step 2. Add Fields to the Form

Step 3. Add Push Buttons and Click Event Logic

Step 4. Using a Busy Cursor

Summary

FRM035 - Maintain a Simple Database Table

Step 1. Create a Department Maintenance Form

Step 2. Fetch Existing Data from a File

Step 3. Insert Data to a File

Step 4. Add Program Level Validations

Step 5. Update Data in a File

Step 6. Delete Data from the File

Step 7. Update and Delete Last Record Read

Summary

FRM035 – Appendix

FRM045 - Using LANSA Debug

Step 1. Execute Applications with Debug

Step 2. Debug Features

Step 3. Set Breakpoints

Step 4. Display/Change Variables

Step 5. Set Breakpoint Properties

Step 6. Set a Break on Value

Summary

FRM055 - List Component Basics

Step 1. Create a Simple List

Step 2. Select Data to Fill the List

Step 3. Create Multiple Lists

Step 4. Fill the Lists

Step 5. Make List View Columns Sortable

Step 6. Change Appearance of the Form

Step 7. Read Sorted List Items (optional)

Step 8. Sort Department and Sections Combo Boxes (optional)

Summary

FRM065 - Using List Components

Step 1. Create Form – Using Lists

Step 2. Make Radio Buttons Show and Hide Fields

Step 3. Add Search Logic

Step 4. Add Tab Folder and Tab Sheets to the Form

Step 5. Populate the Tab Sheets

Summary

FRM075 - Using a Working List

Step 1. Select Multiple Entries

Step 2. Use a SELECTLIST Command

Step 3. Build a Working List

Step 4. Create a CSV File

Summary

FRM085 - Update from a Grid

Step 1. Create Field iiiMONTH and Visual Picklist

Step 2. Create Form – Update from List

Step 3. Add Search Logic

Step 4. Display Employee Details and Skills

Step 5. Update Employee Details

Step 6. Update Employee Skills

Step 7. Add Drop Down for Skill Code (optional)

Summary

FRM095 - Calling a Function

Step 1. Create the Called Function

Step 2. Create Salary Review Form

Step 3. Test Salary Review Application

Summary

Appendix A. FRM095

Appendix B. FRM095

FRM105 - Define a Trigger Function

Step 1. Create a Trigger Function

Step 2. Define a Salary Trigger for Employee File (PSLMST)

Step 3. Create an Employee Salary Change Form

Step 4. Test your Employee Salary Trigger

Summary

Appendix A. FRM105

FRM115 - Writing Reports

Step 1. Create a Simple List Style Report Using a Template

Step 2. Call a Function

Step 3. Enable For Full RDMLX

Step 4. Manually Create a Reporting Function

Step 5. Add a Header and Footer

Step 6. Keep Statistics and Print

Step 7. Add a Grand Total Line

Summary

FRM125 - Check Out / In to IBM i

Step 1. Create a LANSA for iSeries Object

Step 2. Refresh Objects in Visual LANSA

Step 3. Check Out Object

Step 4. Check In Changes

Step 5. Delete from Repository

Summary

Visual LANSA Framework (VLF) Introduction

Common Exercises

LVF040 - Execute Framework Application

Step 1. Execute the Visual LANSA Framework

Step 2. Execute an Application

Step 3. Using Filters to Find an Employee

Step 4. Using Commands and Command Handlers

Summary

LVF060 - Create a Prototype

Step 1. Understand the Requirements

Step 2. Create a Prototype Application – iii HR

Step 3. Define Filters and Command Handlers

Summary

VLF for Web Application Module (WAM) Applications

LVF070WAM - Snap in a Real WAM Web Filter

Step 1. Create Your Real WAM Filter

Step 2. Snap In the WAM By Name Filter

Step 3. Create a WAM By Location Filter

Step 4. Snap in the WAM By Location Filter

Summary

LVF075WAM - Snap in a Real WAM Web Command Handler

Step 1. Create Your Real WAM Command Handler

Step 2. Snap in Your WAM Command Handler

Summary

LVF080WAM - Add Instance List Columns in WAM Applications

Step 1. Add Columns to the Instance List

Step 2. Change your filter

Summary

VLF for Windows Applications

LVF070WIN - Snap in Real Windows Filters

Step 1. Create your Real By Name Filter

Step 2. Snap in the By Name Filter

Step 3. Filter Code

Step 4. Create a Real By Location Filter

Step 5. Snap in the By Location Filter

Summary

LVF075WIN - Snap in A Real Windows Command Handler

Step 1. Create your Real Command Handler

Step 2. Snap in your Command Handler

Summary

LVF080WIN - Add Instance List Columns in Windows Applications

Step 1. Add Columns to the Instance List

Step 2. Change your filter

Summary

Appendix A. Personnel Demonstration System

Personnel System

Physical Database Map of Personnel System

Sample Data in the Personnel Files