Update table via BPM

system · February 26, 2011, 9:33pm

I believe the developerâ€™s license built in on Epicor started with 9.04, but Iâ€™m not sure. Iâ€™m on whatever versions of Progress for that version of Epicor. I support clients on 9.04.507, 9.05.600, 602 and now 603. I believe you can include 4GL on all these without the developerâ€™s license.

Kevin Simon

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Carl Peterson
Sent: Saturday, February 26, 2011 9:24 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Update table via BPM

Are you on version 9 - what version of Progress?

Thanks,

Csrl

Sent from my iPhone
1-734-812-9532 - cell#

On Feb 26, 2011, at 9:04 PM, "Kevin Simon" <ksimon@... <mailto:ksimon%40simstrak.com> > wrote:

> Carl,
>
> The code I wrote is in a BPM. Depending upon the version of Epicor you're
> on, the 4GL developer's license now comes with the BPM tool. Also, I've
> never had to disable triggers as you mentioned below, and I do these types
> of BPM updates all the time.
>
> KEvin
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of
> Carl Peterson
> Sent: Friday, February 25, 2011 5:35 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Update table via BPM
>
> You would need a Progress 4GL Developer's license to update a table like you
> have below and you would have to disable the triggers, too.
>
> Disable triggers for load of orderrel.
> Disable triggers for dump of orderrel.
>
> The BPM concept would be less expensive and just as easy.
>
> Carl Peterson
>
> 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
> Kevin Simon
> Sent: Thursday, February 24, 2011 7:55 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Update table via BPM
>
> Michael,
>
> The following works also, and is a lot easier to write:
>
> for each OrderRel no-lock:
>
> ASSIGN OrderRel.Character01 = OrderRel.ShortChar01.
>
> End.
>
> Kevin Simon
>
> 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
> michael.hutcheson@... <mailto:michael.hutcheson%40rocketmail.com> <mailto:michael.hutcheson%40rocketmail.com>
> <mailto:michael.hutcheson%40rocketmail.com>
>
> Sent: Thursday, February 24, 2011 4:38 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Update table via BPM
>
> Its ok folks I missed the closing bracket!!!
>
> All working.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@..." <michael.hutcheson@...> wrote:
> >
> > Hey folks,
> >
> > I want to update the order rel Char01 with the data from ShortChar01 so am
> using the following 4GL code and linking it to a BPM action:
> >
> > for each OrderRel no-lock:
> > Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01',
> OrderRel.ShortChar01.
> > End.
> >
> >
> > However, when I click on validate I receive:
> >
> > Error Detail
> > ============
> > ** Unable to understand after -- "Run". (247)
> > ** Invalid statement. (254)
> > ** Could not understand line 22. (198)
> >
> > I have done loads of these updates before in the past so why is it not
> working now?
> >
> > Regards,
> >
> > Michael
> >
> >
> > Vantage 8.03.406
> >
>
> [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]

system · February 24, 2011, 4:34am

Hey folks,

I want to update the order rel Char01 with the data from ShortChar01 so am using the following 4GL code and linking it to a BPM action:

for each OrderRel no-lock:
Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01', OrderRel.ShortChar01.
End.

However, when I click on validate I receive:

Error Detail
============
** Unable to understand after -- "Run". (247)
** Invalid statement. (254)
** Could not understand line 22. (198)

I have done loads of these updates before in the past so why is it not working now?

Regards,

Michael

Vantage 8.03.406

system · February 24, 2011, 4:38am

Its ok folks I missed the closing bracket!!!

All working.

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hey folks,
>
> I want to update the order rel Char01 with the data from ShortChar01 so am using the following 4GL code and linking it to a BPM action:
>
> for each OrderRel no-lock:
> Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01', OrderRel.ShortChar01.
> End.
>
>
> However, when I click on validate I receive:
>
> Error Detail
> ============
> ** Unable to understand after -- "Run". (247)
> ** Invalid statement. (254)
> ** Could not understand line 22. (198)
>
> I have done loads of these updates before in the past so why is it not working now?
>
> Regards,
>
> Michael
>
>
> Vantage 8.03.406
>

system · February 24, 2011, 7:55am

Michael,

The following works also, and is a lot easier to write:

