Using the Callframe Statement
To pass data from the database into a called frame with QUEL, use a retrieve statement to assign database values to a form or table field in the called frame, as shown below:
callframe newframe (newform = retrieve
(projinfo.projnum, projinfo.projname)
where projinfo.projnum = projno);
In this example, the current frame calls Newframe, passing values from the Projinfo table into a form named Newform. The where clause restricts the retrieval to a specific project number, which appears in the current frame's projno field.
Last modified date: 04/03/2024