I believe that’s where you would be adding new records..
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
Sent: Thursday, March 28, 2013 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Capturing Data from one table to another
I recently ran into a related problem with a BPM on 8.03.409C...
Not allowing a certain type of db write.
I believe I read a tech tip stating it became available by request about version 8.03.407.
I contacted the Epicor CAM & they did send me a Progess license at no cost.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
Sent: Thursday, March 28, 2013 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Capturing Data from one table to another
>> a licensing restriction with open edgeFYI V8 users.
>> which did not allow you to write to the db
>> unless you owned a developer license.
I recently ran into a related problem with a BPM on 8.03.409C...
Not allowing a certain type of db write.
I believe I read a tech tip stating it became available by request about version 8.03.407.
I contacted the Epicor CAM & they did send me a Progess license at no cost.
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@...> wrote:
>
> Update table buffer was a procedure created to get around a licencing
> restriction with open edge which did not allow you to write to the db
> unless you owned a developer licence.
>
> Since 9 this restriction had either been removed or they included that
> licence in core epicor.
>
> One is not necessarily better than the other it's two ways to accomplish
> the same task.
>
> Internally update table buffer basically does an assign
> On Mar 27, 2013 6:24 PM, "Tom J. Christie" <tchristie@...>
> wrote:
>
> > **
> >
> >
> > My ABL is basically all cut and paste. I have no clue how it works! We had
> > customizations developed by a major consulting company and they used it. I
> > duplicated it and it worked. Assign seemed to only work in some occasions,
> > but table buffer always worked.
> >
> > I ask because finding someone that actually knows what they are doing in
> > ABL (rather than use copy-pasters!) is rare and it is always good to know
> > if there is a better way.
> >
> > Tom Christie | Information Technology Manager | AGM Container Controls,
> > Inc. | tchristie@...<mailto:tchristie@...> | t: 520.881.2130
> > ext 2176
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> > Of Joshua Giese
> > Sent: Wednesday, March 27, 2013 3:15 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] Re: Capturing Data from one table to another
> >
> >
> >
> > Recommendation from Epicor would work either way but since you don't have
> > to use table buffer why use it?
> >
> > Joshua Giese
> >
> > CTO
> >
> > 920.437.6400 Ext. 337
> >
> > Site ID: 27450-E905700B2-SQL64
> >
> > ----- Original Message -----
> >
> > From: "Tom J. Christie" <tchristie@...<mailto:
> > tchristie%40agmcontainer.com>>
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, March 27, 2013 5:12:36 PM
> > Subject: RE: [Vantage] Re: Capturing Data from one table to another
> >
> > Any particular reason why that would be so?
> >
> > Tom Christie | Information Technology Manager | AGM Container Controls,
> > Inc. | tchristie@...<mailto:tchristie%40agmcontainer.com>
> > <mailto: tchristie@...<mailto:tchristie%40agmcontainer.com>
> > > | t: 520.881.2130 ext 2176
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:
> > vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> ] On Behalf Of
> > jgiese1988
> > Sent: Wednesday, March 27, 2013 11:42 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Capturing Data from one table to another
> >
> > I wanted to make a quick note that "updatetablebuffer" should ONLY be used
> > for 8.03 customers; 9.04+ installs should use the "assign
> > jobhead.checkboxxx = true" instead. For what it's worth :)
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com>, "Tom J. Christie" <tchristie@> wrote:
> > >
> > > Try something like:
> > >
> > > For first jobhead where ttjoboper.jobnum = jobhead.jobnum and
> > ttjoboper.company = jobhead.company:
> > > RUN lib\UpdateTableBuffer.p(input BUFFER JobHead:HANDLE,
> > 'CheckboxXX',1).
> > > End.
> > >
> > > My ABL syntax may be wrong, but the basic idea is that you use a For
> > first loop to get hold of the appropriate Jobhead record, then you use the
> > updatetablebuffer to change that record.
> > >
> > > Easy peasy.
> > >
> > >
> > > Tom Christie | Information Technology Manager | AGM Container Controls,
> > Inc. | tchristie@<mailto:tchristie@> | t: 520.881.2130 ext 2176
> > >
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:
> > vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On Behalf
> > Of Joshua Giese
> > > Sent: Wednesday, March 27, 2013 7:42 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com>
> > > Subject: Re: [Vantage] RE: Capturing Data from one table to another
> > >
> > >
> > >
> > > Yup that's exactly what you would have to do. You would have to use the
> > ttJobOper keys that match the JobHead table and update it from there. Don't
> > have anything handy, but I got my examples for that from the user group
> > when I had to do something similar.
> > >
> > > Joshua Giese
> > >
> > > CTO
> > >
> > > 920.437.6400 Ext. 337
> > >
> > > Site ID: 27450-E905700B2-SQL64
> > >
> > > ----- Original Message -----
> > >
> > > From: "Ken Williams" <kwilliams@<mailto:
> > kwilliams%40intermountainelectronics.com>>
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > > Sent: Wednesday, March 27, 2013 9:38:59 AM
> > > Subject: [Vantage] RE: Capturing Data from one table to another
> > >
> > > I didn’t think that’d be possible because the JobHead table is not a
> > part of that data set. Unless you can open the table via Advanced BPM code?
> > Any chance someone has a snippet I could borrow?
> > >
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:
> > vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> ] On Behalf
> > Of Joshua Giese
> > > Sent: Wednesday, March 27, 2013 8:37 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > > Subject: Re: [Vantage] Capturing Data from one table to another
> > >
> > > Create a BPM on the JobOper update that sets JobHead.CheckboxXX =
> > JobOper.Complete ?
> > >
> > > Joshua Giese
> > >
> > > CTO
> > >
> > > 920.437.6400 Ext. 337
> > >
> > > Site ID: 27450-E905700B2-SQL64
> > >
> > > ----- Original Message -----
> > >
> > > From: "Ken Williams" < kwilliams@<mailto:
> > kwilliams%40intermountainelectronics.com> <mailto:
> > kwilliams%40intermountainelectronics.com>>
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com>
> > > Sent: Wednesday, March 27, 2013 9:32:32 AM
> > > Subject: [Vantage] Capturing Data from one table to another
> > >
> > > We've developed a mini project schedule for our jobs within Job Entry.
> > It lists our most common milestones before it hits the floor, as well as
> > our main operations on the floor.
> > >
> > > What I'd like to be able to do, is when someone marks an operation
> > complete in job entry, have the related JobHead.CheckBox checked. Since the
> > operation complete is done on a labor record, which in turn affects
> > JobOper, I'm not sure how to push a change back to the JobHead table.
> > >
> > > Any thoughts or suggestions?
> > > Ken
> > >
> > > [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]
> > >
> >
> > [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]