for each OrderRel no-lock:

ASSIGN OrderRel.Character01 = OrderRel.ShortChar01.

End.

Kevin Simon

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
michael.hutcheson@...
Sent: Thursday, February 24, 2011 4:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Update table via BPM

Its ok folks I missed the closing bracket!!!

All working.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@..." <michael.hutcheson@...> wrote:

>
> Hey folks,
>
> I want to update the order rel Char01 with the data from ShortChar01 so am

using the following 4GL code and linking it to a BPM action:

>
> for each OrderRel no-lock:
> Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01',

OrderRel.ShortChar01.

> End.
>
>
> However, when I click on validate I receive:
>
> Error Detail
> ============
> ** Unable to understand after -- "Run". (247)
> ** Invalid statement. (254)
> ** Could not understand line 22. (198)
>
> I have done loads of these updates before in the past so why is it not

working now?

>
> Regards,
>
> Michael
>
>
> Vantage 8.03.406
>

[Non-text portions of this message have been removed]

system · February 24, 2011, 9:41am

Ah, cheers Kevin, I should give it a try...

Thanks,

Michael

--- In vantage@yahoogroups.com, "Kevin Simon" <ksimon@...> wrote:
>
> Michael,
>
>
>
> The following works also, and is a lot easier to write:
>
> for each OrderRel no-lock:
>
> ASSIGN OrderRel.Character01 = OrderRel.ShortChar01.
>
> End.
>
>
>
> Kevin Simon
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> michael.hutcheson@...
> Sent: Thursday, February 24, 2011 4:38 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Update table via BPM
>
>
>
>
>
> Its ok folks I missed the closing bracket!!!
>
> All working.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hey folks,
> >
> > I want to update the order rel Char01 with the data from ShortChar01 so am
> using the following 4GL code and linking it to a BPM action:
> >
> > for each OrderRel no-lock:
> > Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01',
> OrderRel.ShortChar01.
> > End.
> >
> >
> > However, when I click on validate I receive:
> >
> > Error Detail
> > ============
> > ** Unable to understand after -- "Run". (247)
> > ** Invalid statement. (254)
> > ** Could not understand line 22. (198)
> >
> > I have done loads of these updates before in the past so why is it not
> working now?
> >
> > Regards,
> >
> > Michael
> >
> >
> > Vantage 8.03.406
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 25, 2011, 5:36pm

You would need a Progress 4GL Developer's license to update a table like you
have below and you would have to disable the triggers, too.

Disable triggers for load of orderrel.
Disable triggers for dump of orderrel.

The BPM concept would be less expensive and just as easy.

Carl Peterson

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kevin Simon
Sent: Thursday, February 24, 2011 7:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Update table via BPM

Michael,

The following works also, and is a lot easier to write:

for each OrderRel no-lock:

ASSIGN OrderRel.Character01 = OrderRel.ShortChar01.

End.

Kevin Simon

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
michael.hutcheson@... <mailto:michael.hutcheson%40rocketmail.com>

Sent: Thursday, February 24, 2011 4:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Update table via BPM

Its ok folks I missed the closing bracket!!!

All working.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@..." <michael.hutcheson@...> wrote:

>
> Hey folks,
>
> I want to update the order rel Char01 with the data from ShortChar01 so am

using the following 4GL code and linking it to a BPM action:

>
> for each OrderRel no-lock:
> Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01',

OrderRel.ShortChar01.

> End.
>
>
> However, when I click on validate I receive:
>
> Error Detail
> ============
> ** Unable to understand after -- "Run". (247)
> ** Invalid statement. (254)
> ** Could not understand line 22. (198)
>
> I have done loads of these updates before in the past so why is it not

working now?

>
> Regards,
>
> Michael
>
>
> Vantage 8.03.406
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · February 26, 2011, 9:04pm

Carl,

The code I wrote is in a BPM. Depending upon the version of Epicor you're
on, the 4GL developer's license now comes with the BPM tool. Also, I've
never had to disable triggers as you mentioned below, and I do these types
of BPM updates all the time.

KEvin

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Carl Peterson
Sent: Friday, February 25, 2011 5:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Update table via BPM

You would need a Progress 4GL Developer's license to update a table like you
have below and you would have to disable the triggers, too.

