AGS Call to table

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Robert
Veteran Member Send Private Message
Posts: 82
Veteran Member
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
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 82
Veteran Member
Thanks John, I thought that was the case.
KK - Infor
Veteran Member Send Private Message
Posts: 61
Veteran Member
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