BPM Question V8.03.405a

I had “AND ttOrderDtl.RowMod <> ‘’ “ in there and it still did it

 

I will toss some message lines in there to verify what OrderLineNo is tossing the message

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, March 25, 2014 4:53 PM
To: Vantage
Subject: Re: [Vantage] Re: BPM Question V8.03.405a

 




The reason you are getting that error is because you are not narrowing down your criteria to the modified rows. You can simply add where ttOrderDtl.RowMod ='A' or 'U' and it should stop doing that. If for some reason you want to modify the rest of the OrderDtl's at the same time then 

You can fix it by simply refreshing the data-set on the post processing event. Run a GetByID call on the  dataset on Post Processing after you've code has ran. The code to do this is already in the forum 



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Mar 25, 2014 at 2:34 PM, <bwalker@...> wrote:

 

Method is SalesOrder.Update

The POLine field is for the customer's PO Line (a character field).

I need the numeric value of POLine to be copied into Number01
I have it running Pre Process and it works for new entries - it throws the error when you go back into the line and try to edit the POLine field.

 




Is it possible to have a BPM change the value of a field Pre-Process and not get the infernal Record has been modified by another user and couldn’t be  updated.  Please press the refresh button and re-enter your changes.

 

Condition: ttOrderDtl.PONum field changes from any to any

Action: Execute 4GL Code:

for each ttOrderDtl where DECIMAL(ttOrderDtl.POLine) <> ttOrderDtl.Number01.
 assign ttOrderDtl.Number01 = DECIMAL(ttOrderDtl.POLine).
end.


Depends on the object you are putting it on.  On an update method shouldn't be a problem.  On other methods a post processing may be the appropriate place unless you want the method to act on the data. 

Not knowing exactly what you are doing/why this might be a good one for Post Processing on the Get new PO line.  The only time the PO Number field would change is upon line creation.

Jim Kinneman
Encompass Solutions, Inc

Method is SalesOrder.Update

The POLine field is for the customer's PO Line (a character field).

I need the numeric value of POLine to be copied into Number01
I have it running Pre Process and it works for new entries - it throws the error when you go back into the line and try to edit the POLine field.

The reason you are getting that error is because you are not narrowing down your criteria to the modified rows. You can simply add where ttOrderDtl.RowMod ='A' or 'U' and it should stop doing that. If for some reason you want to modify the rest of the OrderDtl's at the same time then 
You can fix it by simply refreshing the data-set on the post processing event. Run a GetByID call on the  dataset on Post Processing after you've code has ran. The code to do this is already in the forum 


Jose C Gomez
Software Engineer



T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Tue, Mar 25, 2014 at 2:34 PM, <bwalker@...> wrote:

 
<div>
  
  
  <p></p><p>Method is SalesOrder.Update</p><p>The POLine field is for the customer&#39;s PO Line (a character field).</p><p>I need the numeric value of POLine to be copied into Number01<br>I have it running Pre Process and it works for new entries - it throws the error when you go back into the line and try to edit the POLine field.</p>

</div>
 


<div style="color:#fff;min-height:0;"></div>