BPM to add op Blank Title 93026

Yahoo Archive
1
ok everybody, thank you for your input. I have never used service connect. I will let the party in question know what you have said and see if they want to get Epicor involved.

Thanks again,

Michael



--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> Ooh, it's nice to be right for a change. :-)
>
> I've seen some examples of folks calling the BOs in 4GL code and I
> have absolutely no idea how they know what the BO method signatures are,
> etc.
>
> I can write functional .NET code with a book and Visual Studio's
> IntelliSense (don't know how folks live without it), but I've never seen
> any documentation or tool that gives you visibility into the Progress
> side of things. How do folks do this without being psychic?
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Rob Bucek
> Sent: Thursday, August 26, 2010 1:12 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BPM to add op
>
> Brian is right on this one. However there is a way with your current
> licensing to create a new record (in your case an opdtl record) and use
> the business logic by calling the bo/method with 4gl code from a BPM.
> But the steps you'd have to go through and the number of BO calls you'd
> make to do what you want would be incredibly hairy. You'd do well to
> be your own consultant at that point if you can scratch the code
> together for that. Is service connect not an option?
>
2
Hello,

I am wanting to add op '1611' to all Parts that begin with A. Using the part update method, i have created a pre-processing directive to execute 4gl code. So far this consists of:

for each Part where ( Part.PartNum BEGINS 'A') no-lock , each PartOpr where (Part.Company = PartOpr.Company and Part.PartNum = PartOpr.PartNum) no-lock , each PartOpDtl where (PartOpr.Company = PartOpDtl.Company and PartOpr.PartNum = PartOpDtl.PartNum and PartOpr.RevisionNum = PartOpDtl.RevisionNum and PartOpr.AltMethod = PartOpDtl.AltMethod and PartOpr.OprSeq = PartOpDtl.OprSeq) no-lock .

Does anybody know the correct syntax to add a record? I have been using the 'Run lib\UpdateTableBuffer.p(input BUFFER.....' statements to update existing records - this works ok for updates but not for adding new records.

Any help would be greatly appreciated and I have lots of code samples I am happy to exchange.

Regards,

Michael
3
You'd have to do a checkout of the PartRev and a bunch of other fancy
stuff to add an operation to the Method of Manufacture.

In terms of Progress, you can't add a record with the standard
OpenEdge runtime license that was provided with 8.03.40x. Recently
Epicor renegotiated their license with Progress, and you can get an
updated license code that will let you do this. Talk to your Sales Rep.
You'll probably need wisdom here from folks on how to actually install
it. This enables you to issue CREATE statements, but you're completely
bypassing the business logic and you could hose your system and support
will wash their hands of you.

Maybe someone knows how to manipulate the EngineeringWorkbench BO from
4GL? I have a workflow that I purchased from Epicor that enables me to
import BOMs and BOOs that uses Service Connect. It does a fair amount
of work related to revision checkout, etc. I can't share it though
since it was a paid-for thing.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Thursday, August 26, 2010 11:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM to add op

Hello,

I am wanting to add op '1611' to all Parts that begin with A. Using the
part update method, i have created a pre-processing directive to execute
4gl code. So far this consists of:

for each Part where ( Part.PartNum BEGINS 'A') no-lock , each PartOpr
where (Part.Company = PartOpr.Company and Part.PartNum =
PartOpr.PartNum) no-lock , each PartOpDtl where (PartOpr.Company =
PartOpDtl.Company and PartOpr.PartNum = PartOpDtl.PartNum and
PartOpr.RevisionNum = PartOpDtl.RevisionNum and PartOpr.AltMethod =
PartOpDtl.AltMethod and PartOpr.OprSeq = PartOpDtl.OprSeq) no-lock .

Does anybody know the correct syntax to add a record? I have been using
the 'Run lib\UpdateTableBuffer.p(input BUFFER.....' statements to update
existing records - this works ok for updates but not for adding new
records.

Any help would be greatly appreciated and I have lots of code samples I
am happy to exchange.

Regards,

Michael



------------------------------------

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
4
Brian is right on this one. However there is a way with your current
licensing to create a new record (in your case an opdtl record) and use
the business logic by calling the bo/method with 4gl code from a BPM.
But the steps you'd have to go through and the number of BO calls you'd
make to do what you want would be incredibly hairy. You'd do well to
be your own consultant at that point if you can scratch the code
together for that. Is service connect not an option?



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, August 26, 2010 10:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM to add op





You'd have to do a checkout of the PartRev and a bunch of other fancy
stuff to add an operation to the Method of Manufacture.

In terms of Progress, you can't add a record with the standard
OpenEdge runtime license that was provided with 8.03.40x. Recently
Epicor renegotiated their license with Progress, and you can get an
updated license code that will let you do this. Talk to your Sales Rep.
You'll probably need wisdom here from folks on how to actually install
it. This enables you to issue CREATE statements, but you're completely
bypassing the business logic and you could hose your system and support
will wash their hands of you.

Maybe someone knows how to manipulate the EngineeringWorkbench BO from
4GL? I have a workflow that I purchased from Epicor that enables me to
import BOMs and BOOs that uses Service Connect. It does a fair amount
of work related to revision checkout, etc. I can't share it though
since it was a paid-for thing.

-bws

-----Original Message-----
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, August 26, 2010 11:28 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BPM to add op

Hello,

I am wanting to add op '1611' to all Parts that begin with A. Using the
part update method, i have created a pre-processing directive to execute
4gl code. So far this consists of:

for each Part where ( Part.PartNum BEGINS 'A') no-lock , each PartOpr
where (Part.Company = PartOpr.Company and Part.PartNum =
PartOpr.PartNum) no-lock , each PartOpDtl where (PartOpr.Company =
PartOpDtl.Company and PartOpr.PartNum = PartOpDtl.PartNum and
PartOpr.RevisionNum = PartOpDtl.RevisionNum and PartOpr.AltMethod =
PartOpDtl.AltMethod and PartOpr.OprSeq = PartOpDtl.OprSeq) no-lock .

Does anybody know the correct syntax to add a record? I have been using
the 'Run lib\UpdateTableBuffer.p(input BUFFER.....' statements to update
existing records - this works ok for updates but not for adding new
records.

Any help would be greatly appreciated and I have lots of code samples I
am happy to exchange.

Regards,

Michael

------------------------------------

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/.
<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]
5
Ooh, it's nice to be right for a change. :-)

I've seen some examples of folks calling the BOs in 4GL code and I
have absolutely no idea how they know what the BO method signatures are,
etc.

I can write functional .NET code with a book and Visual Studio's
IntelliSense (don't know how folks live without it), but I've never seen
any documentation or tool that gives you visibility into the Progress
side of things. How do folks do this without being psychic?

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, August 26, 2010 1:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM to add op

Brian is right on this one. However there is a way with your current
licensing to create a new record (in your case an opdtl record) and use
the business logic by calling the bo/method with 4gl code from a BPM.
But the steps you'd have to go through and the number of BO calls you'd
make to do what you want would be incredibly hairy. You'd do well to
be your own consultant at that point if you can scratch the code
together for that. Is service connect not an option?