Custom Row Rule in TransferOrderWorkbench, and Working with EpiS

system · August 3, 2009, 7:03pm

Brian,

Just found this at the bottom of my inbox and realized & never followed up.

Process is pretty simple:

1. Before opening T.O. WB, go into Developer mode (options menu of main Vantage window).
2. Open T.O. WB.
3. Go to Tools menu in T.O. WB and go into Customization.
4. After customization wizard window loads, go to Tools menu and click on Data Tools. A new custom dialog window will open.
5. Click on the big "New CUstom View" button on the top left. This will enable fields on the right side of the form.
6. In "View Name", type "Part". In Parent View Name, select the native "partView". The View Type should automatically fill in as "Foreign Key View" and a new set up fields appear below it in the "Foreign Key View Info" section.
7. In the "Column Name" field, select "PartNum". The "Like Column Value", "Adapter Name" and "Get By Type" should all automatically fill in.
8. Click the "Add" button and save your customization.

You should now be able to rewrite your row rule code vb code referencing the Part.OnHold value as the trigger.

Rob Brown

________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Tuesday, July 14, 2009 11:41:45 AM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

Yep. I appreciate it! :-)

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Robert Brown
Sent: Tuesday, July 14, 2009 11:01 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

I'll send you some screen shots Brian (FKV set up).
T.O.Workench (right?)
Rob

____________ _________ _________ __
From: Brian W. Spolarich <bspolarich@advanced photonix. com>
To: vantage@yahoogroups .com
Sent: Sunday, July 12, 2009 2:42:21 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

I know what all of those words mean but not much notion of how to set it up. :-)

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Robert Brown
Sent: Saturday, July 11, 2009 11:53 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

Brian,
Have you tried bringing Part in as your own FKV & applying the row rule against that instead of the native (apparently useless for your case) PartView?
Rob Brown

____________ _________ _________ __
From: Brian W. Spolarich <bspolarich@ advanced photonix. com>
To: vantage@yahoogroups .com
Sent: Friday, July 10, 2009 5:26:19 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

Thanks Karen. What I'm really getting at is that in Transfer Order Workbench one of the Views on the form is the PartView, but primarily the form is dealing with the newSugView. It doesn't look like the PartView is even defined when the form loads (I get exceptions if I try to add some custom code to examine it).

Clearly there's more involved here than the RowRules will handle with this particular form.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Karen Schoenung
Sent: Friday, July 10, 2009 4:57 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

myTextBox.ForeColor = System.Drawing. Color.Red

I have the above in a script editor, after field update action. This
works to change the text in the field red (EpiTextBox) .

Maybe this can help?

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartVi ewOnHoldEquals_ True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_ PartDescription As
RuleAction = RuleAction.AddContr olSettings( oTrans,
"partView.PartDescr iption", SettingStyle. Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_ PartDescription}

