Need a Progress technical eye

Yahoo Archive
1
Thanks for clarifying that. I am in the process of gettign my license from my CAM and I wasn't sure what the license gave me control of doing.


Dan Godfrey
(805) 389-1935 x 251

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Tuesday, April 23, 2013 1:59 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Need a Progress technical eye

Yes. I just use ASSIGN. You can also create and delete records


________________________________
From: dgodfrey_amc <dgodfrey@...>
To: vantage@yahoogroups.com
Sent: Tuesday, April 23, 2013 3:37 PM
Subject: [Vantage] Re: Need a Progress technical eye


Sorry about replying to this late. I was not understanding the need to get a license for the updateTableBuffer function. After I get the license, will still use the UpdateTableBuffer function or something else.

Steven, you mentioned that after receiving the license that you did not use UpdateTableBuffer. So what did you do after? Did you just use ASSIGN to update the table?




[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



CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.
2
I have some code in a BPM that is erroring out when executed. The error message only shows 7175. This code is in a Pre-Process for Part.Update.


Here is the error details:

Error Detail
============
7175


Stack Trace
===========
at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()




Here is the ABL code:

/* Set Sales Order Quality Hold */
/* Created by Dan Godfrey */
/* 4/11/2013 */
FOR EACH ttPart WHERE ttPart.RowMod = 'U' NO-LOCK.
FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )exclusive-lock.
/**/
IF(ttPart.CheckBox05 = True) Then DO:
RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
END.
IF(ttPart.CheckBox05 = False) Then DO:
RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
End.

