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.