Prev
Next
Forums Integration / Customization IPA/ProcessFlow

AGS Call to table

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Robert
Veteran Member
Posts: 82
Veteran Member
4/21/2010 7:08 PM
    I want to update and write records to a table. The Transaction API builder does not support methods if String Type=Database Tables.

    I thought I was updating tables vi RSS/ESS. i went back and reviewed the javascript code and AGS Objects are instantiated using a Form.
    John Henley
    Posts: 3353
    4/21/2010 8:00 PM
      AGS calls methods on forms. You have to use the SQL Update node (available only in ProcessFlow Integrator) to be able to write directly to a table.

      Thanks for using the LawsonGuru.com forums!
      John
      Robert
      Veteran Member
      Posts: 82
      Veteran Member
      4/21/2010 8:46 PM
        Thanks John, I thought that was the case.
        KK - Infor
        Veteran Member
        Posts: 61
        Veteran Member
        4/22/2010 7:06 PM
          Robert,
          Just keep in mind that direct SQL Updates on Lawson Tables is not recommended and supported by Lawson. I would rather update a custom table using SQL and then build a flow to bring that data to Lawson using the standard APIs.

          KK