Dim rrpartViewOnHoldEqu als_True As
RowRule = New RowRule("OnHold" , RuleCondition. Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans. EpiDataViews( "partView" ),
EpiDataView) .AddRowRule( rrpartViewOnHold Equals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced photonix. com
<mailto:bspolarich% 40advancedphoton ix.com> ~ 734-864-5618 ~
www.advancedphotoni x.com

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

[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

[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

[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

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

system · July 7, 2009, 5:01pm

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartViewOnHoldEquals_True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_PartDescription As
RuleAction = RuleAction.AddControlSettings(oTrans,
"partView.PartDescription", SettingStyle.Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_PartDescription}

Dim rrpartViewOnHoldEquals_True As
RowRule = New RowRule("OnHold", RuleCondition.Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans.EpiDataViews("partView"),
EpiDataView).AddRowRule(rrpartViewOnHoldEquals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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

system · July 7, 2009, 5:15pm

I think the issue is that nothing from the PartView is visible on this form, and everything is coming from the other DataViews.

Anyone have some specific suggestions on how to accomplish what I want here?

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

system · July 10, 2009, 4:38pm

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartViewOnHoldEquals_True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_PartDescription As
RuleAction = RuleAction.AddControlSettings(oTrans,
"partView.PartDescription", SettingStyle.Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_PartDescription}

Dim rrpartViewOnHoldEquals_True As
RowRule = New RowRule("OnHold", RuleCondition.Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans.EpiDataViews("partView"),
EpiDataView).AddRowRule(rrpartViewOnHoldEquals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com

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

system · July 10, 2009, 4:51pm

Crickets...never a good sound... I haven't worked with epishapes and
haven't done too many row rules..so..i had the same sound earlier this
week with my mom update sc request lol

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbench, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartViewOnHoldEquals_True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_PartDescription As
RuleAction = RuleAction.AddControlSettings(oTrans,
"partView.PartDescription", SettingStyle.Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_PartDescription}

Dim rrpartViewOnHoldEquals_True As
RowRule = New RowRule("OnHold", RuleCondition.Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans.EpiDataViews("partView"),
EpiDataView).AddRowRule(rrpartViewOnHoldEquals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

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

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

system · July 10, 2009, 4:57pm

myTextBox.ForeColor = System.Drawing.Color.Red

I have the above in a script editor, after field update action. This
works to change the text in the field red (EpiTextBox).

Maybe this can help?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbench, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartViewOnHoldEquals_True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_PartDescription As
RuleAction = RuleAction.AddControlSettings(oTrans,
"partView.PartDescription", SettingStyle.Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_PartDescription}

Dim rrpartViewOnHoldEquals_True As
RowRule = New RowRule("OnHold", RuleCondition.Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans.EpiDataViews("partView"),
EpiDataView).AddRowRule(rrpartViewOnHoldEquals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

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

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

system · July 10, 2009, 5:26pm

Thanks Karen. What I'm really getting at is that in Transfer Order Workbench one of the Views on the form is the PartView, but primarily the form is dealing with the newSugView. It doesn't look like the PartView is even defined when the form loads (I get exceptions if I try to add some custom code to examine it).

Clearly there's more involved here than the RowRules will handle with this particular form.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Friday, July 10, 2009 4:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

myTextBox.ForeColor = System.Drawing.Color.Red

I have the above in a script editor, after field update action. This
works to change the text in the field red (EpiTextBox).

Maybe this can help?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbench, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartViewOnHoldEquals_True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_PartDescription As
RuleAction = RuleAction.AddControlSettings(oTrans,
"partView.PartDescription", SettingStyle.Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_PartDescription}

Dim rrpartViewOnHoldEquals_True As
RowRule = New RowRule("OnHold", RuleCondition.Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans.EpiDataViews("partView"),
EpiDataView).AddRowRule(rrpartViewOnHoldEquals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

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

[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

system · July 11, 2009, 11:53am

Brian,
Have you tried bringing Part in as your own FKV & applying the row rule against that instead of the native (apparently useless for your case) PartView?
Rob Brown

________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Friday, July 10, 2009 5:26:19 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

Thanks Karen. What I'm really getting at is that in Transfer Order Workbench one of the Views on the form is the PartView, but primarily the form is dealing with the newSugView. It doesn't look like the PartView is even defined when the form loads (I get exceptions if I try to add some custom code to examine it).

Clearly there's more involved here than the RowRules will handle with this particular form.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Karen Schoenung
Sent: Friday, July 10, 2009 4:57 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

myTextBox.ForeColor = System.Drawing. Color.Red

I have the above in a script editor, after field update action. This
works to change the text in the field red (EpiTextBox) .

Maybe this can help?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartVi ewOnHoldEquals_ True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_ PartDescription As
RuleAction = RuleAction.AddContr olSettings( oTrans,
"partView.PartDescr iption", SettingStyle. Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_ PartDescription}

Dim rrpartViewOnHoldEqu als_True As
RowRule = New RowRule("OnHold" , RuleCondition. Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans. EpiDataViews( "partView" ),
EpiDataView) .AddRowRule( rrpartViewOnHold Equals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced photonix. com
<mailto:bspolarich% 40advancedphoton ix.com> ~ 734-864-5618 ~
www.advancedphotoni x.com

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

[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

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

system · July 12, 2009, 2:43pm

I know what all of those words mean but not much notion of how to set it up. :-)

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert Brown
Sent: Saturday, July 11, 2009 11:53 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

Brian,
Have you tried bringing Part in as your own FKV & applying the row rule against that instead of the native (apparently useless for your case) PartView?
Rob Brown

________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Friday, July 10, 2009 5:26:19 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

Thanks Karen. What I'm really getting at is that in Transfer Order Workbench one of the Views on the form is the PartView, but primarily the form is dealing with the newSugView. It doesn't look like the PartView is even defined when the form loads (I get exceptions if I try to add some custom code to examine it).

Clearly there's more involved here than the RowRules will handle with this particular form.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Karen Schoenung
Sent: Friday, July 10, 2009 4:57 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

myTextBox.ForeColor = System.Drawing. Color.Red

I have the above in a script editor, after field update action. This
works to change the text in the field red (EpiTextBox) .

Maybe this can help?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartVi ewOnHoldEquals_ True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_ PartDescription As
RuleAction = RuleAction.AddContr olSettings( oTrans,
"partView.PartDescr iption", SettingStyle. Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_ PartDescription}

Dim rrpartViewOnHoldEqu als_True As
RowRule = New RowRule("OnHold" , RuleCondition. Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans. EpiDataViews( "partView" ),
EpiDataView) .AddRowRule( rrpartViewOnHold Equals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced photonix. com
<mailto:bspolarich% 40advancedphoton ix.com> ~ 734-864-5618 ~
www.advancedphotoni x.com

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

[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

[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

system · July 14, 2009, 11:01am

I'll send you some screen shots Brian (FKV set up).
T.O.Workench (right?)
Rob

________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Sunday, July 12, 2009 2:42:21 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

I know what all of those words mean but not much notion of how to set it up. :-)

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Robert Brown
Sent: Saturday, July 11, 2009 11:53 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

Brian,
Have you tried bringing Part in as your own FKV & applying the row rule against that instead of the native (apparently useless for your case) PartView?
Rob Brown

____________ _________ _________ __
From: Brian W. Spolarich <bspolarich@advanced photonix. com>
To: vantage@yahoogroups .com
Sent: Friday, July 10, 2009 5:26:19 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

Thanks Karen. What I'm really getting at is that in Transfer Order Workbench one of the Views on the form is the PartView, but primarily the form is dealing with the newSugView. It doesn't look like the PartView is even defined when the form loads (I get exceptions if I try to add some custom code to examine it).

Clearly there's more involved here than the RowRules will handle with this particular form.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Karen Schoenung
Sent: Friday, July 10, 2009 4:57 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

myTextBox.ForeColor = System.Drawing. Color.Red

I have the above in a script editor, after field update action. This
works to change the text in the field red (EpiTextBox) .

Maybe this can help?

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartVi ewOnHoldEquals_ True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_ PartDescription As
RuleAction = RuleAction.AddContr olSettings( oTrans,
"partView.PartDescr iption", SettingStyle. Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_ PartDescription}

Dim rrpartViewOnHoldEqu als_True As
RowRule = New RowRule("OnHold" , RuleCondition. Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans. EpiDataViews( "partView" ),
EpiDataView) .AddRowRule( rrpartViewOnHold Equals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced photonix. com
<mailto:bspolarich% 40advancedphoton ix.com> ~ 734-864-5618 ~
www.advancedphotoni x.com

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

[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

[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

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

system · July 14, 2009, 11:42am

Yep. I appreciate it! :-)

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert Brown
Sent: Tuesday, July 14, 2009 11:01 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

I'll send you some screen shots Brian (FKV set up).
T.O.Workench (right?)
Rob

________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Sunday, July 12, 2009 2:42:21 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbench, and Working with EpiShapes

I know what all of those words mean but not much notion of how to set it up. :-)

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
Â Â Â Â bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Robert Brown
Sent: Saturday, July 11, 2009 11:53 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

Brian,
Have you tried bringing Part in as your own FKV & applying the row rule against that instead of the native (apparently useless for your case) PartView?
Rob Brown

____________ _________ _________ __
From: Brian W. Spolarich <bspolarich@advanced photonix. com>
To: vantage@yahoogroups .com
Sent: Friday, July 10, 2009 5:26:19 PM
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

Thanks Karen. What I'm really getting at is that in Transfer Order Workbench one of the Views on the form is the PartView, but primarily the form is dealing with the newSugView. It doesn't look like the PartView is even defined when the form loads (I get exceptions if I try to add some custom code to examine it).

Clearly there's more involved here than the RowRules will handle with this particular form.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Karen Schoenung
Sent: Friday, July 10, 2009 4:57 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and Working with EpiShapes

myTextBox.ForeColor = System.Drawing. Color.Red

I have the above in a script editor, after field update action. This
works to change the text in the field red (EpiTextBox) .

Maybe this can help?

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Brian W. Spolarich
Sent: Friday, July 10, 2009 3:39 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Custom Row Rule in TransferOrderWorkbe nch, and
Working with EpiShapes

Second time. Anyone have any suggestions? Basically it seems like
the PartView on the form isn't getting populated with data so the rule
never fires.

-bws

-----

I want to create a custom row rule in TOWorkBench that shows the user
when a part is on hold.

I've successfully created a rule that does an error highlight when say
the Required Order Qty is > 5, so I know the mechanism is working.

However if I create the following rule and action (via the wizard),
nothing happens. What I would expect to happen is that if Part.OnHold =
True, the Part.Description field on the form should turn red.

Private Sub CreateRowRulepartVi ewOnHoldEquals_ True

'// Description: PartIsOnHold

'// **** begin autogenerated code ****

Dim errorpartView_ PartDescription As
RuleAction = RuleAction.AddContr olSettings( oTrans,
"partView.PartDescr iption", SettingStyle. Error)

Dim ruleActions As RuleAction() = new
RuleAction() {errorpartView_ PartDescription}

Dim rrpartViewOnHoldEqu als_True As
RowRule = New RowRule("OnHold" , RuleCondition. Equals, True, ruleActions)

'// add to EpiDataView

CType(oTrans. EpiDataViews( "partView" ),
EpiDataView) .AddRowRule( rrpartViewOnHold Equals_True)

'// **** end autogenerated code ****

End Sub

Ideally what's I'd prefer to do is to show a red EpiShape that says
'On Hold' when the Part is OnHold. I couldn't even figure out how to
make the EpiShapes do anything useful. The properties don't include a
way to set the actual color or the text. Anyone know how to use these?

I'm on 8.03.405.

Thanks,

-brian

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced photonix. com
<mailto:bspolarich% 40advancedphoton ix.com> ~ 734-864-5618 ~
www.advancedphotoni x.com

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

[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

[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

[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

Topic		Replies	Views
Rule Wizard -EpiShape Yahoo Archive	15	1708	November 5, 2013
VB Code help - referring to a Foreign Key Yahoo Archive	22	959	May 15, 2009
PartAdapter issues Yahoo Archive	4	689	September 19, 2008
Customization and Rule Wizard Yahoo Archive	2	853	March 11, 2013
In search of a VB wizard Yahoo Archive	8	476	July 10, 2008

Custom Row Rule in TransferOrderWorkbench, and Working with EpiS

Related Topics