Databases Reference
In-Depth Information
tab form emp pkg.get autocomplete key
(tab form emp pkg.get manager for id (mgr),
'f05',
'#ROWNUM#',
85,
'get manager'
) mgr search,
mgr, hiredate, sal, comm, deptno, valid
FROM emp
Listing 3-17 shows the get_autocomplete_key function between columns
JOB
and
MGR
. This function
will have input parameters for
•
ENAME
of the existing manager returned by the function
get manager for id
The referenced item in which you will parse the key value
f05
•
•
Row number for the current row
•
The width in pixels for our select list
•
The name of the corresponding On-Demand Process
To get the newly created column
MGR SEARCH
into the right order, you will edit the Tabular Form
properties and place the column
MGR SEARCH
between columns
JOB
and
MGR
.
For the On-Demand Process
get manager
, use a simple PL/SQL block:
BEGIN
tab form emp pkg.get manager;
END;
Finally, modify the HTML Expression of the Tabular Form column MGR to
<input type="text" id="f05 #ROWNUM#" value="#MGR#" maxlength="2000" size="16" name="f05"
autocomplete="off">
You will also need to change the Column Properties of the MGR_SEARCH column from Display as
Text… to Standard Report Column.
If you now run the page, edit the
MGR SEARCH
column, and start typing, you should get the list of
managers. If you select one of them, the entry in the column
MGR
should change to the corresponding
EMPNO
of the selected
ENAME
. The result should look similar to Figure 3-36.