Mass update to a check box field in Customer Table

Yahoo Archive
1
Thanks for the help. I am now pointed in the right direction.I got to BAM..I
coded my .p file to perform the necessary action and I have my newly

Created program in the alert program but I keep getting the following
exception error



Exception caught in: Epicor.Mfg.BO.ChgLogGA



Error Detail

============

Message: Field is not included on the ChgLogGA.UseFieldList.

Type: Error

Program: bo/ChgLogGA.p

Method: bamRuleBeforeUpdate

Table: ttBAMRule

Row:

Field: RuleField







Stack Trace

===========

at Epicor.Mfg.Proxy.ChgLogGAImpl.Update(ChgLogGADataSet ds)

at Epicor.Mfg.UI.Adapters.ChgLogGAAdapter.Update()

at Epicor.Mfg.UI.App.ChgLogGAEntry.Transaction.Update()





How do I resolve it and how can I complete the set up?



Thanks in advance.







Best Regards,



Herby Dallard

Information Technology Engineer

Endicott Research Group

hdallard@...

607-754-9187 ext. 3078

www.ergpower.com







_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage
Sent: Monday, August 31, 2009 11:47 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Mass update to a check box field in Customer Table





Yes a BPM can update based on a condition multiple rows of fields fields
within the data with a command called UpdateTableBuffer.p
i.e.
for each ttOrderHed where (ttOrderHed.RowMod = 'U' or ttOrderHed.RowMod =
'A'), each OrderRel where OrderRel.Company = ttOrderHed.Company and
Orderrel.OrderNum = ttOrderHed.OrderNum exclusive-lock.
Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE,
'FirmRelease',"NO").
End.

----- Original Message -----
From: herbydallard
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Monday, August 31, 2009 11:30 AM
Subject: [Vantage] Mass update to a check box field in Customer Table

Good morning group

Has anyone performed a mass update on a check-box field to be reflected on
all records in Epicor DB? If yes, how do I go about it?

Thanks.

Best Regards,

Herby Dallard

Information Technology Engineer

Endicott Research Group

hdallard@ergpower. <mailto:hdallard%40ergpower.com> com

607-754-9187 ext. 3078

www.ergpower.com

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





[Non-text portions of this message have been removed]
2
Good morning group

Has anyone performed a mass update on a check-box field to be reflected on all records in Epicor DB? If yes, how do I go about it?

Thanks.

Best Regards,



Herby Dallard

Information Technology Engineer

Endicott Research Group

hdallard@...

607-754-9187 ext. 3078

www.ergpower.com
3
Yes a BPM can update based on a condition multiple rows of fields fields within the data with a command called UpdateTableBuffer.p
i.e.
for each ttOrderHed where (ttOrderHed.RowMod = 'U' or ttOrderHed.RowMod = 'A'), each OrderRel where OrderRel.Company = ttOrderHed.Company and Orderrel.OrderNum = ttOrderHed.OrderNum exclusive-lock.
Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'FirmRelease',"NO").
End.


----- Original Message -----
From: herbydallard
To: vantage@yahoogroups.com
Sent: Monday, August 31, 2009 11:30 AM
Subject: [Vantage] Mass update to a check box field in Customer Table


Good morning group

Has anyone performed a mass update on a check-box field to be reflected on all records in Epicor DB? If yes, how do I go about it?

Thanks.

Best Regards,

Herby Dallard

Information Technology Engineer

Endicott Research Group

hdallard@...

607-754-9187 ext. 3078

www.ergpower.com





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