Show Contents List

Using Subfile Accessor

A typical Work With screen has a subfile/browselist of objects (in this example Employees), each with an option field.
In RAMP a subfile is displayed as a data grid.
In this tutorial we want to enter option "8" in front of a specific entry in the data grid:
Name the data grid
Open the screen in newlook Designer, click on the grid and specify EMPLOYEE_LIST as the Name property in the Misc section.
Note that the data grid and the subfile have different numbers of columns and rows

• A data grid starts column and row numbering from 0 and includes the header rows
• Column numbers are not necessarily sequential in a data grid
• Columns have names based on the text in the column headings

To select an employee in the grid using SUBFILE_ACCESSOR
Create the SUBFILE_ACCESSOR object:
var SFL = new SUBFILE_ACCESSOR ("EMPLOYEE_LIST");
 
Put an "8" somewhere in column "Opt":
SFL.SetSelectionColumnName("Opt","8");
 
Then locate the employee that has "A0090" in column "EmployNumber":
SFL.SetSearchColumnName("EmployNumber","A0090");
 
Put the value into the subfile:
SFL.SelectSubfileEntry();
 
Lastly, destroy the subfile object:
SFL.Dispose();
 
Do not write subfile code manually
Instead see how to create a subfile script Using the Scripting Pop-up Menu and then modify it as required.
Find out row and column names
Use the Probe button which appears on RAMP screens.
 
Also see SUBFILE_ACCESSOR Object.
 
 
 
Show Contents List