You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to increase the value of part of the ID (nomenclature) in an Insert Into

edited Jul 29, 2024 12:29PM in Transportation Management 13 comments

Summary:

In our business logic each Servprov can have 2 or more Accessorial Code.

Our objective is that, by checking the 'Active' box of a Rate Record, an Accessorial Cost with a specific nomenclature is automatically created for each Accessorial Code that has that Servprov.

At the moment, there is an 'Agent 1' that, when the Active box of a Rate Record is modified, triggers the call from another 'Agent 2'.

This 'Agent 2' consists of some variables and a 'FOR EACH' action that refers to the fact that, for each Accessorial Code that exists for that Servprov, it triggers another 'Agent 3' in charge of performing the INSERT INTO ACCESSORIAL_COST and creating an Accessorial Cost Gid for each Accessorial Code.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!