Thanks to both of you... didn't realise I could assign to tt tables so hopefully that might help with some other stuff I've been working on too :)
Was a little more to it though... the code only updated the contact if it was on a Purchasing Point so I also need to do the same for the ttVendCntMain table. But it works!! :)
Was a little more to it though... the code only updated the contact if it was on a Purchasing Point so I also need to do the same for the ttVendCntMain table. But it works!! :)
--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> As Jose indicates with TT tables you can do assigns regardless of whether is it Vantage or E9, updateTableBuffer is only needed if you are updating the actual physical table in Vantage.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "tracy.tmat" <tracy.smith@> wrote:
> >
> > Have been working on Update Pre-Processing so at least got something right... we're on Vantage 8 so can't assign but have tried the following:
> >
> > for each ttVendCnt where ttVendCnt.RowMod = "U".
> >
> >
> > if available ttVendCnt then
> > DO:
> >
> > {lib/PublishInfoMsg.i &InfoMsg = "'FIRE!!!!'"}.
> > run lib\updatetablebuffer.p(input BUFFER ttVendCnt:HANDLE,'ChangeDate',TODAY).
> > END.
> > end.
> >
> >
> > Message isn't even firing?
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > You need to fire this on BPM Update Pre-Processing
> > >
> > >
> > > FOR EACH ttVendCnt WHERE ttVendCont.RowMod='U':
> > > Assign ttVendCnt.ChangeDate=TODA.
> > > END.
> > >
> > >
> > >
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *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 Mon, Aug 20, 2012 at 11:27 AM, tracy.tmat <tracy.smith@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > All I want to do is date / user stamp when a Supplier contact record is
> > > > updated... according to Data Dictionary Vantage should do this but
> > > > unfortunately it doesn't :(
> > > >
> > > > I have been trying to update the Change fields already there but am not
> > > > bothered if I have to use UD fields (didn't think it would make any
> > > > difference?)
> > > >
> > > > Any advice is much appreciated... Thanks.
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > >
> > > > > on tt Tables?...
> > > > >
> > > > > Can you tell us what exactly you are trying to do? Your where clauses
> > > > needs
> > > > > to be on the Find.... but if you tell me exactly what you are trying to
> > > > > find / do I can give you futher help.
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *
> > > > > *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 Mon, Aug 20, 2012 at 10:04 AM, tracy.tmat <tracy.smith@> wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > I did try putting in a where clause on the tt tables for the rowmod = U
> > > > > > but can't see how I can filter the main VendCnt table?
> > > > > >
> > > > > > Thanks.
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > > > > >
> > > > > > > Are you trying to update all vedcontact records?
> > > > > > >
> > > > > > > Like someone mentioned before, you don't have a WHERE clause so it
> > > > will
> > > > > > > only find the first one...
> > > > > > >
> > > > > > > /* Update Change Date & ID */
> > > > > > >
> > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'FIRE!!!!'"}.
> > > > > > >
> > > > > > > find first VendCnt where VendCnt.Company = CUR-COMP no-lock no-error.
> > > > > > >
> > > > > > > if available VendCnt then
> > > > > > > DO:
> > > > > > > run lib\updatetablebuffer.p(input BUFFER
> > > > > > VendCnt:HANDLE,'ChangeDate',TODAY).
> > > > > > > END.
> > > > > > >
> > > > > > >
> > > > > > > *Jose C Gomez*
> > > > > > > *Software Engineer*
> > > > > > > *
> > > > > > > *
> > > > > > > *
> > > > > > > *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 Mon, Aug 20, 2012 at 9:53 AM, tracy.tmat <tracy.smith@> wrote:
> > > > > > >
> > > > > > > > **
> > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > I've tried a few different possibilities and here are my results so
> > > > > > far...
> > > > > > > >
> > > > > > > > Using ttVndCnt table (not shown on code screen)- the BPM doesn't
> > > > fire
> > > > > > at
> > > > > > > > all
> > > > > > > >
> > > > > > > > Using ttVendCntMain (is shown on code screen) - the BPM 'fires' but
> > > > > > > > doesn't update
> > > > > > > >
> > > > > > > > Using VendCnt - the BPM fires but only updates the first contact
> > > > record
> > > > > > > >
> > > > > > > > Any suggestions?
> > > > > > > >
> > > > > > > > Have also noticed that I am trying to do a lot more with the BPM's
> > > > that
> > > > > > > > need the code and most of it is a little out of my reach as I have
> > > > no
> > > > > > > > programming training. What is the best way to learn... formal
> > > > training,
> > > > > > > > manuals, online? Thanks!
> > > > > > > >
> > > > > > > >
> > > > > > > > --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> > > > > > > > >
> > > > > > > > > The temporary tables (ttVendor, ttVendCnt etc) do have the
> > > > record you
> > > > > > > > > have saving. But if you're doing a find on a real table (Vendor,
> > > > > > > > > VendCnt, etc), then its your responsibility to find the correct
> > > > > > record,
> > > > > > > > > with the WHERE clause.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Trying read between lines of what you want and the bit of code
> > > > you
> > > > > > > > > posted, its possible you should be doing a find in the ttVendCnt
> > > > > > table
> > > > > > > > > instead of VendCnt. Depends on what method you're connecting
> > > > this BPM
> > > > > > > > > to.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Brian.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > On
> > > > > > Behalf
> > > > > > > > > Of tracy.tmat
> > > > > > > > > Sent: Wednesday, August 15, 2012 4:15 PM
> > > > > > > > > To: vantage@yahoogroups.com
> > > > > > > > > Subject: [Vantage] Re: BPM Firing but updatetablebuffer not
> > > > updating
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Thanks everyone... have moved the message and it still seems to
> > > > be
> > > > > > > > > firing correctly. Have tried removing no-lock and that didn't
> > > > make
> > > > > > any
> > > > > > > > > difference either.
> > > > > > > > >
> > > > > > > > > Vantage has a couple of fields on the Vendor table that should
> > > > show
> > > > > > > > > change date and user when you update a contact but they don't
> > > > work so
> > > > > > > > > this BPM is to update those fields. I have set it as
> > > > pre-processing
> > > > > > and
> > > > > > > > > have conditions that run when the ttVendCntMain has a new or
> > > > updated
> > > > > > > > > record... does this not mean it will pick up the record am saving
> > > > > > first?
> > > > > > > > > If not, then any suggestions?! Thanks.
> > > > > > > > >
> > > > > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > ,
> > > > > > > > > "Brian Roberts" <broberts@> wrote:
> > > > > > > > > >
> > > > > > > > > > Your WHERE clause is awfully short, you're updating the first
> > > > > > record
> > > > > > > > > in
> > > > > > > > > > that table, which probably isn't the one you want.
> > > > > > > > > >
> > > > > > > > > > Brian.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > From: vantage@yahoogroups.com <mailto:
> > > > vantage%40yahoogroups.com>
> > > > > > > > > [mailto:vantage@yahoogroups.com <mailto:
> > > > vantage%40yahoogroups.com>
> > > > > > ] On
> > > > > > > > > Behalf
> > > > > > > > > > Of tracy.tmat
> > > > > > > > > > Sent: Tuesday, August 14, 2012 11:04 AM
> > > > > > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > > > > > > Subject: [Vantage] BPM Firing but updatetablebuffer not
> > > > updating
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > I have the following code on a BPM - it's definitely firing at
> > > > the
> > > > > > > > > right
> > > > > > > > > > point as my message box is coming up but the table is not
> > > > getting
> > > > > > > > > > updated... any suggestions? We're on Vantage 8.03.409a. Thanks.
> > > > > > > > > >
> > > > > > > > > > /* Update Change Date & ID */
> > > > > > > > > >
> > > > > > > > > > {lib/PublishInfoMsg.i &InfoMsg = "'FIRE!!!!'"}.
> > > > > > > > > >
> > > > > > > > > > find first VendCnt where VendCnt.Company = CUR-COMP no-lock
> > > > > > no-error.
> > > > > > > > > >
> > > > > > > > > > if available VendCnt then
> > > > > > > > > > DO:
> > > > > > > > > > run lib\updatetablebuffer.p(input BUFFER
> > > > > > > > > > VendCnt:HANDLE,'ChangeDate',TODAY).
> > > > > > > > > > END.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>