Disable triggers for load of orderrel.
Disable triggers for dump of orderrel.

The BPM concept would be less expensive and just as easy.

Carl Peterson

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Kevin Simon
Sent: Thursday, February 24, 2011 7:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Update table via BPM

Michael,

The following works also, and is a lot easier to write:

for each OrderRel no-lock:

ASSIGN OrderRel.Character01 = OrderRel.ShortChar01.

End.

Kevin Simon

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
michael.hutcheson@... <mailto:michael.hutcheson%40rocketmail.com>
<mailto:michael.hutcheson%40rocketmail.com>

Sent: Thursday, February 24, 2011 4:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Update table via BPM

Its ok folks I missed the closing bracket!!!

All working.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@..." <michael.hutcheson@...> wrote:

>
> Hey folks,
>
> I want to update the order rel Char01 with the data from ShortChar01 so am

using the following 4GL code and linking it to a BPM action:

>
> for each OrderRel no-lock:
> Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01',

OrderRel.ShortChar01.

> End.
>
>
> However, when I click on validate I receive:
>
> Error Detail
> ============
> ** Unable to understand after -- "Run". (247)
> ** Invalid statement. (254)
> ** Could not understand line 22. (198)
>
> I have done loads of these updates before in the past so why is it not

working now?

>
> Regards,
>
> Michael
>
>
> Vantage 8.03.406
>

[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]

system · February 26, 2011, 9:23pm

Are you on version 9 - what version of Progress?

Thanks,

Csrl

Sent from my iPhone
1-734-812-9532 - cell#

On Feb 26, 2011, at 9:04 PM, "Kevin Simon" <ksimon@...> wrote:

> Carl,
>
> The code I wrote is in a BPM. Depending upon the version of Epicor you're
> on, the 4GL developer's license now comes with the BPM tool. Also, I've
> never had to disable triggers as you mentioned below, and I do these types
> of BPM updates all the time.
>
> KEvin
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Carl Peterson
> Sent: Friday, February 25, 2011 5:35 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Update table via BPM
>
> You would need a Progress 4GL Developer's license to update a table like you
> have below and you would have to disable the triggers, too.
>
> Disable triggers for load of orderrel.
> Disable triggers for dump of orderrel.
>
> The BPM concept would be less expensive and just as easy.
>
> Carl Peterson
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Kevin Simon
> Sent: Thursday, February 24, 2011 7:55 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Update table via BPM
>
> Michael,
>
> The following works also, and is a lot easier to write:
>
> for each OrderRel no-lock:
>
> ASSIGN OrderRel.Character01 = OrderRel.ShortChar01.
>
> End.
>
> Kevin Simon
>
> 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
> michael.hutcheson@... <mailto:michael.hutcheson%40rocketmail.com>
> <mailto:michael.hutcheson%40rocketmail.com>
>
> Sent: Thursday, February 24, 2011 4:38 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Update table via BPM
>
> Its ok folks I missed the closing bracket!!!
>
> All working.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@..." <michael.hutcheson@...> wrote:
> >
> > Hey folks,
> >
> > I want to update the order rel Char01 with the data from ShortChar01 so am
> using the following 4GL code and linking it to a BPM action:
> >
> > for each OrderRel no-lock:
> > Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'Character01',
> OrderRel.ShortChar01.
> > End.
> >
> >
> > However, when I click on validate I receive:
> >
> > Error Detail
> > ============
> > ** Unable to understand after -- "Run". (247)
> > ** Invalid statement. (254)
> > ** Could not understand line 22. (198)
> >
> > I have done loads of these updates before in the past so why is it not
> working now?
> >
> > Regards,
> >
> > Michael
> >
> >
> > Vantage 8.03.406
> >
>
> [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]

Topic		Replies	Views
Need a Progress technical eye Yahoo Archive	10	418	April 23, 2013
Delete BPM Blank Title 111140 Yahoo Archive	17	932	June 14, 2012
BPM to reset fields - Need help Yahoo Archive	4	1274	May 1, 2012
Getting order information in BPM 4GL Yahoo Archive	4	370	October 20, 2009
4GL query from JobHead BPM Yahoo Archive	13	794	November 18, 2011

Update table via BPM

Related Topics