background image
<< Testing an Object's Data | Test the properties of LOVs >>
<< Testing an Object's Data | Test the properties of LOVs >>
Testing LOVs and Record Groups
Testing an Object's Data
12-15
Testing LOVs and Record Groups
You can use the Object Data verification point to test the data in list of values (LOV)
and record group objects in Oracle Forms. (You can also use the Object Scripting
commands. For information, see Object Scripting Commands on page 12-13.)
To test an LOV or record group, you need to perform two steps:
1. Create an .sqa text file containing information about the LOV or record group.
2. Create the Object Data verification point.
Creating an .SQA Text File
Before you test an LOV or record group, you need to create an .sqa text file. To create
this file:
1. Before creating the verification point, identify which LOV or record group
objects to test, including:
The Form containing the LOV or record group.
The internal Oracle name of the LOV or record group.
The names of the data columns and each column's data type (char, number,
or date).
You may need to get this information from the developer of the form.
2. In the same directory as the form's executable (.fmx) file, create a text file with
the same name as the .fmx file, but with an .sqa extension.
For example, if the form's executable file is Oraapp32.fmx, create a text file
named Oraapp32.sqa.
3. In the .sqa text file, type:
An [LOV] section containing the names of all LOVs to test.
A [RECORD_GROUP] section containing the names of all record groups
to test.
The name of each LOV, the name of each column, and the data type of each
column.
The name of each record group, the name of each column, and the data type
of each column.
NOTE: Once you create the .sqa file, you can also test the properties of LOVs
and record groups using the Object Properties verification point.