PF Update Custom Table

AGS is for calling existing Lawson forms only. If you have a custom 4GL form with and Add function code that updates this new table then you can use an AGS call. If you have ProcessFlow Integrator you can use the SQL Update node to add a record, otherwise you will have to create a custom 4GL form with add logic and use AGS to perform this type of transaction

Could I place add logic on the custom form that exists using design studio, hide it from users, and invoke it from the flow.

I think that would be neater than writing another custom form.

Posted By TommyT on 03/12/2010 10:27 AM
Could I place add logic on the custom form that exists using design studio, hide it from users, and invoke it from the flow.

I think that would be neater than writing another custom form.

The logic you would need to add would be to the COBOL code underneath.  There is no way using Design Studio (a presentation layer only) to add logic to add records to a Lawson table custom or otherwise.   
 

Design Studio is really only used to add/remove functionality of Lawson forms on Portal.  You can not invoke a Design Studio form using AGS, it always executes the COBOL underneath only.

Sorry I'm not stating what I need to do clearly...

We have a table which contans one item of extended data on each hr department - and a form that allows for editing that field. The custom table contains the hr department #, and the extra field. The custom form is xx02;  it only allows changes and only to the custom field.

When a new department is added to the department table via HR02, the custom table gets out of synch because it doesnt know about the new dept.  We want to add that new department in the backround to the custom table when its added to the lawson dept table via hr02. The goal is simply to add a record to the custom table when one is added to the dept table.

I added a trigger to hr02 to kick off a process flow meant to add the record to the custom table.  It kicks off properly when a record is added via hr02. My problem is the ags call in that flow....  (we  dont have pf integrator).  xx02 does have cobol code that is a copy of hr02 with the "add" functionality clipped off by design studio.

Can I call the xx02 form with the ags to add the record?

You should be able to do an AGS call against your form. You could try playing with it using Excel MS Add-Ins. If you can get to it with Add-Ins then ProcessFlow should also work.

Thanks all.  Ill give it a try.