Yes I use the assign command.
Ephraim Feldman
-----Original Message-----
From: "nustepvantage" <dpfiester@...>
Sender: vantage@yahoogroups.com
Date: Thu, 22 Dec 2011 16:07:46
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Problem
Hi Ephraim,
This may be a dumb question, but what do you mean by a direct update? Do you mean using the Assign command?
Thanks,
David Pfiester
Ephraim Feldman
-----Original Message-----
From: "nustepvantage" <dpfiester@...>
Sender: vantage@yahoogroups.com
Date: Thu, 22 Dec 2011 16:07:46
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Problem
Hi Ephraim,
This may be a dumb question, but what do you mean by a direct update? Do you mean using the Assign command?
Thanks,
David Pfiester
--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> Why is the update table buffer needed at all ?
> I always do a direct update.
>
>
> Ephraim Feldman
>
> -----Original Message-----
> From: Jose Gomez <jose@...>
> Sender: vantage@yahoogroups.com
> Date: Thu, 22 Dec 2011 09:46:19
> To: <vantage@yahoogroups.com>
> Reply-To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BPM Problem
>
> Try move it to Post Proc and see if it helps, also I beleive on 9.05 u
> don't need Update Table Buffer anymore, that may or may not be your issue.
>
> For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
>
> Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
>
> run lib/UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE,'NeedByDate',
> ttOrderHed.Date06).
>
> End.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Dec 22, 2011 at 9:32 AM, nustepvantage <dpfiester@...> wrote:
>
> > **
> >
> >
> > Hello All,
> >
> > I have a BPM using a pre-processing SalesOrder.Update method in Epicor
> > 9.05 that I need help trouble shooting. When a UDF field is filled in the
> > BPM changes the OrderHed.NeedBydate to the same date as in the UDF and also
> > changes the OrderDtl.NeedByDate in all sales order lines. Below is my code:
> >
> > For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> > ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> > OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
> >
> > Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
> >
> > run lib/UpdateTableBuffer.p(input BUFFER
> > OrderDtl:HANDLE,'NeedByDate',ttOrderHed.Date06).
> >
> > End.
> >
> > When the BPM runs it generates a 'Row has been modified by another user
> > and couldn't be updated." message. The OrderDtl.NeedByDate fields update
> > fine, but the OrderHed.NeedByDate does not. The error detail refrences the
> > table OrderHed. The Row as 0x000000000092b40e, and the Field as SysRevID.
> > Would anyone have an idea on what I am doing wrong in this BPM?
> >
> > Thanks,
> > David Pfiester
> > NuStep, Inc.
> > 734-418-1850
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
[Non-text portions of this message have been removed]