BPM to reset fields - Need help

Jose,

This was exactly what I needed. Thank you very much. BPM is now working as expected.

Thanks,

Greg Rodzewicz
Developer


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 01, 2012 11:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM to reset fields - Need help

You need to use update table buffer in 8 XX

run lib\UpdateTableBuffer.p(input BUFFER Table:HANDLE, 'Field', 'Data') run lib\UpdateTableBuffer.p(input BUFFER Table:HANDLE, 'Field', Variable)


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Tue, May 1, 2012 at 11:05 AM, gregatnorgren
<grodzewicz@...>wrote:

> **
>
>
> I am having a problem with a BPM and I am new to 4GL and Vantage. The
> company I am doing work for is using 8.03.409C. They have a contract
> review procedure they do with sales orders. They have added a button
> on the summary tab of the sales order entry form that populates a
> shortchar and a date field in OrderHed. They would like any change
> made after that point to clear those values. I have a BPM on the
> SalesOrder.Update Pre-Process that triggers on updated OrderHed,
> OrderDtl, or OrderRel and added OrderDtl or OrderRel lines. This runs
> 4GL code where I check the temp tables to get an order num then I
> check the OrderHed table for the fields. If the fields exist I want to
> clear them. This works fine if the change was to OrderHed because I
> have an available ttOrderHed I can assign values to. If the change was
> on one of the other tables I do not have an available ttOrderHed. I
> tried assigning the values directly to OrderHed instead of ttOrderHed
> and got this "You may not compile programs that update the database in
> this version (490)". How can I make an update to the OrderHed when the BPM is triggered by one of the other tables changing?
>
>
>


[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 - This e-mail transmission and any accompanying documents contain information belonging to the sender which may be confidential and legally privileged. This information is intended only for the use of the person to whom this e-mail transmission was sent as indicated above. If you are not the intended recipient, any disclosure, copying, distribution, or action taken in reliance on the contents of the information contained in this transmission is strictly prohibited. Any commodities, technology or software exported in this e-mail are being exported from the United States in accordance with export administration regulations, diversion contrary to USA law is prohibited.
I am having a problem with a BPM and I am new to 4GL and Vantage. The company I am doing work for is using 8.03.409C. They have a contract review procedure they do with sales orders. They have added a button on the summary tab of the sales order entry form that populates a shortchar and a date field in OrderHed. They would like any change made after that point to clear those values. I have a BPM on the SalesOrder.Update Pre-Process that triggers on updated OrderHed, OrderDtl, or OrderRel and added OrderDtl or OrderRel lines. This runs 4GL code where I check the temp tables to get an order num then I check the OrderHed table for the fields. If the fields exist I want to clear them. This works fine if the change was to OrderHed because I have an available ttOrderHed I can assign values to. If the change was on one of the other tables I do not have an available ttOrderHed. I tried assigning the values directly to OrderHed instead of ttOrderHed and got this "You may not compile programs that update the database in this version (490)". How can I make an update to the OrderHed when the BPM is triggered by one of the other tables changing?
You need to use update table buffer in 8 XX

run lib\UpdateTableBuffer.p(input BUFFER Table:HANDLE, 'Field', 'Data')
run lib\UpdateTableBuffer.p(input BUFFER Table:HANDLE, 'Field', Variable)


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Tue, May 1, 2012 at 11:05 AM, gregatnorgren
<grodzewicz@...>wrote:

> **
>
>
> I am having a problem with a BPM and I am new to 4GL and Vantage. The
> company I am doing work for is using 8.03.409C. They have a contract review
> procedure they do with sales orders. They have added a button on the
> summary tab of the sales order entry form that populates a shortchar and a
> date field in OrderHed. They would like any change made after that point to
> clear those values. I have a BPM on the SalesOrder.Update Pre-Process that
> triggers on updated OrderHed, OrderDtl, or OrderRel and added OrderDtl or
> OrderRel lines. This runs 4GL code where I check the temp tables to get an
> order num then I check the OrderHed table for the fields. If the fields
> exist I want to clear them. This works fine if the change was to OrderHed
> because I have an available ttOrderHed I can assign values to. If the
> change was on one of the other tables I do not have an available
> ttOrderHed. I tried assigning the values directly to OrderHed instead of
> ttOrderHed and got this "You may not compile programs that update the
> database in this version (490)". How can I make an update to the OrderHed
> when the BPM is triggered by one of the other tables changing?
>
>
>


[Non-text portions of this message have been removed]
This is where a post process bpm is used.. you link your ttfields to non ttfields ex.

ttorderdtl.company = ordered.company and ttorderdtl.ordernum = orderhed.ordernum

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<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 gregatnorgren
Sent: Tuesday, May 01, 2012 10:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM to reset fields - Need help



I am having a problem with a BPM and I am new to 4GL and Vantage. The company I am doing work for is using 8.03.409C. They have a contract review procedure they do with sales orders. They have added a button on the summary tab of the sales order entry form that populates a shortchar and a date field in OrderHed. They would like any change made after that point to clear those values. I have a BPM on the SalesOrder.Update Pre-Process that triggers on updated OrderHed, OrderDtl, or OrderRel and added OrderDtl or OrderRel lines. This runs 4GL code where I check the temp tables to get an order num then I check the OrderHed table for the fields. If the fields exist I want to clear them. This works fine if the change was to OrderHed because I have an available ttOrderHed I can assign values to. If the change was on one of the other tables I do not have an available ttOrderHed. I tried assigning the values directly to OrderHed instead of ttOrderHed and got this "You may not compile programs that update the database in this version (490)". How can I make an update to the OrderHed when the BPM is triggered by one of the other tables changing?



[Non-text portions of this message have been removed]
Yup, I forgot to add that part too..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084

(Click the logo to view our site)


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 01, 2012 10:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM to reset fields - Need help

You need to use update table buffer in 8 XX

run lib\UpdateTableBuffer.p(input BUFFER Table:HANDLE, 'Field', 'Data') run lib\UpdateTableBuffer.p(input BUFFER Table:HANDLE, 'Field', Variable)


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Tue, May 1, 2012 at 11:05 AM, gregatnorgren
<grodzewicz@...>wrote:

> **
>
>
> I am having a problem with a BPM and I am new to 4GL and Vantage. The
> company I am doing work for is using 8.03.409C. They have a contract
> review procedure they do with sales orders. They have added a button
> on the summary tab of the sales order entry form that populates a
> shortchar and a date field in OrderHed. They would like any change
> made after that point to clear those values. I have a BPM on the
> SalesOrder.Update Pre-Process that triggers on updated OrderHed,
> OrderDtl, or OrderRel and added OrderDtl or OrderRel lines. This runs
> 4GL code where I check the temp tables to get an order num then I
> check the OrderHed table for the fields. If the fields exist I want to
> clear them. This works fine if the change was to OrderHed because I
> have an available ttOrderHed I can assign values to. If the change was
> on one of the other tables I do not have an available ttOrderHed. I
> tried assigning the values directly to OrderHed instead of ttOrderHed
> and got this "You may not compile programs that update the database in
> this version (490)". How can I make an update to the OrderHed when the BPM is triggered by one of the other tables changing?
>
>
>


[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