documentation
.HELP!
Visual LANSA Documentation
Summary
Visual LANSA
previous page
next page
Summary
What You Should Know
How to add columns to an instance list.
How to modify a filter to maintain additional instance list columns.
You would normally change all filters for the instance list.
previous page
start
next page
Menu
Homepage
Table of contents
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
Your Feedback
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
Get in touch
Submit feedback about this site to:
[email protected]