/*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
END.
END.
3
Dan,

I believe your problem is that you finding the OrderDtl record using the exclusive-lock option. This locks the record from being updated by someone else. So when the update table buffer runs the record is not available to be updated.

So you have 2 options. Find the record using no-lock or use an assign statement in the then do block. Assign OrderDtl.CheckBox02 = True.

Tom

--- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey@...> wrote:
>
> I have some code in a BPM that is erroring out when executed. The error message only shows 7175. This code is in a Pre-Process for Part.Update.
>
>
> Here is the error details:
>
> Error Detail
> ============
> 7175
>
>
> Stack Trace
> ===========
> at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
> at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
> at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
> at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
> at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
>
>
>
>
> Here is the ABL code:
>
> /* Set Sales Order Quality Hold */
> /* Created by Dan Godfrey */
> /* 4/11/2013 */
> FOR EACH ttPart WHERE ttPart.RowMod = 'U' NO-LOCK.
> FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )exclusive-lock.
> /**/
> IF(ttPart.CheckBox05 = True) Then DO:
> RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
> END.
> IF(ttPart.CheckBox05 = False) Then DO:
> RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
> End.
>
> /*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
> END.
> END.
>
4
So just to clarify. The BPM is on Part.Update Method, trying to update OrderDtl. You're saying that I can use the assign function for the non-temp table of OrderDtl?


Dan Godfrey
(805) 389-1935 x 251

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of netrippers
Sent: Saturday, April 13, 2013 11:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need a Progress technical eye

Dan,

I believe your problem is that you finding the OrderDtl record using the exclusive-lock option. This locks the record from being updated by someone else. So when the update table buffer runs the record is not available to be updated.

So you have 2 options. Find the record using no-lock or use an assign statement in the then do block. Assign OrderDtl.CheckBox02 = True.

Tom

--- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey@...> wrote:
>
> I have some code in a BPM that is erroring out when executed. The error message only shows 7175. This code is in a Pre-Process for Part.Update.
>
>
> Here is the error details:
>
> Error Detail
> ============
> 7175
>
>
> Stack Trace
> ===========
> at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
> at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
> at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
> at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
> at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
>
>
>
>
> Here is the ABL code:
>
> /* Set Sales Order Quality Hold */
> /* Created by Dan Godfrey */
> /* 4/11/2013 */
> FOR EACH ttPart WHERE ttPart.RowMod = 'U' NO-LOCK.
> FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )exclusive-lock.
> /**/
> IF(ttPart.CheckBox05 = True) Then DO:
> RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
> END.
> IF(ttPart.CheckBox05 = False) Then DO:
> RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
> End.
>
> /*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
> END.
> END.
>



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

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



CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.
5
Yes, They added that ability somewhere a long the line. I am on 9.05.701

--- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> So just to clarify. The BPM is on Part.Update Method, trying to update OrderDtl. You're saying that I can use the assign function for the non-temp table of OrderDtl?
>
>
> Dan Godfrey
> (805) 389-1935 x 251
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of netrippers
> Sent: Saturday, April 13, 2013 11:45 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Need a Progress technical eye
>
> Dan,
>
> I believe your problem is that you finding the OrderDtl record using the exclusive-lock option. This locks the record from being updated by someone else. So when the update table buffer runs the record is not available to be updated.
>
> So you have 2 options. Find the record using no-lock or use an assign statement in the then do block. Assign OrderDtl.CheckBox02 = True.
>
> Tom
>
> --- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey@> wrote:
> >
> > I have some code in a BPM that is erroring out when executed. The error message only shows 7175. This code is in a Pre-Process for Part.Update.
> >
> >
> > Here is the error details:
> >
> > Error Detail
> > ============
> > 7175
> >
> >
> > Stack Trace
> > ===========
> > at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
> > at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
> > at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
> > at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
> > at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> > at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
> >
> >
> >
> >
> > Here is the ABL code:
> >
> > /* Set Sales Order Quality Hold */
> > /* Created by Dan Godfrey */
> > /* 4/11/2013 */
> > FOR EACH ttPart WHERE ttPart.RowMod = 'U' NO-LOCK.
> > FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )exclusive-lock.
> > /**/
> > IF(ttPart.CheckBox05 = True) Then DO:
> > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
> > END.
> > IF(ttPart.CheckBox05 = False) Then DO:
> > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
> > End.
> >
> > /*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
> > END.
> > END.
> >
>
>
>
> ------------------------------------
>
> 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
>
>
>
> CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.
>
6
Do you know if that is the case for Vantage 8x? Sorry I forgot to mention my version.


Dan Godfrey
(805) 389-1935 x 251

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of netrippers
Sent: Monday, April 15, 2013 10:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need a Progress technical eye

Yes, They added that ability somewhere a long the line. I am on 9.05.701

--- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> So just to clarify. The BPM is on Part.Update Method, trying to update OrderDtl. You're saying that I can use the assign function for the non-temp table of OrderDtl?
>
>
> Dan Godfrey
> (805) 389-1935 x 251
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of netrippers
> Sent: Saturday, April 13, 2013 11:45 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Need a Progress technical eye
>
> Dan,
>
> I believe your problem is that you finding the OrderDtl record using the exclusive-lock option. This locks the record from being updated by someone else. So when the update table buffer runs the record is not available to be updated.
>
> So you have 2 options. Find the record using no-lock or use an assign statement in the then do block. Assign OrderDtl.CheckBox02 = True.
>
> Tom
>
> --- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey@> wrote:
> >
> > I have some code in a BPM that is erroring out when executed. The error message only shows 7175. This code is in a Pre-Process for Part.Update.
> >
> >
> > Here is the error details:
> >
> > Error Detail
> > ============
> > 7175
> >
> >
> > Stack Trace
> > ===========
> > at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
> > at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
> > at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
> > at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
> > at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> > at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
> >
> >
> >
> >
> > Here is the ABL code:
> >
> > /* Set Sales Order Quality Hold */
> > /* Created by Dan Godfrey */
> > /* 4/11/2013 */
> > FOR EACH ttPart WHERE ttPart.RowMod = 'U' NO-LOCK.
> > FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )exclusive-lock.
> > /**/
> > IF(ttPart.CheckBox05 = True) Then DO:
> > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
> > END.
> > IF(ttPart.CheckBox05 = False) Then DO:
> > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
> > End.
> >
> > /*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
> > END.
> > END.
> >
>
>
>
> ------------------------------------
>
> 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
>
>
>
> CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.
>




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

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
7
Dan,

V8 will you will still need to use the update table buffer process. I think it was in 9 where they made the change.

Tom

--- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> Do you know if that is the case for Vantage 8x? Sorry I forgot to mention my version.
>
>
> Dan Godfrey
> (805) 389-1935 x 251
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of netrippers
> Sent: Monday, April 15, 2013 10:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Need a Progress technical eye
>
> Yes, They added that ability somewhere a long the line. I am on 9.05.701
>
> --- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@> wrote:
> >
> > So just to clarify. The BPM is on Part.Update Method, trying to update OrderDtl. You're saying that I can use the assign function for the non-temp table of OrderDtl?
> >
> >
> > Dan Godfrey
> > (805) 389-1935 x 251
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of netrippers
> > Sent: Saturday, April 13, 2013 11:45 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Need a Progress technical eye
> >
> > Dan,
> >
> > I believe your problem is that you finding the OrderDtl record using the exclusive-lock option. This locks the record from being updated by someone else. So when the update table buffer runs the record is not available to be updated.
> >
> > So you have 2 options. Find the record using no-lock or use an assign statement in the then do block. Assign OrderDtl.CheckBox02 = True.
> >
> > Tom
> >
> > --- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey@> wrote:
> > >
> > > I have some code in a BPM that is erroring out when executed. The error message only shows 7175. This code is in a Pre-Process for Part.Update.
> > >
> > >
> > > Here is the error details:
> > >
> > > Error Detail
> > > ============
> > > 7175
> > >
> > >
> > > Stack Trace
> > > ===========
> > > at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
> > > at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
> > > at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
> > > at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
> > > at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> > > at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> > > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> > > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
> > >
> > >
> > >
> > >
> > > Here is the ABL code:
> > >
> > > /* Set Sales Order Quality Hold */
> > > /* Created by Dan Godfrey */
> > > /* 4/11/2013 */
> > > FOR EACH ttPart WHERE ttPart.RowMod = 'U' NO-LOCK.
> > > FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )exclusive-lock.
> > > /**/
> > > IF(ttPart.CheckBox05 = True) Then DO:
> > > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
> > > END.
> > > IF(ttPart.CheckBox05 = False) Then DO:
> > > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
> > > End.
> > >
> > > /*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
> > > END.
> > > END.
> > >
> >
> >
> >
> > ------------------------------------
> >
> > 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
> >
> >
> >
> > CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.
> >
>
>
>
>
> ------------------------------------
>
> 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
>
8
For 8.03 you can request new license codes from your VAR that includes the OpenEdge license which allows you to update records. We are on 8.03.408a and got the new codes (its free) and I have never used UpdateTableBuffer.p since. Remember, if you plan to use assign on a non temp table, DO NOT use NO-LOCK. I also add a "Release TableName NO-ERROR." at the end of my code just to make sure the record lock is released.
Â
Steven G.


________________________________
From: netrippers <osen.tom@...>
To: vantage@yahoogroups.com
Sent: Monday, April 15, 2013 3:19 PM
Subject: [Vantage] Re: Need a Progress technical eye

Â
Dan,

V8 will you will still need to use the update table buffer process. I think it was in 9 where they made the change.

Tom

--- In mailto:vantage%40yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> Do you know if that is the case for Vantage 8x? Sorry I forgot to mention my version.
>
>
> Dan Godfrey
> (805) 389-1935 x 251
>
> -----Original Message-----
> From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of netrippers
> Sent: Monday, April 15, 2013 10:49 AM
> To: mailto:vantage%40yahoogroups.com
> Subject: [Vantage] Re: Need a Progress technical eye
>
> Yes, They added that ability somewhere a long the line. I am on 9.05.701
>
> --- In mailto:vantage%40yahoogroups.com, Dan Godfrey <dgodfrey@> wrote:
> >
> > So just to clarify. The BPM is on Part.Update Method, trying to update OrderDtl. You're saying that I can use the assign function for the non-temp table of OrderDtl?
> >
> >
> > Dan Godfrey
> > (805) 389-1935 x 251
> >
> > -----Original Message-----
> > From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On
> > Behalf Of netrippers
> > Sent: Saturday, April 13, 2013 11:45 AM
> > To: mailto:vantage%40yahoogroups.com
> > Subject: [Vantage] Re: Need a Progress technical eye
> >
> > Dan,
> >
> > I believe your problem is that you finding the OrderDtl record using the exclusive-lock option. This locks the record from being updated by someone else. So when the update table buffer runs the record is not available to be updated.
> >
> > So you have 2 options. Find the record using no-lock or use an assign statement in the then do block. Assign OrderDtl.CheckBox02 = True.
> >
> > Tom
> >
> > --- In mailto:vantage%40yahoogroups.com, "dgodfrey_amc" <dgodfrey@> wrote:
> > >
> > > I have some code in a BPM that is erroring out when executed. The error message only shows 7175. This code is in a Pre-Process for Part.Update.
> > >
> > >
> > > Here is the error details:
> > >
> > > Error Detail
> > > ============
> > > 7175
> > >
> > >
> > > Stack Trace
> > > ===========
> > > at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
> > > at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
> > > at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
> > > at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
> > > at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
> > > at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
> > > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
> > > at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
> > >
> > >
> > >
> > >
> > > Here is the ABL code:
> > >
> > > /* Set Sales Order Quality Hold */
> > > /* Created by Dan Godfrey */
> > > /* 4/11/2013 */
> > > FOR EACH ttPart WHERE ttPart.RowMod = 'U' NO-LOCK.
> > > FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )exclusive-lock.
> > > /**/
> > > IF(ttPart.CheckBox05 = True) Then DO:
> > > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
> > > END.
> > > IF(ttPart.CheckBox05 = False) Then DO:
> > > RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
> > > End.
> > >
> > > /*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
> > > END.
> > > END.
> > >
> >
> >
> >
> > ------------------------------------
> >
> > 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
> >
> >
> >
> > CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance.
> >
>
>
>
>
> ------------------------------------
>
> 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]
9
This is actually in tandum with the Vantage 8x: SalesOrder Adapter Update function post. Since I could not figure out what I was doing wrong in the customization I thought I should attempt a BPM. Which is possibly where it should be anyways. BUT, I am also hitting a wall here. I am not as familiar with progress as much as VB, so I am presuming that is my problem here.


the error I get when I trigger this BPM is this:
Error Detail
============
7175


Stack Trace
===========
at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
at Epicor.Mfg.Proxy.PartImpl.Update(PartDataSet ds)
at Epicor.Mfg.UI.Adapters.PartAdapter.Update()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.AdapterUpdate()
at Epicor.Mfg.UI.App.PartEntry.PartTransaction.UpdateX()
Here is my 4gl code inside the Pre-processor on the Part Update method.

/* Set Sales Order Quality Hold */
/* Created by Dan Godfrey */
/* 4/11/2013 */
{lib/PublishInfoMsg.i &InfoMsg = "'Beginning of Part Update Pre-Processor First for loop'"}.
FOR EACH ttPart WHERE (ttPart.RowMod = 'U') NO-LOCK.
FOR EACH OrderDtl WHERE (ttPart.Company = OrderDtl.Company AND ttPart.PartNum = OrderDtl.PartNum AND OrderDtl.OpenLine = True )no-lock.
{lib/PublishInfoMsg.i &InfoMsg = "'Inside Part Update Pre-Processor second for loop'"}.
/* {lib/PublishInfoMsg.i &InfoMsg = "' Part Update Pre-Processor CheckBox05 = ' + STRING(ttPart.CheckBox05)"}. */
IF(ttPart.CheckBox05 = True) Then DO:
RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',True).
END.
IF(ttPart.CheckBox05 = False) Then DO:
RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',False).
End.

/*RUN LIB\UpdateTableBuffer.p(input buffer OrderDtl:HANDLE,'CheckBox02',ttPart.CheckBox05). */
END.
END.

Release OrderDtl NO-ERROR.
10
Sorry about replying to this late. I was not understanding the need to get a license for the updateTableBuffer function. After I get the license, will still use the UpdateTableBuffer function or something else.

Steven, you mentioned that after receiving the license that you did not use UpdateTableBuffer. So what did you do after? Did you just use ASSIGN to update the table?
11
Yes. I just use ASSIGN. You can also create and delete records


________________________________
From: dgodfrey_amc <dgodfrey@...>
To: vantage@yahoogroups.com
Sent: Tuesday, April 23, 2013 3:37 PM
Subject: [Vantage] Re: Need a Progress technical eye

Â
Sorry about replying to this late. I was not understanding the need to get a license for the updateTableBuffer function. After I get the license, will still use the UpdateTableBuffer function or something else.

Steven, you mentioned that after receiving the license that you did not use UpdateTableBuffer. So what did you do after? Did you just use ASSIGN to update the table?




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