How to include a field from a hold file in an embedded html in a fex?
How to include a field from a hold file in an embedded html in a fex?
(OP)
Here is the code of what I am trying to do. I want to pull only the Project Number field from the hold file onto my html form. Any help would be greatly appreciated!
SET SQLENGINE=SQLORA
SQL SET SERVER &MYSERV
SQL SELECT
det.AGREEMENT_NUM,
det.PROJECT_NUMBER,
det.DURATION
FROM AGREE_DETAIL det
WHERE det.AGREEMENT_NUM = '018060621';
TABLE
ON TABLE HOLD AS INVOICE
END
-RUN
-HTMLFORM BEGIN
<HTML>
<TITLE>ADVANCED FUNDS INVOICE REQUEST</TITLE>
<HEAD><CENTER><STRONG>ADVANCED FUNDS INVOICE REQUEST</STRONG></HEAD>
<HR WIDTH=640>
<BODY>
<TABLE WIDTH=85% BORDER=0>
<tr><td>TO: </td>
<td>Dept. 9513</td>
<td>FROM:</td>
<td>Dept. 9112</td></tr>
<tr><td>NAME:</td>
<td>Margie Shuford</td>
<td>PROJ NUM:</td>
<td>!IBI.FIL.INVOICE.PROJECT_NUMBER;</td></tr>
</BODY>
</HTML>
SET SQLENGINE=SQLORA
SQL SET SERVER &MYSERV
SQL SELECT
det.AGREEMENT_NUM,
det.PROJECT_NUMBER,
det.DURATION
FROM AGREE_DETAIL det
WHERE det.AGREEMENT_NUM = '018060621';
TABLE
ON TABLE HOLD AS INVOICE
END
-RUN
-HTMLFORM BEGIN
<HTML>
<TITLE>ADVANCED FUNDS INVOICE REQUEST</TITLE>
<HEAD><CENTER><STRONG>ADVANCED FUNDS INVOICE REQUEST</STRONG></HEAD>
<HR WIDTH=640>
<BODY>
<TABLE WIDTH=85% BORDER=0>
<tr><td>TO: </td>
<td>Dept. 9513</td>
<td>FROM:</td>
<td>Dept. 9112</td></tr>
<tr><td>NAME:</td>
<td>Margie Shuford</td>
<td>PROJ NUM:</td>
<td>!IBI.FIL.INVOICE.PROJECT_NUMBER;</td></tr>
</BODY>
</HTML>
RE: How to include a field from a hold file in an embedded html in a fex?
CODE
PRINT PROJECT_NUMBER
ON TABLE HOLD AS PROJNUM FORMAT ALPHA
WHERE RECORDLIMIT EQ 1
END
-RUN
This will write out the first instance of PROJECT_-NUMBER to a file called PROJNUM, and will save it as character format (if it was numeric, you DON'T want it in internal/binary format). The final '-RUN' executes the commands.
Then, issue the following:
CODE
This will read the first (and only) value in that file into a Dialogue Manager variable called &PROJECT_NUM. From then on, you can use this value (as !IBI.AMP.PROJECT_NUM;) in your HTMLFORM.
RE: How to include a field from a hold file in an embedded html in a fex?
RE: How to include a field from a hold file in an embedded html in a fex?
CODE
or write them out comma delimited, and read them in free-format:
CODE