Modify form data programatically

[Jared_Langdon]

How can I modify my form data programatically using Workflow? I know that I can set the values in individual XML nodes, but how do I add and remove the nodes themselves? For example, say I want to do a database lookup and add XML nodes for each record returned before rendering the form with a Render QPAC. Thanks.



Jared

[HowardTreisman]

Hi Jared

Using the Avoka SQLPlus QPAC, you can designate a repeating node in an exising XML or Form object, and specify that the rows from the SQL result set should be inserted at that level.

You can download SQLPlus here: http://www.avoka.com/avoka/qpac_library.shtml



Please see the documentation with the QPAC, and contact support-at-avoka.com if you have any difficulties.



If you need to merge some other data (i.e. not SQL result set) into a form, then you'll need a different QPAC. Let me know on this forum if this is the case.



Regards,

Howard

http://www.avoka.com