How do I add a custom program to the "Open With" menus

> DataSet ds =
> _boReader.GetRows("PartTran","Company="'FormName.Session.CompanyID+'" AND
> TranNum="'e.Row.Cells["TranNum"].Value.ToString()+'"","DMRNum");

well, you are missing concatenation signs all over your where clause - I would create the whereclause ouside of the method call.

string whereClause = "Company = '" + FormName.Session.CompanyID + "' AND
TranNum = '" + e.Row.Cells["TranNum"].Value.ToString() + "'";

_boReader.GetRows("PartTran", whereClause, "DMRNum");
I had to create a custom dashboard version of Part Transaction History because a field we needed was not part of the collection. How do I add my new version of this to all of the "Open With" menus that currently have the Epicor version of this program?
9.04.507a

Mike
You can add not a column to the collection. Check this.

http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specifically-to-chart-tracker/




________________________________
From: mike.numbers <mnumbers@...>
To: vantage@yahoogroups.com
Sent: Wednesday, October 17, 2012 8:33 AM
Subject: [Vantage] How do I add a custom program to the "Open With" menus

I had to create a custom dashboard version of Part Transaction History because a field we needed was not part of the collection. How do I add my new version of this to all of the "Open With" menus that currently have the Epicor version of this program?
9.04.507a

Mike



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

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/.%c2%a0
(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]
I am getting a compile error after adding the first 2 lines of code.

//**************************************************

// Custom C# code for PartTranHistForm

// Created: 10/17/2012 10:11:20 AM

//**************************************************

using System;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using System.ComponentModel;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Searches;

using Epicor.Mfg.BO;





public static class Script

{





// ** Wizard Insert Location - Do Not Remove 'Begin/End
Wizard Added Module Level Variables' Comments! **

// Begin Wizard Added Module Level Variables **



// End Wizard Added Module Level Variables **





// Add Custom Module Level Variables Here **

Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;



public static void InitializeCustomCode()

{



// ** Wizard Insert Location - Do not delete
'Begin/End Wizard Added Variable Initialization' lines **

// Begin Wizard Added Variable
Initialization



// End Wizard Added Variable Initialization

// Begin Wizard Added Custom Method Calls



// End Wizard Added Custom Method Calls


myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");





}







public static void DestroyCustomCode()

{



// ** Wizard Insert Location - Do not delete
'Begin/End Wizard Added Object Disposal' lines **

// Begin Wizard Added Object Disposal



// End Wizard Added Object Disposal

// Begin Custom Code Disposal



// End Custom Code Disposal



}







}

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

Compiling Custom Code ...





----------errors------------



Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare instance
members in a static class



** Compile Failed. **



Any ideas on what I did wrong here? I copied from the Part Transaction
History Tracker.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ted Koch
Sent: Wednesday, October 17, 2012 8:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus





You can add not a column to the collection. Check this.

http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specific
ally-to-chart-tracker/

________________________________
From: mike.numbers <mnumbers@... <mailto:mnumbers%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, October 17, 2012 8:33 AM
Subject: [Vantage] How do I add a custom program to the "Open With" menus

I had to create a custom dashboard version of Part Transaction History
because a field we needed was not part of the collection. How do I add my
new version of this to all of the "Open With" menus that currently have the
Epicor version of this program?
9.04.507a

Mike

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





[Non-text portions of this message have been removed]
Your grid needs to be static.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I am getting a compile error after adding the first 2 lines of code.
>
> //**************************************************
>
> // Custom C# code for PartTranHistForm
>
> // Created: 10/17/2012 10:11:20 AM
>
> //**************************************************
>
> using System;
>
> using System.Data;
>
> using System.Diagnostics;
>
> using System.Windows.Forms;
>
> using System.ComponentModel;
>
> using Epicor.Mfg.UI;
>
> using Epicor.Mfg.UI.FrameWork;
>
> using Epicor.Mfg.UI.ExtendedProps;
>
> using Epicor.Mfg.UI.FormFunctions;
>
> using Epicor.Mfg.UI.Customization;
>
> using Epicor.Mfg.UI.Adapters;
>
> using Epicor.Mfg.UI.Searches;
>
> using Epicor.Mfg.BO;
>
> public static class Script
>
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End
> Wizard Added Module Level Variables' Comments! **
>
> // Begin Wizard Added Module Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here **
>
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
>
> public static void InitializeCustomCode()
>
> {
>
> // ** Wizard Insert Location - Do not delete
> 'Begin/End Wizard Added Variable Initialization' lines **
>
> // Begin Wizard Added Variable
> Initialization
>
> // End Wizard Added Variable Initialization
>
> // Begin Wizard Added Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
>
> }
>
> public static void DestroyCustomCode()
>
> {
>
> // ** Wizard Insert Location - Do not delete
> 'Begin/End Wizard Added Object Disposal' lines **
>
> // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
>
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
>
> }
>
> }
>
> -------------------
>
> Compiling Custom Code ...
>
> ----------errors------------
>
> Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare instance
> members in a static class
>
> ** Compile Failed. **
>
> Any ideas on what I did wrong here? I copied from the Part Transaction
> History Tracker.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> Ted Koch
> Sent: Wednesday, October 17, 2012 8:38 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> You can add not a column to the collection. Check this.
>
>
> http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specific
> ally-to-chart-tracker/
>
> ________________________________
> From: mike.numbers <mnumbers@... <mailto:mnumbers%40cignys.com> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Wednesday, October 17, 2012 8:33 AM
> Subject: [Vantage] How do I add a custom program to the "Open With" menus
>
> I had to create a custom dashboard version of Part Transaction History
> because a field we needed was not part of the collection. How do I add my
> new version of this to all of the "Open With" menus that currently have the
> Epicor version of this program?
> 9.04.507a
>
> Mike
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
I don't understand that. How do I do it?
Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, October 17, 2012 10:34 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

Your grid needs to be static.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I am getting a compile error after adding the first 2 lines of code.
>
> //**************************************************
>
> // Custom C# code for PartTranHistForm
>
> // Created: 10/17/2012 10:11:20 AM
>
> //**************************************************
>
> using System;
>
> using System.Data;
>
> using System.Diagnostics;
>
> using System.Windows.Forms;
>
> using System.ComponentModel;
>
> using Epicor.Mfg.UI;
>
> using Epicor.Mfg.UI.FrameWork;
>
> using Epicor.Mfg.UI.ExtendedProps;
>
> using Epicor.Mfg.UI.FormFunctions;
>
> using Epicor.Mfg.UI.Customization;
>
> using Epicor.Mfg.UI.Adapters;
>
> using Epicor.Mfg.UI.Searches;
>
> using Epicor.Mfg.BO;
>
> public static class Script
>
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> Module Level Variables' Comments! **
>
> // Begin Wizard Added Module Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here **
>
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
>
> public static void InitializeCustomCode()
>
> {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Variable Initialization' lines **
>
> // Begin Wizard Added Variable
> Initialization
>
> // End Wizard Added Variable Initialization
>
> // Begin Wizard Added Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
>
> }
>
> public static void DestroyCustomCode()
>
> {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Object Disposal' lines **
>
> // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
>
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
>
> }
>
> }
>
> -------------------
>
> Compiling Custom Code ...
>
> ----------errors------------
>
> Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> instance members in a static class
>
> ** Compile Failed. **
>
> Any ideas on what I did wrong here? I copied from the Part Transaction
> History Tracker.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Ted Koch
> Sent: Wednesday, October 17, 2012 8:38 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> You can add not a column to the collection. Check this.
>
>
> http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-sp
> ecific
> ally-to-chart-tracker/
>
> ________________________________
> From: mike.numbers <mnumbers@... <mailto:mnumbers%40cignys.com>
> >
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Wednesday, October 17, 2012 8:33 AM
> Subject: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> I had to create a custom dashboard version of Part Transaction History
> because a field we needed was not part of the collection. How do I add
> my new version of this to all of the "Open With" menus that currently
> have the Epicor version of this program?
> 9.04.507a
>
> Mike
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
> )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
> [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
Just change:
Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
To:
static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I don't understand that. How do I do it?
> Mike
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> John Driggers
> Sent: Wednesday, October 17, 2012 10:34 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Your grid needs to be static.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
>
> *
>
> On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...>
> wrote:
>
> > **
>
> >
> >
> > I am getting a compile error after adding the first 2 lines of code.
> >
> > //**************************************************
> >
> > // Custom C# code for PartTranHistForm
> >
> > // Created: 10/17/2012 10:11:20 AM
> >
> > //**************************************************
> >
> > using System;
> >
> > using System.Data;
> >
> > using System.Diagnostics;
> >
> > using System.Windows.Forms;
> >
> > using System.ComponentModel;
> >
> > using Epicor.Mfg.UI;
> >
> > using Epicor.Mfg.UI.FrameWork;
> >
> > using Epicor.Mfg.UI.ExtendedProps;
> >
> > using Epicor.Mfg.UI.FormFunctions;
> >
> > using Epicor.Mfg.UI.Customization;
> >
> > using Epicor.Mfg.UI.Adapters;
> >
> > using Epicor.Mfg.UI.Searches;
> >
> > using Epicor.Mfg.BO;
> >
> > public static class Script
> >
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! **
> >
> > // Begin Wizard Added Module Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here **
> >
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> >
> > public static void InitializeCustomCode()
> >
> > {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines **
> >
> > // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization
> >
> > // Begin Wizard Added Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> >
> > }
> >
> > public static void DestroyCustomCode()
> >
> > {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines **
> >
> > // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> >
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> >
> > }
> >
> > }
> >
> > -------------------
> >
> > Compiling Custom Code ...
> >
> > ----------errors------------
> >
> > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > instance members in a static class
> >
> > ** Compile Failed. **
> >
> > Any ideas on what I did wrong here? I copied from the Part Transaction
> > History Tracker.
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ted Koch
> > Sent: Wednesday, October 17, 2012 8:38 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > You can add not a column to the collection. Check this.
> >
> >
> > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-sp
> > ecific
> > ally-to-chart-tracker/
> >
> > ________________________________
> > From: mike.numbers <mnumbers@... <mailto:mnumbers%40cignys.com>
> > >
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, October 17, 2012 8:33 AM
> > Subject: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > I had to create a custom dashboard version of Part Transaction History
> > because a field we needed was not part of the collection. How do I add
> > my new version of this to all of the "Open With" menus that currently
> > have the Epicor version of this program?
> > 9.04.507a
> >
> > Mike
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access.
> > )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> > [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]
Thanks

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, October 17, 2012 10:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

Just change:
Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
To:
static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I don't understand that. How do I do it?
> Mike
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of John Driggers
> Sent: Wednesday, October 17, 2012 10:34 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Your grid needs to be static.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
>
> *
>
> On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...>
> wrote:
>
> > **
>
> >
> >
> > I am getting a compile error after adding the first 2 lines of code.
> >
> > //**************************************************
> >
> > // Custom C# code for PartTranHistForm
> >
> > // Created: 10/17/2012 10:11:20 AM
> >
> > //**************************************************
> >
> > using System;
> >
> > using System.Data;
> >
> > using System.Diagnostics;
> >
> > using System.Windows.Forms;
> >
> > using System.ComponentModel;
> >
> > using Epicor.Mfg.UI;
> >
> > using Epicor.Mfg.UI.FrameWork;
> >
> > using Epicor.Mfg.UI.ExtendedProps;
> >
> > using Epicor.Mfg.UI.FormFunctions;
> >
> > using Epicor.Mfg.UI.Customization;
> >
> > using Epicor.Mfg.UI.Adapters;
> >
> > using Epicor.Mfg.UI.Searches;
> >
> > using Epicor.Mfg.BO;
> >
> > public static class Script
> >
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! **
> >
> > // Begin Wizard Added Module Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here **
> >
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> >
> > public static void InitializeCustomCode()
> >
> > {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines **
> >
> > // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization
> >
> > // Begin Wizard Added Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> >
> > }
> >
> > public static void DestroyCustomCode()
> >
> > {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines **
> >
> > // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> >
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> >
> > }
> >
> > }
> >
> > -------------------
> >
> > Compiling Custom Code ...
> >
> > ----------errors------------
> >
> > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > instance members in a static class
> >
> > ** Compile Failed. **
> >
> > Any ideas on what I did wrong here? I copied from the Part
> > Transaction History Tracker.
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ted Koch
> > Sent: Wednesday, October 17, 2012 8:38 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > You can add not a column to the collection. Check this.
> >
> >
> > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-
> > sp
> > ecific
> > ally-to-chart-tracker/
> >
> > ________________________________
> > From: mike.numbers <mnumbers@...
> > <mailto:mnumbers%40cignys.com>
> > >
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, October 17, 2012 8:33 AM
> > Subject: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > I had to create a custom dashboard version of Part Transaction
> > History because a field we needed was not part of the collection.
> > How do I add my new version of this to all of the "Open With" menus
> > that currently have the Epicor version of this program?
> > 9.04.507a
> >
> > Mike
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
access.
> > )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> > [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
John,
I was pointed to your blog and your example of adding a column to an Epicor
tracker. My programming background is not in C# or VB but the logic
normally makes sense and I am learning by example. The example you have on
your blog looks like it is pulling in another table for the information.
The field I need is actually on the parttran table, it just is not listed
in the Collection for the dashboard. I am getting some errors that I don't
understand and was wondering if you could explain them to me or point me in
the right direction. First was the error I got about the grid being a
"static" grid. Why is this grid different from the one in your blog? After
I changed the grid to static, I got errors on the BOReader statements and
the grdMatLst statements. I assume these are all related. Also the on the
DataSet ds statement with GetRows I thought the first parameter "APInvoice"
would be the table to read, "InvoiceNum=... would be the key, and
"InvoiceDate" would be the field getting pulled. But the APInvoice table
does not exist, APInvHed does.
I appreciate all of the help you guys have given me and I realize this isn't
your job. With that said, any additional help or pointers would be
appreciated.

Thanks
Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, October 17, 2012 10:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

Just change:
Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
To:
static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I don't understand that. How do I do it?
> Mike
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of John Driggers
> Sent: Wednesday, October 17, 2012 10:34 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Your grid needs to be static.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
>
> *
>
> On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...>
> wrote:
>
> > **
>
> >
> >
> > I am getting a compile error after adding the first 2 lines of code.
> >
> > //**************************************************
> >
> > // Custom C# code for PartTranHistForm
> >
> > // Created: 10/17/2012 10:11:20 AM
> >
> > //**************************************************
> >
> > using System;
> >
> > using System.Data;
> >
> > using System.Diagnostics;
> >
> > using System.Windows.Forms;
> >
> > using System.ComponentModel;
> >
> > using Epicor.Mfg.UI;
> >
> > using Epicor.Mfg.UI.FrameWork;
> >
> > using Epicor.Mfg.UI.ExtendedProps;
> >
> > using Epicor.Mfg.UI.FormFunctions;
> >
> > using Epicor.Mfg.UI.Customization;
> >
> > using Epicor.Mfg.UI.Adapters;
> >
> > using Epicor.Mfg.UI.Searches;
> >
> > using Epicor.Mfg.BO;
> >
> > public static class Script
> >
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! **
> >
> > // Begin Wizard Added Module Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here **
> >
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> >
> > public static void InitializeCustomCode()
> >
> > {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines **
> >
> > // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization
> >
> > // Begin Wizard Added Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> >
> > }
> >
> > public static void DestroyCustomCode()
> >
> > {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines **
> >
> > // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> >
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> >
> > }
> >
> > }
> >
> > -------------------
> >
> > Compiling Custom Code ...
> >
> > ----------errors------------
> >
> > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > instance members in a static class
> >
> > ** Compile Failed. **
> >
> > Any ideas on what I did wrong here? I copied from the Part
> > Transaction History Tracker.
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Ted Koch
> > Sent: Wednesday, October 17, 2012 8:38 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > You can add not a column to the collection. Check this.
> >
> >
> > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-
> > sp
> > ecific
> > ally-to-chart-tracker/
> >
> > ________________________________
> > From: mike.numbers <mnumbers@...
> > <mailto:mnumbers%40cignys.com>
> > >
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, October 17, 2012 8:33 AM
> > Subject: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > I had to create a custom dashboard version of Part Transaction
> > History because a field we needed was not part of the collection.
> > How do I add my new version of this to all of the "Open With" menus
> > that currently have the Epicor version of this program?
> > 9.04.507a
> >
> > Mike
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
access.
> > )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> > [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
We're always happy to help!

Without looking deeper into it, I'm not sure why the grid is different in
our code. That form could work a bit differently, or maybe it's just an
error in the code we posted.

The main purpose of the code in our example is to pull values from other
tables. Generally the Epicor dataviews contain all the fields from a given
table, but if that isn't the case for this scenario, the code should still
do the job.

Regarding the BOReader, the first parameter is the BusinessObject you want
to use, not the table. BOReader basically calls the 'GetRows' method on
that BusinessObject with the WhereClause you provide and only returns the
fields you specify. Its main purpose is to allow you to do quick queries
against various BusinessObjects without the hassle of
instantiating/disposing a BO and pulling in references, etc. It also saves
you the performance hit inherent in returning a potentially large dataset
when you only need a column or two.

As for your other errors, it's probably best to handle them one at a time.
If you'd like, post the errors you get when testing the code and the
offending code and we'll just go through em one by one.



*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> John,
> I was pointed to your blog and your example of adding a column to an Epicor
> tracker. My programming background is not in C# or VB but the logic
> normally makes sense and I am learning by example. The example you have on
> your blog looks like it is pulling in another table for the information.
> The field I need is actually on the parttran table, it just is not listed
> in the Collection for the dashboard. I am getting some errors that I don't
> understand and was wondering if you could explain them to me or point me in
> the right direction. First was the error I got about the grid being a
> "static" grid. Why is this grid different from the one in your blog? After
> I changed the grid to static, I got errors on the BOReader statements and
> the grdMatLst statements. I assume these are all related. Also the on the
> DataSet ds statement with GetRows I thought the first parameter "APInvoice"
> would be the table to read, "InvoiceNum=... would be the key, and
> "InvoiceDate" would be the field getting pulled. But the APInvoice table
> does not exist, APInvHed does.
> I appreciate all of the help you guys have given me and I realize this
> isn't
> your job. With that said, any additional help or pointers would be
> appreciated.
>
> Thanks
>
> Mike
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> John Driggers
> Sent: Wednesday, October 17, 2012 10:49 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Just change:
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> To:
> static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...>
> wrote:
>
> > **
>
> >
> >
> > I don't understand that. How do I do it?
> > Mike
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 10:34 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > Your grid needs to be static.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > I am getting a compile error after adding the first 2 lines of code.
> > >
> > > //**************************************************
> > >
> > > // Custom C# code for PartTranHistForm
> > >
> > > // Created: 10/17/2012 10:11:20 AM
> > >
> > > //**************************************************
> > >
> > > using System;
> > >
> > > using System.Data;
> > >
> > > using System.Diagnostics;
> > >
> > > using System.Windows.Forms;
> > >
> > > using System.ComponentModel;
> > >
> > > using Epicor.Mfg.UI;
> > >
> > > using Epicor.Mfg.UI.FrameWork;
> > >
> > > using Epicor.Mfg.UI.ExtendedProps;
> > >
> > > using Epicor.Mfg.UI.FormFunctions;
> > >
> > > using Epicor.Mfg.UI.Customization;
> > >
> > > using Epicor.Mfg.UI.Adapters;
> > >
> > > using Epicor.Mfg.UI.Searches;
> > >
> > > using Epicor.Mfg.BO;
> > >
> > > public static class Script
> > >
> > > {
> > >
> > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > > Module Level Variables' Comments! **
> > >
> > > // Begin Wizard Added Module Level Variables **
> > >
> > > // End Wizard Added Module Level Variables **
> > >
> > > // Add Custom Module Level Variables Here **
> > >
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > >
> > > public static void InitializeCustomCode()
> > >
> > > {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > > Variable Initialization' lines **
> > >
> > > // Begin Wizard Added Variable
> > > Initialization
> > >
> > > // End Wizard Added Variable Initialization
> > >
> > > // Begin Wizard Added Custom Method Calls
> > >
> > > // End Wizard Added Custom Method Calls
> > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > >
> > > }
> > >
> > > public static void DestroyCustomCode()
> > >
> > > {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > > Object Disposal' lines **
> > >
> > > // Begin Wizard Added Object Disposal
> > >
> > > // End Wizard Added Object Disposal
> > >
> > > // Begin Custom Code Disposal
> > >
> > > // End Custom Code Disposal
> > >
> > > }
> > >
> > > }
> > >
> > > -------------------
> > >
> > > Compiling Custom Code ...
> > >
> > > ----------errors------------
> > >
> > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > > instance members in a static class
> > >
> > > ** Compile Failed. **
> > >
> > > Any ideas on what I did wrong here? I copied from the Part
> > > Transaction History Tracker.
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of Ted Koch
> > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > > menus
> > >
> > > You can add not a column to the collection. Check this.
> > >
> > >
> > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-
> > > sp
> > > ecific
> > > ally-to-chart-tracker/
> > >
> > > ________________________________
> > > From: mike.numbers <mnumbers@...
> > > <mailto:mnumbers%40cignys.com>
> > > >
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > Subject: [Vantage] How do I add a custom program to the "Open With"
> > > menus
> > >
> > > I had to create a custom dashboard version of Part Transaction
> > > History because a field we needed was not part of the collection.
> > > How do I add my new version of this to all of the "Open With" menus
> > > that currently have the Epicor version of this program?
> > > 9.04.507a
> > >
> > > Mike
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > must have already linked your email address to a yahoo id to enable
> access.
> > > )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder and Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > > <http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > [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]
Thanks again for your help.

Below is my code. I have commented out statements that were giving me
errors. I eventually stopped following your example and sent you my
previous email. I uncommented the BOReader statements and tested my code.
The error is at the bottom.

//**************************************************
// Custom C# code for PartTranHistForm
// Created: 10/17/2012 10:11:20 AM
//**************************************************
using System;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using System.ComponentModel;
using Epicor.Mfg.UI;
using Epicor.Mfg.UI.FrameWork;
using Epicor.Mfg.UI.ExtendedProps;
using Epicor.Mfg.UI.FormFunctions;
using Epicor.Mfg.UI.Customization;
using Epicor.Mfg.UI.Adapters;
using Epicor.Mfg.UI.Searches;
using Epicor.Mfg.BO;
using Epicor.Mfg.Core;
using Epicor.Mfg.Lib;


public static class Script
{


// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
Module Level Variables' Comments! **
// Begin Wizard Added Module Level Variables **

// End Wizard Added Module Level Variables **


// Add Custom Module Level Variables Here **
static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
BOReader _boReader;

public static void InitializeCustomCode()
{

// ** Wizard Insert Location - Do not delete 'Begin/End
Wizard Added Variable Initialization' lines **
// Begin Wizard Added Variable Initialization

// End Wizard Added Variable Initialization
// Begin Wizard Added Custom Method Calls

// End Wizard Added Custom Method Calls

myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
Number");
//myGrid.InitializeRow += new
Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
Row);
_boReader = new
BOReader(((Session)oTrans.Session).ConnectionPool);


}
//private void grdMstLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
//{

//}
public static void DestroyCustomCode()
{

// ** Wizard Insert Location - Do not delete 'Begin/End
Wizard Added Object Disposal' lines **
// Begin Wizard Added Object Disposal

// End Wizard Added Object Disposal
// Begin Custom Code Disposal

// End Custom Code Disposal
//myGrid.InitializeRow -= new
Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
Row);

}



}
----------errors------------

Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare instance
members in a static class

** Compile Failed. **
FYI
Line 34 = BOReader _boReader;

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, October 17, 2012 1:14 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

We're always happy to help!

Without looking deeper into it, I'm not sure why the grid is different in
our code. That form could work a bit differently, or maybe it's just an
error in the code we posted.

The main purpose of the code in our example is to pull values from other
tables. Generally the Epicor dataviews contain all the fields from a given
table, but if that isn't the case for this scenario, the code should still
do the job.

Regarding the BOReader, the first parameter is the BusinessObject you want
to use, not the table. BOReader basically calls the 'GetRows' method on that
BusinessObject with the WhereClause you provide and only returns the fields
you specify. Its main purpose is to allow you to do quick queries against
various BusinessObjects without the hassle of instantiating/disposing a BO
and pulling in references, etc. It also saves you the performance hit
inherent in returning a potentially large dataset when you only need a
column or two.

As for your other errors, it's probably best to handle them one at a time.
If you'd like, post the errors you get when testing the code and the
offending code and we'll just go through em one by one.



*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> John,
> I was pointed to your blog and your example of adding a column to an
> Epicor tracker. My programming background is not in C# or VB but the
> logic normally makes sense and I am learning by example. The example
> you have on your blog looks like it is pulling in another table for the
information.
> The field I need is actually on the parttran table, it just is not
> listed in the Collection for the dashboard. I am getting some errors
> that I don't understand and was wondering if you could explain them to
> me or point me in the right direction. First was the error I got about
> the grid being a "static" grid. Why is this grid different from the
> one in your blog? After I changed the grid to static, I got errors on
> the BOReader statements and the grdMatLst statements. I assume these
> are all related. Also the on the DataSet ds statement with GetRows I
thought the first parameter "APInvoice"
> would be the table to read, "InvoiceNum=... would be the key, and
> "InvoiceDate" would be the field getting pulled. But the APInvoice
> table does not exist, APInvHed does.
> I appreciate all of the help you guys have given me and I realize this
> isn't your job. With that said, any additional help or pointers would
> be appreciated.
>
> Thanks
>
> Mike
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of John Driggers
> Sent: Wednesday, October 17, 2012 10:49 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Just change:
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> To:
> static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...>
> wrote:
>
> > **
>
> >
> >
> > I don't understand that. How do I do it?
> > Mike
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 10:34 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > Your grid needs to be static.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > I am getting a compile error after adding the first 2 lines of code.
> > >
> > > //**************************************************
> > >
> > > // Custom C# code for PartTranHistForm
> > >
> > > // Created: 10/17/2012 10:11:20 AM
> > >
> > > //**************************************************
> > >
> > > using System;
> > >
> > > using System.Data;
> > >
> > > using System.Diagnostics;
> > >
> > > using System.Windows.Forms;
> > >
> > > using System.ComponentModel;
> > >
> > > using Epicor.Mfg.UI;
> > >
> > > using Epicor.Mfg.UI.FrameWork;
> > >
> > > using Epicor.Mfg.UI.ExtendedProps;
> > >
> > > using Epicor.Mfg.UI.FormFunctions;
> > >
> > > using Epicor.Mfg.UI.Customization;
> > >
> > > using Epicor.Mfg.UI.Adapters;
> > >
> > > using Epicor.Mfg.UI.Searches;
> > >
> > > using Epicor.Mfg.BO;
> > >
> > > public static class Script
> > >
> > > {
> > >
> > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > Added Module Level Variables' Comments! **
> > >
> > > // Begin Wizard Added Module Level Variables **
> > >
> > > // End Wizard Added Module Level Variables **
> > >
> > > // Add Custom Module Level Variables Here **
> > >
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > >
> > > public static void InitializeCustomCode()
> > >
> > > {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > Added Variable Initialization' lines **
> > >
> > > // Begin Wizard Added Variable
> > > Initialization
> > >
> > > // End Wizard Added Variable Initialization
> > >
> > > // Begin Wizard Added Custom Method Calls
> > >
> > > // End Wizard Added Custom Method Calls
> > >
> > >
> > >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > >
> > > }
> > >
> > > public static void DestroyCustomCode()
> > >
> > > {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > Added Object Disposal' lines **
> > >
> > > // Begin Wizard Added Object Disposal
> > >
> > > // End Wizard Added Object Disposal
> > >
> > > // Begin Custom Code Disposal
> > >
> > > // End Custom Code Disposal
> > >
> > > }
> > >
> > > }
> > >
> > > -------------------
> > >
> > > Compiling Custom Code ...
> > >
> > > ----------errors------------
> > >
> > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > > instance members in a static class
> > >
> > > ** Compile Failed. **
> > >
> > > Any ideas on what I did wrong here? I copied from the Part
> > > Transaction History Tracker.
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of Ted Koch
> > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open
With"
> > > menus
> > >
> > > You can add not a column to the collection. Check this.
> > >
> > >
> > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epico
> > > r-
> > > sp
> > > ecific
> > > ally-to-chart-tracker/
> > >
> > > ________________________________
> > > From: mike.numbers <mnumbers@...
> > > <mailto:mnumbers%40cignys.com>
> > > >
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > Subject: [Vantage] How do I add a custom program to the "Open With"
> > > menus
> > >
> > > I had to create a custom dashboard version of Part Transaction
> > > History because a field we needed was not part of the collection.
> > > How do I add my new version of this to all of the "Open With"
> > > menus that currently have the Epicor version of this program?
> > > 9.04.507a
> > >
> > > Mike
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > must have already linked your email address to a yahoo id to
> > > enable
> access.
> > > )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder and Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > > <http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > [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
Set your BO reader as static as we did with the grid. That should sort that
out.

I noticed that you commented out the sections where you were wiring up the
eventhandler on the grid. Assuming this fixes your BOReader issue, let's
uncomment those next and see what we get.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> Thanks again for your help.
>
> Below is my code. I have commented out statements that were giving me
> errors. I eventually stopped following your example and sent you my
> previous email. I uncommented the BOReader statements and tested my code.
> The error is at the bottom.
>
>
> //**************************************************
> // Custom C# code for PartTranHistForm
> // Created: 10/17/2012 10:11:20 AM
> //**************************************************
> using System;
> using System.Data;
> using System.Diagnostics;
> using System.Windows.Forms;
> using System.ComponentModel;
> using Epicor.Mfg.UI;
> using Epicor.Mfg.UI.FrameWork;
> using Epicor.Mfg.UI.ExtendedProps;
> using Epicor.Mfg.UI.FormFunctions;
> using Epicor.Mfg.UI.Customization;
> using Epicor.Mfg.UI.Adapters;
> using Epicor.Mfg.UI.Searches;
> using Epicor.Mfg.BO;
> using Epicor.Mfg.Core;
> using Epicor.Mfg.Lib;
>
>
> public static class Script
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> Module Level Variables' Comments! **
> // Begin Wizard Added Module Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here **
> static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> BOReader _boReader;
>
>
> public static void InitializeCustomCode()
> {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End
> Wizard Added Variable Initialization' lines **
> // Begin Wizard Added Variable Initialization
>
> // End Wizard Added Variable Initialization
> // Begin Wizard Added Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> Number");
> //myGrid.InitializeRow += new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
> Row);
> _boReader = new
> BOReader(((Session)oTrans.Session).ConnectionPool);
>
>
> }
> //private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> //{
>
> //}
>
> public static void DestroyCustomCode()
> {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End
> Wizard Added Object Disposal' lines **
> // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
> //myGrid.InitializeRow -= new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
> Row);
>
> }
>
> }
> ----------errors------------
>
> Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare instance
>
> members in a static class
>
> ** Compile Failed. **
> FYI
> Line 34 = BOReader _boReader;
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> John Driggers
> Sent: Wednesday, October 17, 2012 1:14 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> We're always happy to help!
>
> Without looking deeper into it, I'm not sure why the grid is different in
> our code. That form could work a bit differently, or maybe it's just an
> error in the code we posted.
>
> The main purpose of the code in our example is to pull values from other
> tables. Generally the Epicor dataviews contain all the fields from a given
> table, but if that isn't the case for this scenario, the code should still
> do the job.
>
> Regarding the BOReader, the first parameter is the BusinessObject you want
> to use, not the table. BOReader basically calls the 'GetRows' method on
> that
> BusinessObject with the WhereClause you provide and only returns the fields
> you specify. Its main purpose is to allow you to do quick queries against
> various BusinessObjects without the hassle of instantiating/disposing a BO
> and pulling in references, etc. It also saves you the performance hit
> inherent in returning a potentially large dataset when you only need a
> column or two.
>
> As for your other errors, it's probably best to handle them one at a time.
> If you'd like, post the errors you get when testing the code and the
> offending code and we'll just go through em one by one.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...>
> wrote:
>
> > **
>
> >
> >
> > John,
> > I was pointed to your blog and your example of adding a column to an
> > Epicor tracker. My programming background is not in C# or VB but the
> > logic normally makes sense and I am learning by example. The example
> > you have on your blog looks like it is pulling in another table for the
> information.
> > The field I need is actually on the parttran table, it just is not
> > listed in the Collection for the dashboard. I am getting some errors
> > that I don't understand and was wondering if you could explain them to
> > me or point me in the right direction. First was the error I got about
> > the grid being a "static" grid. Why is this grid different from the
> > one in your blog? After I changed the grid to static, I got errors on
> > the BOReader statements and the grdMatLst statements. I assume these
> > are all related. Also the on the DataSet ds statement with GetRows I
> thought the first parameter "APInvoice"
> > would be the table to read, "InvoiceNum=... would be the key, and
> > "InvoiceDate" would be the field getting pulled. But the APInvoice
> > table does not exist, APInvHed does.
> > I appreciate all of the help you guys have given me and I realize this
> > isn't your job. With that said, any additional help or pointers would
> > be appreciated.
> >
> > Thanks
> >
> > Mike
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 10:49 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > Just change:
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > To:
> > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > I don't understand that. How do I do it?
> > > Mike
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > > menus
> > >
> > > Your grid needs to be static.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers <mnumbers@...>
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am getting a compile error after adding the first 2 lines of code.
> > > >
> > > > //**************************************************
> > > >
> > > > // Custom C# code for PartTranHistForm
> > > >
> > > > // Created: 10/17/2012 10:11:20 AM
> > > >
> > > > //**************************************************
> > > >
> > > > using System;
> > > >
> > > > using System.Data;
> > > >
> > > > using System.Diagnostics;
> > > >
> > > > using System.Windows.Forms;
> > > >
> > > > using System.ComponentModel;
> > > >
> > > > using Epicor.Mfg.UI;
> > > >
> > > > using Epicor.Mfg.UI.FrameWork;
> > > >
> > > > using Epicor.Mfg.UI.ExtendedProps;
> > > >
> > > > using Epicor.Mfg.UI.FormFunctions;
> > > >
> > > > using Epicor.Mfg.UI.Customization;
> > > >
> > > > using Epicor.Mfg.UI.Adapters;
> > > >
> > > > using Epicor.Mfg.UI.Searches;
> > > >
> > > > using Epicor.Mfg.BO;
> > > >
> > > > public static class Script
> > > >
> > > > {
> > > >
> > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > Added Module Level Variables' Comments! **
> > > >
> > > > // Begin Wizard Added Module Level Variables **
> > > >
> > > > // End Wizard Added Module Level Variables **
> > > >
> > > > // Add Custom Module Level Variables Here **
> > > >
> > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > >
> > > > public static void InitializeCustomCode()
> > > >
> > > > {
> > > >
> > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > Added Variable Initialization' lines **
> > > >
> > > > // Begin Wizard Added Variable
> > > > Initialization
> > > >
> > > > // End Wizard Added Variable Initialization
> > > >
> > > > // Begin Wizard Added Custom Method Calls
> > > >
> > > > // End Wizard Added Custom Method Calls
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > >
> > > > }
> > > >
> > > > public static void DestroyCustomCode()
> > > >
> > > > {
> > > >
> > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > Added Object Disposal' lines **
> > > >
> > > > // Begin Wizard Added Object Disposal
> > > >
> > > > // End Wizard Added Object Disposal
> > > >
> > > > // Begin Custom Code Disposal
> > > >
> > > > // End Custom Code Disposal
> > > >
> > > > }
> > > >
> > > > }
> > > >
> > > > -------------------
> > > >
> > > > Compiling Custom Code ...
> > > >
> > > > ----------errors------------
> > > >
> > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > > > instance members in a static class
> > > >
> > > > ** Compile Failed. **
> > > >
> > > > Any ideas on what I did wrong here? I copied from the Part
> > > > Transaction History Tracker.
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > Behalf Of Ted Koch
> > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the "Open
> With"
> > > > menus
> > > >
> > > > You can add not a column to the collection. Check this.
> > > >
> > > >
> > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epico
> > > > r-
> > > > sp
> > > > ecific
> > > > ally-to-chart-tracker/
> > > >
> > > > ________________________________
> > > > From: mike.numbers <mnumbers@...
> > > > <mailto:mnumbers%40cignys.com>
> > > > >
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > Subject: [Vantage] How do I add a custom program to the "Open With"
> > > > menus
> > > >
> > > > I had to create a custom dashboard version of Part Transaction
> > > > History because a field we needed was not part of the collection.
> > > > How do I add my new version of this to all of the "Open With"
> > > > menus that currently have the Epicor version of this program?
> > > > 9.04.507a
> > > >
> > > > Mike
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > > must have already linked your email address to a yahoo id to
> > > > enable
> > access.
> > > > )
> > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > Builder and Crystal Reports and other 'goodies', please goto:
> > > > http://groups.yahoo.com/group/vantage/files/.
> > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > (2) To search through old msg's goto:
> > > > http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > > [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]
I had to add Epicor.Mfg.Lib.IBOReader.dll and
Epicor.Mfg.Core.BLConnectionPool.dll.

I uncommented the other statements and am now receiving the following
message.

Compiling Custom Code ...


----------errors------------

Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot declare
instance members in a static class

** Compile Failed. **
Line 53 = private void grdMstLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)

I tried putting static in front of grdMstLst but received another error so I
took it back out.
See code below:

//**************************************************
// Custom C# code for PartTranHistForm
// Created: 10/17/2012 10:11:20 AM
//**************************************************
using System;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using System.ComponentModel;
using Epicor.Mfg.UI;
using Epicor.Mfg.UI.FrameWork;
using Epicor.Mfg.UI.ExtendedProps;
using Epicor.Mfg.UI.FormFunctions;
using Epicor.Mfg.UI.Customization;
using Epicor.Mfg.UI.Adapters;
using Epicor.Mfg.UI.Searches;
using Epicor.Mfg.BO;
using Epicor.Mfg.Core;
using Epicor.Mfg.Lib;


public static class Script
{


// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
Module Level Variables' Comments! **
// Begin Wizard Added Module Level Variables **

// End Wizard Added Module Level Variables **


// Add Custom Module Level Variables Here **
static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
static BOReader _boReader;

public static void InitializeCustomCode()
{

// ** Wizard Insert Location - Do not delete 'Begin/End
Wizard Added Variable Initialization' lines **
// Begin Wizard Added Variable Initialization

// End Wizard Added Variable Initialization
// Begin Wizard Added Custom Method Calls

// End Wizard Added Custom Method Calls

myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
Number");
myGrid.InitializeRow += new
Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
Row);
_boReader = new
BOReader(((Session)oTrans.Session).ConnectionPool);


}
private void grdMstLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
{

}
public static void DestroyCustomCode()
{

// ** Wizard Insert Location - Do not delete 'Begin/End
Wizard Added Object Disposal' lines **
// Begin Wizard Added Object Disposal

// End Wizard Added Object Disposal
// Begin Custom Code Disposal

// End Custom Code Disposal
//myGrid.InitializeRow -= new
Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
Row);

}



}

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, October 17, 2012 2:10 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

Set your BO reader as static as we did with the grid. That should sort that
out.

I noticed that you commented out the sections where you were wiring up the
eventhandler on the grid. Assuming this fixes your BOReader issue, let's
uncomment those next and see what we get.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> Thanks again for your help.
>
> Below is my code. I have commented out statements that were giving me
> errors. I eventually stopped following your example and sent you my
> previous email. I uncommented the BOReader statements and tested my code.
> The error is at the bottom.
>
>
> //**************************************************
> // Custom C# code for PartTranHistForm // Created: 10/17/2012 10:11:20
> AM
> //**************************************************
> using System;
> using System.Data;
> using System.Diagnostics;
> using System.Windows.Forms;
> using System.ComponentModel;
> using Epicor.Mfg.UI;
> using Epicor.Mfg.UI.FrameWork;
> using Epicor.Mfg.UI.ExtendedProps;
> using Epicor.Mfg.UI.FormFunctions;
> using Epicor.Mfg.UI.Customization;
> using Epicor.Mfg.UI.Adapters;
> using Epicor.Mfg.UI.Searches;
> using Epicor.Mfg.BO;
> using Epicor.Mfg.Core;
> using Epicor.Mfg.Lib;
>
>
> public static class Script
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> Module Level Variables' Comments! ** // Begin Wizard Added Module
> Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here ** static
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
>
>
> public static void InitializeCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Variable Initialization' lines ** // Begin Wizard Added Variable
> Initialization
>
> // End Wizard Added Variable Initialization // Begin Wizard Added
> Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> Number");
> //myGrid.InitializeRow += new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
> _boReader = new
> BOReader(((Session)oTrans.Session).ConnectionPool);
>
>
> }
> //private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
>
> //}
>
> public static void DestroyCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Object Disposal' lines ** // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
> //myGrid.InitializeRow -= new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
>
> }
>
> }
> ----------errors------------
>
> Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> instance
>
> members in a static class
>
> ** Compile Failed. **
> FYI
> Line 34 = BOReader _boReader;
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of John Driggers
> Sent: Wednesday, October 17, 2012 1:14 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> We're always happy to help!
>
> Without looking deeper into it, I'm not sure why the grid is different
> in our code. That form could work a bit differently, or maybe it's
> just an error in the code we posted.
>
> The main purpose of the code in our example is to pull values from
> other tables. Generally the Epicor dataviews contain all the fields
> from a given table, but if that isn't the case for this scenario, the
> code should still do the job.
>
> Regarding the BOReader, the first parameter is the BusinessObject you
> want to use, not the table. BOReader basically calls the 'GetRows'
> method on that BusinessObject with the WhereClause you provide and
> only returns the fields you specify. Its main purpose is to allow you
> to do quick queries against various BusinessObjects without the hassle
> of instantiating/disposing a BO and pulling in references, etc. It
> also saves you the performance hit inherent in returning a potentially
> large dataset when you only need a column or two.
>
> As for your other errors, it's probably best to handle them one at a time.
> If you'd like, post the errors you get when testing the code and the
> offending code and we'll just go through em one by one.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...>
> wrote:
>
> > **
>
> >
> >
> > John,
> > I was pointed to your blog and your example of adding a column to an
> > Epicor tracker. My programming background is not in C# or VB but the
> > logic normally makes sense and I am learning by example. The example
> > you have on your blog looks like it is pulling in another table for
> > the
> information.
> > The field I need is actually on the parttran table, it just is not
> > listed in the Collection for the dashboard. I am getting some errors
> > that I don't understand and was wondering if you could explain them
> > to me or point me in the right direction. First was the error I got
> > about the grid being a "static" grid. Why is this grid different
> > from the one in your blog? After I changed the grid to static, I got
> > errors on the BOReader statements and the grdMatLst statements. I
> > assume these are all related. Also the on the DataSet ds statement
> > with GetRows I
> thought the first parameter "APInvoice"
> > would be the table to read, "InvoiceNum=... would be the key, and
> > "InvoiceDate" would be the field getting pulled. But the APInvoice
> > table does not exist, APInvHed does.
> > I appreciate all of the help you guys have given me and I realize
> > this isn't your job. With that said, any additional help or pointers
> > would be appreciated.
> >
> > Thanks
> >
> > Mike
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 10:49 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > Just change:
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > To:
> > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > I don't understand that. How do I do it?
> > > Mike
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open
With"
> > > menus
> > >
> > > Your grid needs to be static.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > <mnumbers@...>
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I am getting a compile error after adding the first 2 lines of code.
> > > >
> > > > //**************************************************
> > > >
> > > > // Custom C# code for PartTranHistForm
> > > >
> > > > // Created: 10/17/2012 10:11:20 AM
> > > >
> > > > //**************************************************
> > > >
> > > > using System;
> > > >
> > > > using System.Data;
> > > >
> > > > using System.Diagnostics;
> > > >
> > > > using System.Windows.Forms;
> > > >
> > > > using System.ComponentModel;
> > > >
> > > > using Epicor.Mfg.UI;
> > > >
> > > > using Epicor.Mfg.UI.FrameWork;
> > > >
> > > > using Epicor.Mfg.UI.ExtendedProps;
> > > >
> > > > using Epicor.Mfg.UI.FormFunctions;
> > > >
> > > > using Epicor.Mfg.UI.Customization;
> > > >
> > > > using Epicor.Mfg.UI.Adapters;
> > > >
> > > > using Epicor.Mfg.UI.Searches;
> > > >
> > > > using Epicor.Mfg.BO;
> > > >
> > > > public static class Script
> > > >
> > > > {
> > > >
> > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > Added Module Level Variables' Comments! **
> > > >
> > > > // Begin Wizard Added Module Level Variables **
> > > >
> > > > // End Wizard Added Module Level Variables **
> > > >
> > > > // Add Custom Module Level Variables Here **
> > > >
> > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > >
> > > > public static void InitializeCustomCode()
> > > >
> > > > {
> > > >
> > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > Added Variable Initialization' lines **
> > > >
> > > > // Begin Wizard Added Variable
> > > > Initialization
> > > >
> > > > // End Wizard Added Variable Initialization
> > > >
> > > > // Begin Wizard Added Custom Method Calls
> > > >
> > > > // End Wizard Added Custom Method Calls
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > >
> > > > }
> > > >
> > > > public static void DestroyCustomCode()
> > > >
> > > > {
> > > >
> > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > Added Object Disposal' lines **
> > > >
> > > > // Begin Wizard Added Object Disposal
> > > >
> > > > // End Wizard Added Object Disposal
> > > >
> > > > // Begin Custom Code Disposal
> > > >
> > > > // End Custom Code Disposal
> > > >
> > > > }
> > > >
> > > > }
> > > >
> > > > -------------------
> > > >
> > > > Compiling Custom Code ...
> > > >
> > > > ----------errors------------
> > > >
> > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > > > instance members in a static class
> > > >
> > > > ** Compile Failed. **
> > > >
> > > > Any ideas on what I did wrong here? I copied from the Part
> > > > Transaction History Tracker.
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > On Behalf Of Ted Koch
> > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > "Open
> With"
> > > > menus
> > > >
> > > > You can add not a column to the collection. Check this.
> > > >
> > > >
> > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epi
> > > > co
> > > > r-
> > > > sp
> > > > ecific
> > > > ally-to-chart-tracker/
> > > >
> > > > ________________________________
> > > > From: mike.numbers <mnumbers@...
> > > > <mailto:mnumbers%40cignys.com>
> > > > >
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > Subject: [Vantage] How do I add a custom program to the "Open With"
> > > > menus
> > > >
> > > > I had to create a custom dashboard version of Part Transaction
> > > > History because a field we needed was not part of the collection.
> > > > How do I add my new version of this to all of the "Open With"
> > > > menus that currently have the Epicor version of this program?
> > > > 9.04.507a
> > > >
> > > > Mike
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > > must have already linked your email address to a yahoo id to
> > > > enable
> > access.
> > > > )
> > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > Builder and Crystal Reports and other 'goodies', please goto:
> > > > http://groups.yahoo.com/group/vantage/files/.
> > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > (2) To search through old msg's goto:
> > > > http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > > [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]



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

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
You need to maky any and all declarations and functions static as such, do
that for EVERY function.


private static void grdMstLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)

*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Oct 17, 2012 at 2:42 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I had to add Epicor.Mfg.Lib.IBOReader.dll and
> Epicor.Mfg.Core.BLConnectionPool.dll.
>
> I uncommented the other statements and am now receiving the following
> message.
>
>
> Compiling Custom Code ...
>
> ----------errors------------
>
> Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot declare
>
> instance members in a static class
>
> ** Compile Failed. **
> Line 53 = private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
>
> I tried putting static in front of grdMstLst but received another error so
> I
> took it back out.
> See code below:
>
>
> //**************************************************
> // Custom C# code for PartTranHistForm
> // Created: 10/17/2012 10:11:20 AM
> //**************************************************
> using System;
> using System.Data;
> using System.Diagnostics;
> using System.Windows.Forms;
> using System.ComponentModel;
> using Epicor.Mfg.UI;
> using Epicor.Mfg.UI.FrameWork;
> using Epicor.Mfg.UI.ExtendedProps;
> using Epicor.Mfg.UI.FormFunctions;
> using Epicor.Mfg.UI.Customization;
> using Epicor.Mfg.UI.Adapters;
> using Epicor.Mfg.UI.Searches;
> using Epicor.Mfg.BO;
> using Epicor.Mfg.Core;
> using Epicor.Mfg.Lib;
>
> public static class Script
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> Module Level Variables' Comments! **
> // Begin Wizard Added Module Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here **
> static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> static BOReader _boReader;
>
>
> public static void InitializeCustomCode()
> {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End
> Wizard Added Variable Initialization' lines **
> // Begin Wizard Added Variable Initialization
>
> // End Wizard Added Variable Initialization
> // Begin Wizard Added Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> Number");
> myGrid.InitializeRow += new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
> Row);
> _boReader = new
> BOReader(((Session)oTrans.Session).ConnectionPool);
>
>
> }
> private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> {
>
>
> }
> public static void DestroyCustomCode()
> {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End
> Wizard Added Object Disposal' lines **
> // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
> //myGrid.InitializeRow -= new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
> Row);
>
> }
>
> }
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> John Driggers
> Sent: Wednesday, October 17, 2012 2:10 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Set your BO reader as static as we did with the grid. That should sort that
> out.
>
> I noticed that you commented out the sections where you were wiring up the
> eventhandler on the grid. Assuming this fixes your BOReader issue, let's
> uncomment those next and see what we get.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...> wrote:
>
> > **
> >
> >
> > Thanks again for your help.
> >
> > Below is my code. I have commented out statements that were giving me
> > errors. I eventually stopped following your example and sent you my
> > previous email. I uncommented the BOReader statements and tested my code.
> > The error is at the bottom.
> >
> >
> > //**************************************************
> > // Custom C# code for PartTranHistForm // Created: 10/17/2012 10:11:20
> > AM
> > //**************************************************
> > using System;
> > using System.Data;
> > using System.Diagnostics;
> > using System.Windows.Forms;
> > using System.ComponentModel;
> > using Epicor.Mfg.UI;
> > using Epicor.Mfg.UI.FrameWork;
> > using Epicor.Mfg.UI.ExtendedProps;
> > using Epicor.Mfg.UI.FormFunctions;
> > using Epicor.Mfg.UI.Customization;
> > using Epicor.Mfg.UI.Adapters;
> > using Epicor.Mfg.UI.Searches;
> > using Epicor.Mfg.BO;
> > using Epicor.Mfg.Core;
> > using Epicor.Mfg.Lib;
> >
> >
> > public static class Script
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here ** static
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
> >
> >
> > public static void InitializeCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines ** // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization // Begin Wizard Added
> > Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > Number");
> > //myGrid.InitializeRow += new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> > ialize
> > Row);
> > _boReader = new
> > BOReader(((Session)oTrans.Session).ConnectionPool);
> >
> >
> > }
> > //private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
> >
> > //}
> >
> > public static void DestroyCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> > //myGrid.InitializeRow -= new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> > ialize
> > Row);
> >
> > }
> >
> > }
> > ----------errors------------
> >
> > Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> > instance
> >
> > members in a static class
> >
> > ** Compile Failed. **
> > FYI
> > Line 34 = BOReader _boReader;
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 1:14 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > We're always happy to help!
> >
> > Without looking deeper into it, I'm not sure why the grid is different
> > in our code. That form could work a bit differently, or maybe it's
> > just an error in the code we posted.
> >
> > The main purpose of the code in our example is to pull values from
> > other tables. Generally the Epicor dataviews contain all the fields
> > from a given table, but if that isn't the case for this scenario, the
> > code should still do the job.
> >
> > Regarding the BOReader, the first parameter is the BusinessObject you
> > want to use, not the table. BOReader basically calls the 'GetRows'
> > method on that BusinessObject with the WhereClause you provide and
> > only returns the fields you specify. Its main purpose is to allow you
> > to do quick queries against various BusinessObjects without the hassle
> > of instantiating/disposing a BO and pulling in references, etc. It
> > also saves you the performance hit inherent in returning a potentially
> > large dataset when you only need a column or two.
> >
> > As for your other errors, it's probably best to handle them one at a
> time.
> > If you'd like, post the errors you get when testing the code and the
> > offending code and we'll just go through em one by one.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > John,
> > > I was pointed to your blog and your example of adding a column to an
> > > Epicor tracker. My programming background is not in C# or VB but the
> > > logic normally makes sense and I am learning by example. The example
> > > you have on your blog looks like it is pulling in another table for
> > > the
> > information.
> > > The field I need is actually on the parttran table, it just is not
> > > listed in the Collection for the dashboard. I am getting some errors
> > > that I don't understand and was wondering if you could explain them
> > > to me or point me in the right direction. First was the error I got
> > > about the grid being a "static" grid. Why is this grid different
> > > from the one in your blog? After I changed the grid to static, I got
> > > errors on the BOReader statements and the grdMatLst statements. I
> > > assume these are all related. Also the on the DataSet ds statement
> > > with GetRows I
> > thought the first parameter "APInvoice"
> > > would be the table to read, "InvoiceNum=... would be the key, and
> > > "InvoiceDate" would be the field getting pulled. But the APInvoice
> > > table does not exist, APInvHed does.
> > > I appreciate all of the help you guys have given me and I realize
> > > this isn't your job. With that said, any additional help or pointers
> > > would be appreciated.
> > >
> > > Thanks
> > >
> > > Mike
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 10:49 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > > menus
> > >
> > > Just change:
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > To:
> > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers <mnumbers@...>
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I don't understand that. How do I do it?
> > > > Mike
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > Behalf Of John Driggers
> > > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the "Open
> With"
> > > > menus
> > > >
> > > > Your grid needs to be static.
> > > >
> > > > *John Driggers*
> > > > **
> > > > *Chief Data Wrangler*
> > > > *
> > > > *
> > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > that?*
> > > > *
> > > > *:: 904.404.9233
> > > > :: waffqle@...
> > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > >
> > > > *
> > > >
> > > >
> > > > *
> > > >
> > > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > > <mnumbers@...>
> > > > wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > I am getting a compile error after adding the first 2 lines of
> code.
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > // Custom C# code for PartTranHistForm
> > > > >
> > > > > // Created: 10/17/2012 10:11:20 AM
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > using System;
> > > > >
> > > > > using System.Data;
> > > > >
> > > > > using System.Diagnostics;
> > > > >
> > > > > using System.Windows.Forms;
> > > > >
> > > > > using System.ComponentModel;
> > > > >
> > > > > using Epicor.Mfg.UI;
> > > > >
> > > > > using Epicor.Mfg.UI.FrameWork;
> > > > >
> > > > > using Epicor.Mfg.UI.ExtendedProps;
> > > > >
> > > > > using Epicor.Mfg.UI.FormFunctions;
> > > > >
> > > > > using Epicor.Mfg.UI.Customization;
> > > > >
> > > > > using Epicor.Mfg.UI.Adapters;
> > > > >
> > > > > using Epicor.Mfg.UI.Searches;
> > > > >
> > > > > using Epicor.Mfg.BO;
> > > > >
> > > > > public static class Script
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > > Added Module Level Variables' Comments! **
> > > > >
> > > > > // Begin Wizard Added Module Level Variables **
> > > > >
> > > > > // End Wizard Added Module Level Variables **
> > > > >
> > > > > // Add Custom Module Level Variables Here **
> > > > >
> > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > >
> > > > > public static void InitializeCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Variable Initialization' lines **
> > > > >
> > > > > // Begin Wizard Added Variable
> > > > > Initialization
> > > > >
> > > > > // End Wizard Added Variable Initialization
> > > > >
> > > > > // Begin Wizard Added Custom Method Calls
> > > > >
> > > > > // End Wizard Added Custom Method Calls
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > >
> > > > > }
> > > > >
> > > > > public static void DestroyCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Object Disposal' lines **
> > > > >
> > > > > // Begin Wizard Added Object Disposal
> > > > >
> > > > > // End Wizard Added Object Disposal
> > > > >
> > > > > // Begin Custom Code Disposal
> > > > >
> > > > > // End Custom Code Disposal
> > > > >
> > > > > }
> > > > >
> > > > > }
> > > > >
> > > > > -------------------
> > > > >
> > > > > Compiling Custom Code ...
> > > > >
> > > > > ----------errors------------
> > > > >
> > > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot declare
> > > > > instance members in a static class
> > > > >
> > > > > ** Compile Failed. **
> > > > >
> > > > > Any ideas on what I did wrong here? I copied from the Part
> > > > > Transaction History Tracker.
> > > > >
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > On Behalf Of Ted Koch
> > > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > "Open
> > With"
> > > > > menus
> > > > >
> > > > > You can add not a column to the collection. Check this.
> > > > >
> > > > >
> > > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epi
> > > > > co
> > > > > r-
> > > > > sp
> > > > > ecific
> > > > > ally-to-chart-tracker/
> > > > >
> > > > > ________________________________
> > > > > From: mike.numbers <mnumbers@...
> > > > > <mailto:mnumbers%40cignys.com>
> > > > > >
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > > Subject: [Vantage] How do I add a custom program to the "Open With"
> > > > > menus
> > > > >
> > > > > I had to create a custom dashboard version of Part Transaction
> > > > > History because a field we needed was not part of the collection.
> > > > > How do I add my new version of this to all of the "Open With"
> > > > > menus that currently have the Epicor version of this program?
> > > > > 9.04.507a
> > > > >
> > > > > Mike
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > > > must have already linked your email address to a yahoo id to
> > > > > enable
> > > access.
> > > > > )
> > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > > Builder and Crystal Reports and other 'goodies', please goto:
> > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > (2) To search through old msg's goto:
> > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > > [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]
>
> ------------------------------------
>
> 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]
I am no longer getting errors. I need some help with the DataSet
statement. If I understand correctly the format is:
DataSet ds = _boReader.GetRows("business object","where clause","returned
field");

How do I find the business object for PartTran?
I don't understand the format on the example you have in the Chart Tracker
example for the Where clause. Somehow we need to use the company/trannum
for the row.
The returned field should be "DMRNum".

Hopefully this will be the final question.

Thanks again.
Mike


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Wednesday, October 17, 2012 2:46 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

You need to maky any and all declarations and functions static as such, do
that for EVERY function.


private static void grdMstLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)

*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Oct 17, 2012 at 2:42 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I had to add Epicor.Mfg.Lib.IBOReader.dll and
> Epicor.Mfg.Core.BLConnectionPool.dll.
>
> I uncommented the other statements and am now receiving the following
> message.
>
>
> Compiling Custom Code ...
>
> ----------errors------------
>
> Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot
> declare
>
> instance members in a static class
>
> ** Compile Failed. **
> Line 53 = private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
>
> I tried putting static in front of grdMstLst but received another
> error so I took it back out.
> See code below:
>
>
> //**************************************************
> // Custom C# code for PartTranHistForm // Created: 10/17/2012 10:11:20
> AM
> //**************************************************
> using System;
> using System.Data;
> using System.Diagnostics;
> using System.Windows.Forms;
> using System.ComponentModel;
> using Epicor.Mfg.UI;
> using Epicor.Mfg.UI.FrameWork;
> using Epicor.Mfg.UI.ExtendedProps;
> using Epicor.Mfg.UI.FormFunctions;
> using Epicor.Mfg.UI.Customization;
> using Epicor.Mfg.UI.Adapters;
> using Epicor.Mfg.UI.Searches;
> using Epicor.Mfg.BO;
> using Epicor.Mfg.Core;
> using Epicor.Mfg.Lib;
>
> public static class Script
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> Module Level Variables' Comments! ** // Begin Wizard Added Module
> Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here ** static
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; static BOReader
> _boReader;
>
>
> public static void InitializeCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Variable Initialization' lines ** // Begin Wizard Added Variable
> Initialization
>
> // End Wizard Added Variable Initialization // Begin Wizard Added
> Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> Number");
> myGrid.InitializeRow += new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
> _boReader = new
> BOReader(((Session)oTrans.Session).ConnectionPool);
>
>
> }
> private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) {
>
>
> }
> public static void DestroyCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Object Disposal' lines ** // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
> //myGrid.InitializeRow -= new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
>
> }
>
> }
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of John Driggers
> Sent: Wednesday, October 17, 2012 2:10 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Set your BO reader as static as we did with the grid. That should sort
> that out.
>
> I noticed that you commented out the sections where you were wiring up
> the eventhandler on the grid. Assuming this fixes your BOReader issue,
> let's uncomment those next and see what we get.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...> wrote:
>
> > **
> >
> >
> > Thanks again for your help.
> >
> > Below is my code. I have commented out statements that were giving
> > me errors. I eventually stopped following your example and sent you
> > my previous email. I uncommented the BOReader statements and tested my
code.
> > The error is at the bottom.
> >
> >
> > //**************************************************
> > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > 10:11:20 AM
> > //**************************************************
> > using System;
> > using System.Data;
> > using System.Diagnostics;
> > using System.Windows.Forms;
> > using System.ComponentModel;
> > using Epicor.Mfg.UI;
> > using Epicor.Mfg.UI.FrameWork;
> > using Epicor.Mfg.UI.ExtendedProps;
> > using Epicor.Mfg.UI.FormFunctions;
> > using Epicor.Mfg.UI.Customization;
> > using Epicor.Mfg.UI.Adapters;
> > using Epicor.Mfg.UI.Searches;
> > using Epicor.Mfg.BO;
> > using Epicor.Mfg.Core;
> > using Epicor.Mfg.Lib;
> >
> >
> > public static class Script
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here ** static
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
> >
> >
> > public static void InitializeCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines ** // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization // Begin Wizard Added
> > Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > Number");
> > //myGrid.InitializeRow += new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> > _boReader = new
> > BOReader(((Session)oTrans.Session).ConnectionPool);
> >
> >
> > }
> > //private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
> >
> > //}
> >
> > public static void DestroyCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> > //myGrid.InitializeRow -= new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> >
> > }
> >
> > }
> > ----------errors------------
> >
> > Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> > instance
> >
> > members in a static class
> >
> > ** Compile Failed. **
> > FYI
> > Line 34 = BOReader _boReader;
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 1:14 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > We're always happy to help!
> >
> > Without looking deeper into it, I'm not sure why the grid is
> > different in our code. That form could work a bit differently, or
> > maybe it's just an error in the code we posted.
> >
> > The main purpose of the code in our example is to pull values from
> > other tables. Generally the Epicor dataviews contain all the fields
> > from a given table, but if that isn't the case for this scenario,
> > the code should still do the job.
> >
> > Regarding the BOReader, the first parameter is the BusinessObject
> > you want to use, not the table. BOReader basically calls the 'GetRows'
> > method on that BusinessObject with the WhereClause you provide and
> > only returns the fields you specify. Its main purpose is to allow
> > you to do quick queries against various BusinessObjects without the
> > hassle of instantiating/disposing a BO and pulling in references,
> > etc. It also saves you the performance hit inherent in returning a
> > potentially large dataset when you only need a column or two.
> >
> > As for your other errors, it's probably best to handle them one at a
> time.
> > If you'd like, post the errors you get when testing the code and the
> > offending code and we'll just go through em one by one.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > John,
> > > I was pointed to your blog and your example of adding a column to
> > > an Epicor tracker. My programming background is not in C# or VB
> > > but the logic normally makes sense and I am learning by example.
> > > The example you have on your blog looks like it is pulling in
> > > another table for the
> > information.
> > > The field I need is actually on the parttran table, it just is not
> > > listed in the Collection for the dashboard. I am getting some
> > > errors that I don't understand and was wondering if you could
> > > explain them to me or point me in the right direction. First was
> > > the error I got about the grid being a "static" grid. Why is this
> > > grid different from the one in your blog? After I changed the grid
> > > to static, I got errors on the BOReader statements and the
> > > grdMatLst statements. I assume these are all related. Also the on
> > > the DataSet ds statement with GetRows I
> > thought the first parameter "APInvoice"
> > > would be the table to read, "InvoiceNum=... would be the key, and
> > > "InvoiceDate" would be the field getting pulled. But the APInvoice
> > > table does not exist, APInvHed does.
> > > I appreciate all of the help you guys have given me and I realize
> > > this isn't your job. With that said, any additional help or
> > > pointers would be appreciated.
> > >
> > > Thanks
> > >
> > > Mike
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 10:49 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open
With"
> > > menus
> > >
> > > Just change:
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > To:
> > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers
> > > <mnumbers@...>
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I don't understand that. How do I do it?
> > > > Mike
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > On Behalf Of John Driggers
> > > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > "Open
> With"
> > > > menus
> > > >
> > > > Your grid needs to be static.
> > > >
> > > > *John Driggers*
> > > > **
> > > > *Chief Data Wrangler*
> > > > *
> > > > *
> > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > that?*
> > > > *
> > > > *:: 904.404.9233
> > > > :: waffqle@...
> > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > >
> > > > *
> > > >
> > > >
> > > > *
> > > >
> > > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > > <mnumbers@...>
> > > > wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > I am getting a compile error after adding the first 2 lines of
> code.
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > // Custom C# code for PartTranHistForm
> > > > >
> > > > > // Created: 10/17/2012 10:11:20 AM
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > using System;
> > > > >
> > > > > using System.Data;
> > > > >
> > > > > using System.Diagnostics;
> > > > >
> > > > > using System.Windows.Forms;
> > > > >
> > > > > using System.ComponentModel;
> > > > >
> > > > > using Epicor.Mfg.UI;
> > > > >
> > > > > using Epicor.Mfg.UI.FrameWork;
> > > > >
> > > > > using Epicor.Mfg.UI.ExtendedProps;
> > > > >
> > > > > using Epicor.Mfg.UI.FormFunctions;
> > > > >
> > > > > using Epicor.Mfg.UI.Customization;
> > > > >
> > > > > using Epicor.Mfg.UI.Adapters;
> > > > >
> > > > > using Epicor.Mfg.UI.Searches;
> > > > >
> > > > > using Epicor.Mfg.BO;
> > > > >
> > > > > public static class Script
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > > Added Module Level Variables' Comments! **
> > > > >
> > > > > // Begin Wizard Added Module Level Variables **
> > > > >
> > > > > // End Wizard Added Module Level Variables **
> > > > >
> > > > > // Add Custom Module Level Variables Here **
> > > > >
> > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > >
> > > > > public static void InitializeCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Variable Initialization' lines **
> > > > >
> > > > > // Begin Wizard Added Variable Initialization
> > > > >
> > > > > // End Wizard Added Variable Initialization
> > > > >
> > > > > // Begin Wizard Added Custom Method Calls
> > > > >
> > > > > // End Wizard Added Custom Method Calls
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > >
> > > > > }
> > > > >
> > > > > public static void DestroyCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Object Disposal' lines **
> > > > >
> > > > > // Begin Wizard Added Object Disposal
> > > > >
> > > > > // End Wizard Added Object Disposal
> > > > >
> > > > > // Begin Custom Code Disposal
> > > > >
> > > > > // End Custom Code Disposal
> > > > >
> > > > > }
> > > > >
> > > > > }
> > > > >
> > > > > -------------------
> > > > >
> > > > > Compiling Custom Code ...
> > > > >
> > > > > ----------errors------------
> > > > >
> > > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot
> > > > > declare instance members in a static class
> > > > >
> > > > > ** Compile Failed. **
> > > > >
> > > > > Any ideas on what I did wrong here? I copied from the Part
> > > > > Transaction History Tracker.
> > > > >
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > On Behalf Of Ted Koch
> > > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > "Open
> > With"
> > > > > menus
> > > > >
> > > > > You can add not a column to the collection. Check this.
> > > > >
> > > > >
> > > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-e
> > > > > pi
> > > > > co
> > > > > r-
> > > > > sp
> > > > > ecific
> > > > > ally-to-chart-tracker/
> > > > >
> > > > > ________________________________
> > > > > From: mike.numbers <mnumbers@...
> > > > > <mailto:mnumbers%40cignys.com>
> > > > > >
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > > Subject: [Vantage] How do I add a custom program to the "Open
With"
> > > > > menus
> > > > >
> > > > > I had to create a custom dashboard version of Part Transaction
> > > > > History because a field we needed was not part of the collection.
> > > > > How do I add my new version of this to all of the "Open With"
> > > > > menus that currently have the Epicor version of this program?
> > > > > 9.04.507a
> > > > >
> > > > > Mike
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> > > > > You must have already linked your email address to a yahoo id
> > > > > to enable
> > > access.
> > > > > )
> > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > > Builder and Crystal Reports and other 'goodies', please goto:
> > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > (2) To search through old msg's goto:
> > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > > [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]
>
> ------------------------------------
>
> 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
To find the Adapter use Object Explorer go to Adapters and Scroll down till
you find it

*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Oct 17, 2012 at 3:29 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I am no longer getting errors. I need some help with the DataSet
> statement. If I understand correctly the format is:
> DataSet ds = _boReader.GetRows("business object","where clause","returned
> field");
>
> How do I find the business object for PartTran?
> I don't understand the format on the example you have in the Chart Tracker
> example for the Where clause. Somehow we need to use the company/trannum
> for the row.
> The returned field should be "DMRNum".
>
> Hopefully this will be the final question.
>
> Thanks again.
>
> Mike
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> Jose Gomez
> Sent: Wednesday, October 17, 2012 2:46 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> You need to maky any and all declarations and functions static as such, do
> that for EVERY function.
>
> private static void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Wed, Oct 17, 2012 at 2:42 PM, Mike Numbers <mnumbers@...> wrote:
>
> > **
>
> >
> >
> > I had to add Epicor.Mfg.Lib.IBOReader.dll and
> > Epicor.Mfg.Core.BLConnectionPool.dll.
> >
> > I uncommented the other statements and am now receiving the following
> > message.
> >
> >
> > Compiling Custom Code ...
> >
> > ----------errors------------
> >
> > Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot
> > declare
> >
> > instance members in a static class
> >
> > ** Compile Failed. **
> > Line 53 = private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> >
> > I tried putting static in front of grdMstLst but received another
> > error so I took it back out.
> > See code below:
> >
> >
> > //**************************************************
> > // Custom C# code for PartTranHistForm // Created: 10/17/2012 10:11:20
> > AM
> > //**************************************************
> > using System;
> > using System.Data;
> > using System.Diagnostics;
> > using System.Windows.Forms;
> > using System.ComponentModel;
> > using Epicor.Mfg.UI;
> > using Epicor.Mfg.UI.FrameWork;
> > using Epicor.Mfg.UI.ExtendedProps;
> > using Epicor.Mfg.UI.FormFunctions;
> > using Epicor.Mfg.UI.Customization;
> > using Epicor.Mfg.UI.Adapters;
> > using Epicor.Mfg.UI.Searches;
> > using Epicor.Mfg.BO;
> > using Epicor.Mfg.Core;
> > using Epicor.Mfg.Lib;
> >
> > public static class Script
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here ** static
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; static BOReader
> > _boReader;
> >
> >
> > public static void InitializeCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines ** // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization // Begin Wizard Added
> > Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > Number");
> > myGrid.InitializeRow += new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> > ialize
> > Row);
> > _boReader = new
> > BOReader(((Session)oTrans.Session).ConnectionPool);
> >
> >
> > }
> > private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) {
> >
> >
> > }
> > public static void DestroyCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> > //myGrid.InitializeRow -= new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> > ialize
> > Row);
> >
> > }
> >
> > }
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 2:10 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > Set your BO reader as static as we did with the grid. That should sort
> > that out.
> >
> > I noticed that you commented out the sections where you were wiring up
> > the eventhandler on the grid. Assuming this fixes your BOReader issue,
> > let's uncomment those next and see what we get.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...>
> wrote:
> >
> > > **
> > >
> > >
> > > Thanks again for your help.
> > >
> > > Below is my code. I have commented out statements that were giving
> > > me errors. I eventually stopped following your example and sent you
> > > my previous email. I uncommented the BOReader statements and tested my
> code.
> > > The error is at the bottom.
> > >
> > >
> > > //**************************************************
> > > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > > 10:11:20 AM
> > > //**************************************************
> > > using System;
> > > using System.Data;
> > > using System.Diagnostics;
> > > using System.Windows.Forms;
> > > using System.ComponentModel;
> > > using Epicor.Mfg.UI;
> > > using Epicor.Mfg.UI.FrameWork;
> > > using Epicor.Mfg.UI.ExtendedProps;
> > > using Epicor.Mfg.UI.FormFunctions;
> > > using Epicor.Mfg.UI.Customization;
> > > using Epicor.Mfg.UI.Adapters;
> > > using Epicor.Mfg.UI.Searches;
> > > using Epicor.Mfg.BO;
> > > using Epicor.Mfg.Core;
> > > using Epicor.Mfg.Lib;
> > >
> > >
> > > public static class Script
> > > {
> > >
> > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > > Level Variables **
> > >
> > > // End Wizard Added Module Level Variables **
> > >
> > > // Add Custom Module Level Variables Here ** static
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
> > >
> > >
> > > public static void InitializeCustomCode() {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > > Variable Initialization' lines ** // Begin Wizard Added Variable
> > > Initialization
> > >
> > > // End Wizard Added Variable Initialization // Begin Wizard Added
> > > Custom Method Calls
> > >
> > > // End Wizard Added Custom Method Calls
> > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > > Number");
> > > //myGrid.InitializeRow += new
> > >
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > > it
> > > ialize
> > > Row);
> > > _boReader = new
> > > BOReader(((Session)oTrans.Session).ConnectionPool);
> > >
> > >
> > > }
> > > //private void grdMstLst_InitializeRow(object sender,
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
> > >
> > > //}
> > >
> > > public static void DestroyCustomCode() {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> > >
> > > // End Wizard Added Object Disposal
> > > // Begin Custom Code Disposal
> > >
> > > // End Custom Code Disposal
> > > //myGrid.InitializeRow -= new
> > >
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > > it
> > > ialize
> > > Row);
> > >
> > > }
> > >
> > > }
> > > ----------errors------------
> > >
> > > Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> > > instance
> > >
> > > members in a static class
> > >
> > > ** Compile Failed. **
> > > FYI
> > > Line 34 = BOReader _boReader;
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 1:14 PM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > > menus
> > >
> > > We're always happy to help!
> > >
> > > Without looking deeper into it, I'm not sure why the grid is
> > > different in our code. That form could work a bit differently, or
> > > maybe it's just an error in the code we posted.
> > >
> > > The main purpose of the code in our example is to pull values from
> > > other tables. Generally the Epicor dataviews contain all the fields
> > > from a given table, but if that isn't the case for this scenario,
> > > the code should still do the job.
> > >
> > > Regarding the BOReader, the first parameter is the BusinessObject
> > > you want to use, not the table. BOReader basically calls the 'GetRows'
> > > method on that BusinessObject with the WhereClause you provide and
> > > only returns the fields you specify. Its main purpose is to allow
> > > you to do quick queries against various BusinessObjects without the
> > > hassle of instantiating/disposing a BO and pulling in references,
> > > etc. It also saves you the performance hit inherent in returning a
> > > potentially large dataset when you only need a column or two.
> > >
> > > As for your other errors, it's probably best to handle them one at a
> > time.
> > > If you'd like, post the errors you get when testing the code and the
> > > offending code and we'll just go through em one by one.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...>
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > John,
> > > > I was pointed to your blog and your example of adding a column to
> > > > an Epicor tracker. My programming background is not in C# or VB
> > > > but the logic normally makes sense and I am learning by example.
> > > > The example you have on your blog looks like it is pulling in
> > > > another table for the
> > > information.
> > > > The field I need is actually on the parttran table, it just is not
> > > > listed in the Collection for the dashboard. I am getting some
> > > > errors that I don't understand and was wondering if you could
> > > > explain them to me or point me in the right direction. First was
> > > > the error I got about the grid being a "static" grid. Why is this
> > > > grid different from the one in your blog? After I changed the grid
> > > > to static, I got errors on the BOReader statements and the
> > > > grdMatLst statements. I assume these are all related. Also the on
> > > > the DataSet ds statement with GetRows I
> > > thought the first parameter "APInvoice"
> > > > would be the table to read, "InvoiceNum=... would be the key, and
> > > > "InvoiceDate" would be the field getting pulled. But the APInvoice
> > > > table does not exist, APInvHed does.
> > > > I appreciate all of the help you guys have given me and I realize
> > > > this isn't your job. With that said, any additional help or
> > > > pointers would be appreciated.
> > > >
> > > > Thanks
> > > >
> > > > Mike
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > Behalf Of John Driggers
> > > > Sent: Wednesday, October 17, 2012 10:49 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the "Open
> With"
> > > > menus
> > > >
> > > > Just change:
> > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > To:
> > > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > >
> > > > *John Driggers*
> > > > **
> > > > *Chief Data Wrangler*
> > > > *
> > > > *
> > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > that?*
> > > > *
> > > > *:: 904.404.9233
> > > > :: waffqle@...
> > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers
> > > > <mnumbers@...>
> > > > wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > I don't understand that. How do I do it?
> > > > > Mike
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > On Behalf Of John Driggers
> > > > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > "Open
> > With"
> > > > > menus
> > > > >
> > > > > Your grid needs to be static.
> > > > >
> > > > > *John Driggers*
> > > > > **
> > > > > *Chief Data Wrangler*
> > > > > *
> > > > > *
> > > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > > that?*
> > > > > *
> > > > > *:: 904.404.9233
> > > > > :: waffqle@...
> > > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > > >
> > > > > *
> > > > >
> > > > >
> > > > > *
> > > > >
> > > > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > > > <mnumbers@...>
> > > > > wrote:
> > > > >
> > > > > > **
> > > > >
> > > > > >
> > > > > >
> > > > > > I am getting a compile error after adding the first 2 lines of
> > code.
> > > > > >
> > > > > > //**************************************************
> > > > > >
> > > > > > // Custom C# code for PartTranHistForm
> > > > > >
> > > > > > // Created: 10/17/2012 10:11:20 AM
> > > > > >
> > > > > > //**************************************************
> > > > > >
> > > > > > using System;
> > > > > >
> > > > > > using System.Data;
> > > > > >
> > > > > > using System.Diagnostics;
> > > > > >
> > > > > > using System.Windows.Forms;
> > > > > >
> > > > > > using System.ComponentModel;
> > > > > >
> > > > > > using Epicor.Mfg.UI;
> > > > > >
> > > > > > using Epicor.Mfg.UI.FrameWork;
> > > > > >
> > > > > > using Epicor.Mfg.UI.ExtendedProps;
> > > > > >
> > > > > > using Epicor.Mfg.UI.FormFunctions;
> > > > > >
> > > > > > using Epicor.Mfg.UI.Customization;
> > > > > >
> > > > > > using Epicor.Mfg.UI.Adapters;
> > > > > >
> > > > > > using Epicor.Mfg.UI.Searches;
> > > > > >
> > > > > > using Epicor.Mfg.BO;
> > > > > >
> > > > > > public static class Script
> > > > > >
> > > > > > {
> > > > > >
> > > > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > > > Added Module Level Variables' Comments! **
> > > > > >
> > > > > > // Begin Wizard Added Module Level Variables **
> > > > > >
> > > > > > // End Wizard Added Module Level Variables **
> > > > > >
> > > > > > // Add Custom Module Level Variables Here **
> > > > > >
> > > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > > >
> > > > > > public static void InitializeCustomCode()
> > > > > >
> > > > > > {
> > > > > >
> > > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > > Added Variable Initialization' lines **
> > > > > >
> > > > > > // Begin Wizard Added Variable Initialization
> > > > > >
> > > > > > // End Wizard Added Variable Initialization
> > > > > >
> > > > > > // Begin Wizard Added Custom Method Calls
> > > > > >
> > > > > > // End Wizard Added Custom Method Calls
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > > >
> > > > > > }
> > > > > >
> > > > > > public static void DestroyCustomCode()
> > > > > >
> > > > > > {
> > > > > >
> > > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > > Added Object Disposal' lines **
> > > > > >
> > > > > > // Begin Wizard Added Object Disposal
> > > > > >
> > > > > > // End Wizard Added Object Disposal
> > > > > >
> > > > > > // Begin Custom Code Disposal
> > > > > >
> > > > > > // End Custom Code Disposal
> > > > > >
> > > > > > }
> > > > > >
> > > > > > }
> > > > > >
> > > > > > -------------------
> > > > > >
> > > > > > Compiling Custom Code ...
> > > > > >
> > > > > > ----------errors------------
> > > > > >
> > > > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot
> > > > > > declare instance members in a static class
> > > > > >
> > > > > > ** Compile Failed. **
> > > > > >
> > > > > > Any ideas on what I did wrong here? I copied from the Part
> > > > > > Transaction History Tracker.
> > > > > >
> > > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > > On Behalf Of Ted Koch
> > > > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > > > To: vantage@yahoogroups.com
> > > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > > "Open
> > > With"
> > > > > > menus
> > > > > >
> > > > > > You can add not a column to the collection. Check this.
> > > > > >
> > > > > >
> > > > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-e
> > > > > > pi
> > > > > > co
> > > > > > r-
> > > > > > sp
> > > > > > ecific
> > > > > > ally-to-chart-tracker/
> > > > > >
> > > > > > ________________________________
> > > > > > From: mike.numbers <mnumbers@...
> > > > > > <mailto:mnumbers%40cignys.com>
> > > > > > >
> > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > > > Subject: [Vantage] How do I add a custom program to the "Open
> With"
> > > > > > menus
> > > > > >
> > > > > > I had to create a custom dashboard version of Part Transaction
> > > > > > History because a field we needed was not part of the collection.
> > > > > > How do I add my new version of this to all of the "Open With"
> > > > > > menus that currently have the Epicor version of this program?
> > > > > > 9.04.507a
> > > > > >
> > > > > > Mike
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> > > > > > You must have already linked your email address to a yahoo id
> > > > > > to enable
> > > > access.
> > > > > > )
> > > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > > > Builder and Crystal Reports and other 'goodies', please goto:
> > > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > (2) To search through old msg's goto:
> > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > > [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]
> >
> > ------------------------------------
> >
> > 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]
Where do I find Object Explorer? Is it part of Epicor?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Wednesday, October 17, 2012 3:37 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

To find the Adapter use Object Explorer go to Adapters and Scroll down till
you find it

*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Oct 17, 2012 at 3:29 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I am no longer getting errors. I need some help with the DataSet
> statement. If I understand correctly the format is:
> DataSet ds = _boReader.GetRows("business object","where
> clause","returned field");
>
> How do I find the business object for PartTran?
> I don't understand the format on the example you have in the Chart
> Tracker example for the Where clause. Somehow we need to use the
> company/trannum for the row.
> The returned field should be "DMRNum".
>
> Hopefully this will be the final question.
>
> Thanks again.
>
> Mike
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Jose Gomez
> Sent: Wednesday, October 17, 2012 2:46 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> You need to maky any and all declarations and functions static as
> such, do that for EVERY function.
>
> private static void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Wed, Oct 17, 2012 at 2:42 PM, Mike Numbers <mnumbers@...> wrote:
>
> > **
>
> >
> >
> > I had to add Epicor.Mfg.Lib.IBOReader.dll and
> > Epicor.Mfg.Core.BLConnectionPool.dll.
> >
> > I uncommented the other statements and am now receiving the
> > following message.
> >
> >
> > Compiling Custom Code ...
> >
> > ----------errors------------
> >
> > Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot
> > declare
> >
> > instance members in a static class
> >
> > ** Compile Failed. **
> > Line 53 = private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> >
> > I tried putting static in front of grdMstLst but received another
> > error so I took it back out.
> > See code below:
> >
> >
> > //**************************************************
> > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > 10:11:20 AM
> > //**************************************************
> > using System;
> > using System.Data;
> > using System.Diagnostics;
> > using System.Windows.Forms;
> > using System.ComponentModel;
> > using Epicor.Mfg.UI;
> > using Epicor.Mfg.UI.FrameWork;
> > using Epicor.Mfg.UI.ExtendedProps;
> > using Epicor.Mfg.UI.FormFunctions;
> > using Epicor.Mfg.UI.Customization;
> > using Epicor.Mfg.UI.Adapters;
> > using Epicor.Mfg.UI.Searches;
> > using Epicor.Mfg.BO;
> > using Epicor.Mfg.Core;
> > using Epicor.Mfg.Lib;
> >
> > public static class Script
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here ** static
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; static BOReader
> > _boReader;
> >
> >
> > public static void InitializeCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines ** // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization // Begin Wizard Added
> > Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > Number");
> > myGrid.InitializeRow += new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> > _boReader = new
> > BOReader(((Session)oTrans.Session).ConnectionPool);
> >
> >
> > }
> > private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) {
> >
> >
> > }
> > public static void DestroyCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> > //myGrid.InitializeRow -= new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> >
> > }
> >
> > }
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 2:10 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > Set your BO reader as static as we did with the grid. That should
> > sort that out.
> >
> > I noticed that you commented out the sections where you were wiring
> > up the eventhandler on the grid. Assuming this fixes your BOReader
> > issue, let's uncomment those next and see what we get.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...>
> wrote:
> >
> > > **
> > >
> > >
> > > Thanks again for your help.
> > >
> > > Below is my code. I have commented out statements that were giving
> > > me errors. I eventually stopped following your example and sent
> > > you my previous email. I uncommented the BOReader statements and
> > > tested my
> code.
> > > The error is at the bottom.
> > >
> > >
> > > //**************************************************
> > > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > > 10:11:20 AM
> > > //**************************************************
> > > using System;
> > > using System.Data;
> > > using System.Diagnostics;
> > > using System.Windows.Forms;
> > > using System.ComponentModel;
> > > using Epicor.Mfg.UI;
> > > using Epicor.Mfg.UI.FrameWork;
> > > using Epicor.Mfg.UI.ExtendedProps; using
> > > Epicor.Mfg.UI.FormFunctions; using Epicor.Mfg.UI.Customization;
> > > using Epicor.Mfg.UI.Adapters; using Epicor.Mfg.UI.Searches; using
> > > Epicor.Mfg.BO; using Epicor.Mfg.Core; using Epicor.Mfg.Lib;
> > >
> > >
> > > public static class Script
> > > {
> > >
> > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > Added Module Level Variables' Comments! ** // Begin Wizard Added
> > > Module Level Variables **
> > >
> > > // End Wizard Added Module Level Variables **
> > >
> > > // Add Custom Module Level Variables Here ** static
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
> > >
> > >
> > > public static void InitializeCustomCode() {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > Added Variable Initialization' lines ** // Begin Wizard Added
> > > Variable Initialization
> > >
> > > // End Wizard Added Variable Initialization // Begin Wizard Added
> > > Custom Method Calls
> > >
> > > // End Wizard Added Custom Method Calls
> > >
> > >
> > >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > > Number");
> > > //myGrid.InitializeRow += new
> > >
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_
> > > In
> > > it
> > > ialize
> > > Row);
> > > _boReader = new
> > > BOReader(((Session)oTrans.Session).ConnectionPool);
> > >
> > >
> > > }
> > > //private void grdMstLst_InitializeRow(object sender,
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
> > >
> > > //}
> > >
> > > public static void DestroyCustomCode() {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > Added Object Disposal' lines ** // Begin Wizard Added Object
> > > Disposal
> > >
> > > // End Wizard Added Object Disposal // Begin Custom Code Disposal
> > >
> > > // End Custom Code Disposal
> > > //myGrid.InitializeRow -= new
> > >
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_
> > > In
> > > it
> > > ialize
> > > Row);
> > >
> > > }
> > >
> > > }
> > > ----------errors------------
> > >
> > > Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> > > instance
> > >
> > > members in a static class
> > >
> > > ** Compile Failed. **
> > > FYI
> > > Line 34 = BOReader _boReader;
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 1:14 PM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open
With"
> > > menus
> > >
> > > We're always happy to help!
> > >
> > > Without looking deeper into it, I'm not sure why the grid is
> > > different in our code. That form could work a bit differently, or
> > > maybe it's just an error in the code we posted.
> > >
> > > The main purpose of the code in our example is to pull values from
> > > other tables. Generally the Epicor dataviews contain all the
> > > fields from a given table, but if that isn't the case for this
> > > scenario, the code should still do the job.
> > >
> > > Regarding the BOReader, the first parameter is the BusinessObject
> > > you want to use, not the table. BOReader basically calls the 'GetRows'
> > > method on that BusinessObject with the WhereClause you provide and
> > > only returns the fields you specify. Its main purpose is to allow
> > > you to do quick queries against various BusinessObjects without
> > > the hassle of instantiating/disposing a BO and pulling in
> > > references, etc. It also saves you the performance hit inherent in
> > > returning a potentially large dataset when you only need a column or
two.
> > >
> > > As for your other errors, it's probably best to handle them one at
> > > a
> > time.
> > > If you'd like, post the errors you get when testing the code and
> > > the offending code and we'll just go through em one by one.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers
> > > <mnumbers@...>
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > John,
> > > > I was pointed to your blog and your example of adding a column
> > > > to an Epicor tracker. My programming background is not in C# or
> > > > VB but the logic normally makes sense and I am learning by example.
> > > > The example you have on your blog looks like it is pulling in
> > > > another table for the
> > > information.
> > > > The field I need is actually on the parttran table, it just is
> > > > not listed in the Collection for the dashboard. I am getting
> > > > some errors that I don't understand and was wondering if you
> > > > could explain them to me or point me in the right direction.
> > > > First was the error I got about the grid being a "static" grid.
> > > > Why is this grid different from the one in your blog? After I
> > > > changed the grid to static, I got errors on the BOReader
> > > > statements and the grdMatLst statements. I assume these are all
> > > > related. Also the on the DataSet ds statement with GetRows I
> > > thought the first parameter "APInvoice"
> > > > would be the table to read, "InvoiceNum=... would be the key,
> > > > and "InvoiceDate" would be the field getting pulled. But the
> > > > APInvoice table does not exist, APInvHed does.
> > > > I appreciate all of the help you guys have given me and I
> > > > realize this isn't your job. With that said, any additional help
> > > > or pointers would be appreciated.
> > > >
> > > > Thanks
> > > >
> > > > Mike
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > On Behalf Of John Driggers
> > > > Sent: Wednesday, October 17, 2012 10:49 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > "Open
> With"
> > > > menus
> > > >
> > > > Just change:
> > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > To:
> > > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > >
> > > > *John Driggers*
> > > > **
> > > > *Chief Data Wrangler*
> > > > *
> > > > *
> > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > that?*
> > > > *
> > > > *:: 904.404.9233
> > > > :: waffqle@...
> > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers
> > > > <mnumbers@...>
> > > > wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > I don't understand that. How do I do it?
> > > > > Mike
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > On Behalf Of John Driggers
> > > > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > "Open
> > With"
> > > > > menus
> > > > >
> > > > > Your grid needs to be static.
> > > > >
> > > > > *John Driggers*
> > > > > **
> > > > > *Chief Data Wrangler*
> > > > > *
> > > > > *
> > > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful
> > > > > is
> > > > > that?*
> > > > > *
> > > > > *:: 904.404.9233
> > > > > :: waffqle@...
> > > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > > >
> > > > > *
> > > > >
> > > > >
> > > > > *
> > > > >
> > > > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > > > <mnumbers@...>
> > > > > wrote:
> > > > >
> > > > > > **
> > > > >
> > > > > >
> > > > > >
> > > > > > I am getting a compile error after adding the first 2 lines
> > > > > > of
> > code.
> > > > > >
> > > > > > //**************************************************
> > > > > >
> > > > > > // Custom C# code for PartTranHistForm
> > > > > >
> > > > > > // Created: 10/17/2012 10:11:20 AM
> > > > > >
> > > > > > //**************************************************
> > > > > >
> > > > > > using System;
> > > > > >
> > > > > > using System.Data;
> > > > > >
> > > > > > using System.Diagnostics;
> > > > > >
> > > > > > using System.Windows.Forms;
> > > > > >
> > > > > > using System.ComponentModel;
> > > > > >
> > > > > > using Epicor.Mfg.UI;
> > > > > >
> > > > > > using Epicor.Mfg.UI.FrameWork;
> > > > > >
> > > > > > using Epicor.Mfg.UI.ExtendedProps;
> > > > > >
> > > > > > using Epicor.Mfg.UI.FormFunctions;
> > > > > >
> > > > > > using Epicor.Mfg.UI.Customization;
> > > > > >
> > > > > > using Epicor.Mfg.UI.Adapters;
> > > > > >
> > > > > > using Epicor.Mfg.UI.Searches;
> > > > > >
> > > > > > using Epicor.Mfg.BO;
> > > > > >
> > > > > > public static class Script
> > > > > >
> > > > > > {
> > > > > >
> > > > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End
> > > > > > Wizard Added Module Level Variables' Comments! **
> > > > > >
> > > > > > // Begin Wizard Added Module Level Variables **
> > > > > >
> > > > > > // End Wizard Added Module Level Variables **
> > > > > >
> > > > > > // Add Custom Module Level Variables Here **
> > > > > >
> > > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > > >
> > > > > > public static void InitializeCustomCode()
> > > > > >
> > > > > > {
> > > > > >
> > > > > > // ** Wizard Insert Location - Do not delete 'Begin/End
> > > > > > Wizard Added Variable Initialization' lines **
> > > > > >
> > > > > > // Begin Wizard Added Variable Initialization
> > > > > >
> > > > > > // End Wizard Added Variable Initialization
> > > > > >
> > > > > > // Begin Wizard Added Custom Method Calls
> > > > > >
> > > > > > // End Wizard Added Custom Method Calls
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > > >
> > > > > > }
> > > > > >
> > > > > > public static void DestroyCustomCode()
> > > > > >
> > > > > > {
> > > > > >
> > > > > > // ** Wizard Insert Location - Do not delete 'Begin/End
> > > > > > Wizard Added Object Disposal' lines **
> > > > > >
> > > > > > // Begin Wizard Added Object Disposal
> > > > > >
> > > > > > // End Wizard Added Object Disposal
> > > > > >
> > > > > > // Begin Custom Code Disposal
> > > > > >
> > > > > > // End Custom Code Disposal
> > > > > >
> > > > > > }
> > > > > >
> > > > > > }
> > > > > >
> > > > > > -------------------
> > > > > >
> > > > > > Compiling Custom Code ...
> > > > > >
> > > > > > ----------errors------------
> > > > > >
> > > > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot
> > > > > > declare instance members in a static class
> > > > > >
> > > > > > ** Compile Failed. **
> > > > > >
> > > > > > Any ideas on what I did wrong here? I copied from the Part
> > > > > > Transaction History Tracker.
> > > > > >
> > > > > > From: vantage@yahoogroups.com
> > > > > > [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
> > > > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > > > To: vantage@yahoogroups.com
> > > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > > "Open
> > > With"
> > > > > > menus
> > > > > >
> > > > > > You can add not a column to the collection. Check this.
> > > > > >
> > > > > >
> > > > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in
> > > > > > -e
> > > > > > pi
> > > > > > co
> > > > > > r-
> > > > > > sp
> > > > > > ecific
> > > > > > ally-to-chart-tracker/
> > > > > >
> > > > > > ________________________________
> > > > > > From: mike.numbers <mnumbers@...
> > > > > > <mailto:mnumbers%40cignys.com>
> > > > > > >
> > > > > > To: vantage@yahoogroups.com
> > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > > > Subject: [Vantage] How do I add a custom program to the
> > > > > > "Open
> With"
> > > > > > menus
> > > > > >
> > > > > > I had to create a custom dashboard version of Part
> > > > > > Transaction History because a field we needed was not part of
the collection.
> > > > > > How do I add my new version of this to all of the "Open With"
> > > > > > menus that currently have the Epicor version of this program?
> > > > > > 9.04.507a
> > > > > >
> > > > > > Mike
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> > > > > > You must have already linked your email address to a yahoo
> > > > > > id to enable
> > > > access.
> > > > > > )
> > > > > > (1) To access the Files Section of our Yahoo!Group for
> > > > > > Report Builder and Crystal Reports and other 'goodies', please
goto:
> > > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > (2) To search through old msg's goto:
> > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups
> > > > > > Links
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > > [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]
> >
> > ------------------------------------
> >
> > 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
Customization
Actions (tools)? Object Explorer.

*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Oct 17, 2012 at 3:58 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> Where do I find Object Explorer? Is it part of Epicor?
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> Jose Gomez
> Sent: Wednesday, October 17, 2012 3:37 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> To find the Adapter use Object Explorer go to Adapters and Scroll down till
> you find it
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Wed, Oct 17, 2012 at 3:29 PM, Mike Numbers <mnumbers@...> wrote:
>
> > **
>
> >
> >
> > I am no longer getting errors. I need some help with the DataSet
> > statement. If I understand correctly the format is:
> > DataSet ds = _boReader.GetRows("business object","where
> > clause","returned field");
> >
> > How do I find the business object for PartTran?
> > I don't understand the format on the example you have in the Chart
> > Tracker example for the Where clause. Somehow we need to use the
> > company/trannum for the row.
> > The returned field should be "DMRNum".
> >
> > Hopefully this will be the final question.
> >
> > Thanks again.
> >
> > Mike
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Jose Gomez
> > Sent: Wednesday, October 17, 2012 2:46 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > You need to maky any and all declarations and functions static as
> > such, do that for EVERY function.
> >
> > private static void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *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 Wed, Oct 17, 2012 at 2:42 PM, Mike Numbers <mnumbers@...>
> wrote:
> >
> > > **
> >
> > >
> > >
> > > I had to add Epicor.Mfg.Lib.IBOReader.dll and
> > > Epicor.Mfg.Core.BLConnectionPool.dll.
> > >
> > > I uncommented the other statements and am now receiving the
> > > following message.
> > >
> > >
> > > Compiling Custom Code ...
> > >
> > > ----------errors------------
> > >
> > > Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot
> > > declare
> > >
> > > instance members in a static class
> > >
> > > ** Compile Failed. **
> > > Line 53 = private void grdMstLst_InitializeRow(object sender,
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> > >
> > > I tried putting static in front of grdMstLst but received another
> > > error so I took it back out.
> > > See code below:
> > >
> > >
> > > //**************************************************
> > > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > > 10:11:20 AM
> > > //**************************************************
> > > using System;
> > > using System.Data;
> > > using System.Diagnostics;
> > > using System.Windows.Forms;
> > > using System.ComponentModel;
> > > using Epicor.Mfg.UI;
> > > using Epicor.Mfg.UI.FrameWork;
> > > using Epicor.Mfg.UI.ExtendedProps;
> > > using Epicor.Mfg.UI.FormFunctions;
> > > using Epicor.Mfg.UI.Customization;
> > > using Epicor.Mfg.UI.Adapters;
> > > using Epicor.Mfg.UI.Searches;
> > > using Epicor.Mfg.BO;
> > > using Epicor.Mfg.Core;
> > > using Epicor.Mfg.Lib;
> > >
> > > public static class Script
> > > {
> > >
> > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > > Level Variables **
> > >
> > > // End Wizard Added Module Level Variables **
> > >
> > > // Add Custom Module Level Variables Here ** static
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; static BOReader
> > > _boReader;
> > >
> > >
> > > public static void InitializeCustomCode() {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > > Variable Initialization' lines ** // Begin Wizard Added Variable
> > > Initialization
> > >
> > > // End Wizard Added Variable Initialization // Begin Wizard Added
> > > Custom Method Calls
> > >
> > > // End Wizard Added Custom Method Calls
> > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > > Number");
> > > myGrid.InitializeRow += new
> > >
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > > it
> > > ialize
> > > Row);
> > > _boReader = new
> > > BOReader(((Session)oTrans.Session).ConnectionPool);
> > >
> > >
> > > }
> > > private void grdMstLst_InitializeRow(object sender,
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) {
> > >
> > >
> > > }
> > > public static void DestroyCustomCode() {
> > >
> > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> > >
> > > // End Wizard Added Object Disposal
> > > // Begin Custom Code Disposal
> > >
> > > // End Custom Code Disposal
> > > //myGrid.InitializeRow -= new
> > >
> > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > > it
> > > ialize
> > > Row);
> > >
> > > }
> > >
> > > }
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 2:10 PM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > > menus
> > >
> > > Set your BO reader as static as we did with the grid. That should
> > > sort that out.
> > >
> > > I noticed that you commented out the sections where you were wiring
> > > up the eventhandler on the grid. Assuming this fixes your BOReader
> > > issue, let's uncomment those next and see what we get.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...>
> > wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Thanks again for your help.
> > > >
> > > > Below is my code. I have commented out statements that were giving
> > > > me errors. I eventually stopped following your example and sent
> > > > you my previous email. I uncommented the BOReader statements and
> > > > tested my
> > code.
> > > > The error is at the bottom.
> > > >
> > > >
> > > > //**************************************************
> > > > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > > > 10:11:20 AM
> > > > //**************************************************
> > > > using System;
> > > > using System.Data;
> > > > using System.Diagnostics;
> > > > using System.Windows.Forms;
> > > > using System.ComponentModel;
> > > > using Epicor.Mfg.UI;
> > > > using Epicor.Mfg.UI.FrameWork;
> > > > using Epicor.Mfg.UI.ExtendedProps; using
> > > > Epicor.Mfg.UI.FormFunctions; using Epicor.Mfg.UI.Customization;
> > > > using Epicor.Mfg.UI.Adapters; using Epicor.Mfg.UI.Searches; using
> > > > Epicor.Mfg.BO; using Epicor.Mfg.Core; using Epicor.Mfg.Lib;
> > > >
> > > >
> > > > public static class Script
> > > > {
> > > >
> > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > Added Module Level Variables' Comments! ** // Begin Wizard Added
> > > > Module Level Variables **
> > > >
> > > > // End Wizard Added Module Level Variables **
> > > >
> > > > // Add Custom Module Level Variables Here ** static
> > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
> > > >
> > > >
> > > > public static void InitializeCustomCode() {
> > > >
> > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > Added Variable Initialization' lines ** // Begin Wizard Added
> > > > Variable Initialization
> > > >
> > > > // End Wizard Added Variable Initialization // Begin Wizard Added
> > > > Custom Method Calls
> > > >
> > > > // End Wizard Added Custom Method Calls
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > > > Number");
> > > > //myGrid.InitializeRow += new
> > > >
> > > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_
> > > > In
> > > > it
> > > > ialize
> > > > Row);
> > > > _boReader = new
> > > > BOReader(((Session)oTrans.Session).ConnectionPool);
> > > >
> > > >
> > > > }
> > > > //private void grdMstLst_InitializeRow(object sender,
> > > > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
> > > >
> > > > //}
> > > >
> > > > public static void DestroyCustomCode() {
> > > >
> > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > Added Object Disposal' lines ** // Begin Wizard Added Object
> > > > Disposal
> > > >
> > > > // End Wizard Added Object Disposal // Begin Custom Code Disposal
> > > >
> > > > // End Custom Code Disposal
> > > > //myGrid.InitializeRow -= new
> > > >
> > > > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_
> > > > In
> > > > it
> > > > ialize
> > > > Row);
> > > >
> > > > }
> > > >
> > > > }
> > > > ----------errors------------
> > > >
> > > > Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> > > > instance
> > > >
> > > > members in a static class
> > > >
> > > > ** Compile Failed. **
> > > > FYI
> > > > Line 34 = BOReader _boReader;
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > Behalf Of John Driggers
> > > > Sent: Wednesday, October 17, 2012 1:14 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the "Open
> With"
> > > > menus
> > > >
> > > > We're always happy to help!
> > > >
> > > > Without looking deeper into it, I'm not sure why the grid is
> > > > different in our code. That form could work a bit differently, or
> > > > maybe it's just an error in the code we posted.
> > > >
> > > > The main purpose of the code in our example is to pull values from
> > > > other tables. Generally the Epicor dataviews contain all the
> > > > fields from a given table, but if that isn't the case for this
> > > > scenario, the code should still do the job.
> > > >
> > > > Regarding the BOReader, the first parameter is the BusinessObject
> > > > you want to use, not the table. BOReader basically calls the
> 'GetRows'
> > > > method on that BusinessObject with the WhereClause you provide and
> > > > only returns the fields you specify. Its main purpose is to allow
> > > > you to do quick queries against various BusinessObjects without
> > > > the hassle of instantiating/disposing a BO and pulling in
> > > > references, etc. It also saves you the performance hit inherent in
> > > > returning a potentially large dataset when you only need a column or
> two.
> > > >
> > > > As for your other errors, it's probably best to handle them one at
> > > > a
> > > time.
> > > > If you'd like, post the errors you get when testing the code and
> > > > the offending code and we'll just go through em one by one.
> > > >
> > > > *John Driggers*
> > > > **
> > > > *Chief Data Wrangler*
> > > > *
> > > > *
> > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > that?*
> > > > *
> > > > *:: 904.404.9233
> > > > :: waffqle@...
> > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > > On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers
> > > > <mnumbers@...>
> > > > wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > John,
> > > > > I was pointed to your blog and your example of adding a column
> > > > > to an Epicor tracker. My programming background is not in C# or
> > > > > VB but the logic normally makes sense and I am learning by example.
> > > > > The example you have on your blog looks like it is pulling in
> > > > > another table for the
> > > > information.
> > > > > The field I need is actually on the parttran table, it just is
> > > > > not listed in the Collection for the dashboard. I am getting
> > > > > some errors that I don't understand and was wondering if you
> > > > > could explain them to me or point me in the right direction.
> > > > > First was the error I got about the grid being a "static" grid.
> > > > > Why is this grid different from the one in your blog? After I
> > > > > changed the grid to static, I got errors on the BOReader
> > > > > statements and the grdMatLst statements. I assume these are all
> > > > > related. Also the on the DataSet ds statement with GetRows I
> > > > thought the first parameter "APInvoice"
> > > > > would be the table to read, "InvoiceNum=... would be the key,
> > > > > and "InvoiceDate" would be the field getting pulled. But the
> > > > > APInvoice table does not exist, APInvHed does.
> > > > > I appreciate all of the help you guys have given me and I
> > > > > realize this isn't your job. With that said, any additional help
> > > > > or pointers would be appreciated.
> > > > >
> > > > > Thanks
> > > > >
> > > > > Mike
> > > > >
> > > > > -----Original Message-----
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > On Behalf Of John Driggers
> > > > > Sent: Wednesday, October 17, 2012 10:49 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > "Open
> > With"
> > > > > menus
> > > > >
> > > > > Just change:
> > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > > To:
> > > > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > >
> > > > > *John Driggers*
> > > > > **
> > > > > *Chief Data Wrangler*
> > > > > *
> > > > > *
> > > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > > that?*
> > > > > *
> > > > > *:: 904.404.9233
> > > > > :: waffqle@...
> > > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > > >
> > > > > *
> > > > >
> > > > > *
> > > > >
> > > > > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers
> > > > > <mnumbers@...>
> > > > > wrote:
> > > > >
> > > > > > **
> > > > >
> > > > > >
> > > > > >
> > > > > > I don't understand that. How do I do it?
> > > > > > Mike
> > > > > >
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > > On Behalf Of John Driggers
> > > > > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > > > > To: vantage@yahoogroups.com
> > > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > > "Open
> > > With"
> > > > > > menus
> > > > > >
> > > > > > Your grid needs to be static.
> > > > > >
> > > > > > *John Driggers*
> > > > > > **
> > > > > > *Chief Data Wrangler*
> > > > > > *
> > > > > > *
> > > > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful
> > > > > > is
> > > > > > that?*
> > > > > > *
> > > > > > *:: 904.404.9233
> > > > > > :: waffqle@...
> > > > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > > > >
> > > > > > *
> > > > > >
> > > > > >
> > > > > > *
> > > > > >
> > > > > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > > > > <mnumbers@...>
> > > > > > wrote:
> > > > > >
> > > > > > > **
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > > I am getting a compile error after adding the first 2 lines
> > > > > > > of
> > > code.
> > > > > > >
> > > > > > > //**************************************************
> > > > > > >
> > > > > > > // Custom C# code for PartTranHistForm
> > > > > > >
> > > > > > > // Created: 10/17/2012 10:11:20 AM
> > > > > > >
> > > > > > > //**************************************************
> > > > > > >
> > > > > > > using System;
> > > > > > >
> > > > > > > using System.Data;
> > > > > > >
> > > > > > > using System.Diagnostics;
> > > > > > >
> > > > > > > using System.Windows.Forms;
> > > > > > >
> > > > > > > using System.ComponentModel;
> > > > > > >
> > > > > > > using Epicor.Mfg.UI;
> > > > > > >
> > > > > > > using Epicor.Mfg.UI.FrameWork;
> > > > > > >
> > > > > > > using Epicor.Mfg.UI.ExtendedProps;
> > > > > > >
> > > > > > > using Epicor.Mfg.UI.FormFunctions;
> > > > > > >
> > > > > > > using Epicor.Mfg.UI.Customization;
> > > > > > >
> > > > > > > using Epicor.Mfg.UI.Adapters;
> > > > > > >
> > > > > > > using Epicor.Mfg.UI.Searches;
> > > > > > >
> > > > > > > using Epicor.Mfg.BO;
> > > > > > >
> > > > > > > public static class Script
> > > > > > >
> > > > > > > {
> > > > > > >
> > > > > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End
> > > > > > > Wizard Added Module Level Variables' Comments! **
> > > > > > >
> > > > > > > // Begin Wizard Added Module Level Variables **
> > > > > > >
> > > > > > > // End Wizard Added Module Level Variables **
> > > > > > >
> > > > > > > // Add Custom Module Level Variables Here **
> > > > > > >
> > > > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > > > >
> > > > > > > public static void InitializeCustomCode()
> > > > > > >
> > > > > > > {
> > > > > > >
> > > > > > > // ** Wizard Insert Location - Do not delete 'Begin/End
> > > > > > > Wizard Added Variable Initialization' lines **
> > > > > > >
> > > > > > > // Begin Wizard Added Variable Initialization
> > > > > > >
> > > > > > > // End Wizard Added Variable Initialization
> > > > > > >
> > > > > > > // Begin Wizard Added Custom Method Calls
> > > > > > >
> > > > > > > // End Wizard Added Custom Method Calls
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > > > >
> > > > > > > }
> > > > > > >
> > > > > > > public static void DestroyCustomCode()
> > > > > > >
> > > > > > > {
> > > > > > >
> > > > > > > // ** Wizard Insert Location - Do not delete 'Begin/End
> > > > > > > Wizard Added Object Disposal' lines **
> > > > > > >
> > > > > > > // Begin Wizard Added Object Disposal
> > > > > > >
> > > > > > > // End Wizard Added Object Disposal
> > > > > > >
> > > > > > > // Begin Custom Code Disposal
> > > > > > >
> > > > > > > // End Custom Code Disposal
> > > > > > >
> > > > > > > }
> > > > > > >
> > > > > > > }
> > > > > > >
> > > > > > > -------------------
> > > > > > >
> > > > > > > Compiling Custom Code ...
> > > > > > >
> > > > > > > ----------errors------------
> > > > > > >
> > > > > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot
> > > > > > > declare instance members in a static class
> > > > > > >
> > > > > > > ** Compile Failed. **
> > > > > > >
> > > > > > > Any ideas on what I did wrong here? I copied from the Part
> > > > > > > Transaction History Tracker.
> > > > > > >
> > > > > > > From: vantage@yahoogroups.com
> > > > > > > [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
> > > > > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > > > > To: vantage@yahoogroups.com
> > > > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > > > "Open
> > > > With"
> > > > > > > menus
> > > > > > >
> > > > > > > You can add not a column to the collection. Check this.
> > > > > > >
> > > > > > >
> > > > > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in
> > > > > > > -e
> > > > > > > pi
> > > > > > > co
> > > > > > > r-
> > > > > > > sp
> > > > > > > ecific
> > > > > > > ally-to-chart-tracker/
> > > > > > >
> > > > > > > ________________________________
> > > > > > > From: mike.numbers <mnumbers@...
> > > > > > > <mailto:mnumbers%40cignys.com>
> > > > > > > >
> > > > > > > To: vantage@yahoogroups.com
> > > > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > > > > Subject: [Vantage] How do I add a custom program to the
> > > > > > > "Open
> > With"
> > > > > > > menus
> > > > > > >
> > > > > > > I had to create a custom dashboard version of Part
> > > > > > > Transaction History because a field we needed was not part of
> the collection.
> > > > > > > How do I add my new version of this to all of the "Open With"
> > > > > > > menus that currently have the Epicor version of this program?
> > > > > > > 9.04.507a
> > > > > > >
> > > > > > > Mike
> > > > > > >
> > > > > > > ------------------------------------
> > > > > > >
> > > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> > > > > > > You must have already linked your email address to a yahoo
> > > > > > > id to enable
> > > > > access.
> > > > > > > )
> > > > > > > (1) To access the Files Section of our Yahoo!Group for
> > > > > > > Report Builder and Crystal Reports and other 'goodies', please
> goto:
> > > > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > > (2) To search through old msg's goto:
> > > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > > (3) To view links to Vendors that provide Vantage services
> goto:
> > > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups
> > > > > > > Links
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > > > [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]
> > >
> > > ------------------------------------
> > >
> > > 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]
Try this...
Â
DataSet ds =
_boReader.GetRows("PartTran","Company = '" +
FormName.Session.CompanyID + "' AND TranNum='" +
e.Row.Cells["TranNum"].Value.ToString()+"'","DMRNum");



________________________________
From: Mike Numbers <mnumbers@...>
To: vantage@yahoogroups.com
Sent: Wednesday, October 17, 2012 3:29 PM
Subject: RE: [Vantage] How do I add a custom program to the "Open With" menus

I am no longer getting errors. I need some help with the DataSet
statement. If I understand correctly the format is:
DataSet ds = _boReader.GetRows("business object","where clause","returned
field");

How do I find the business object for PartTran?
I don't understand the format on the example you have in the Chart Tracker
example for the Where clause. Somehow we need to use the company/trannum
for the row.
The returned field should be "DMRNum".

Hopefully this will be the final question.

Thanks again.
Mike


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Wednesday, October 17, 2012 2:46 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

You need to maky any and all declarations and functions static as such, do
that for EVERY function.


private static void grdMstLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)

*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Wed, Oct 17, 2012 at 2:42 PM, Mike Numbers <mnumbers@...> wrote:

> **
>
>
> I had to add Epicor.Mfg.Lib.IBOReader.dll and
> Epicor.Mfg.Core.BLConnectionPool.dll.
>
> I uncommented the other statements and am now receiving the following
> message.
>
>
> Compiling Custom Code ...
>
> ----------errors------------
>
> Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot
> declare
>
> instance members in a static class
>
> ** Compile Failed. **
> Line 53 = private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
>
> I tried putting static in front of grdMstLst but received another
> error so I took it back out.
> See code below:
>
>
> //**************************************************
> // Custom C# code for PartTranHistForm // Created: 10/17/2012 10:11:20
> AM
> //**************************************************
> using System;
> using System.Data;
> using System.Diagnostics;
> using System.Windows.Forms;
> using System.ComponentModel;
> using Epicor.Mfg.UI;
> using Epicor.Mfg.UI.FrameWork;
> using Epicor.Mfg.UI.ExtendedProps;
> using Epicor.Mfg.UI.FormFunctions;
> using Epicor.Mfg.UI.Customization;
> using Epicor.Mfg.UI.Adapters;
> using Epicor.Mfg.UI.Searches;
> using Epicor.Mfg.BO;
> using Epicor.Mfg.Core;
> using Epicor.Mfg.Lib;
>
> public static class Script
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> Module Level Variables' Comments! ** // Begin Wizard Added Module
> Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here ** static
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; static BOReader
> _boReader;
>
>
> public static void InitializeCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Variable Initialization' lines ** // Begin Wizard Added Variable
> Initialization
>
> // End Wizard Added Variable Initialization // Begin Wizard Added
> Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> Number");
> myGrid.InitializeRow += new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
> _boReader = new
> BOReader(((Session)oTrans.Session).ConnectionPool);
>
>
> }
> private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) {
>
>
> }
> public static void DestroyCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Object Disposal' lines ** // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
> //myGrid.InitializeRow -= new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
>
> }
>
> }
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of John Driggers
> Sent: Wednesday, October 17, 2012 2:10 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Set your BO reader as static as we did with the grid. That should sort
> that out.
>
> I noticed that you commented out the sections where you were wiring up
> the eventhandler on the grid. Assuming this fixes your BOReader issue,
> let's uncomment those next and see what we get.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...> wrote:
>
> > **
> >
> >
> > Thanks again for your help.
> >
> > Below is my code. I have commented out statements that were giving
> > me errors. I eventually stopped following your example and sent you
> > my previous email. I uncommented the BOReader statements and tested my
code.
> > The error is at the bottom.
> >
> >
> > //**************************************************
> > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > 10:11:20 AM
> > //**************************************************
> > using System;
> > using System.Data;
> > using System.Diagnostics;
> > using System.Windows.Forms;
> > using System.ComponentModel;
> > using Epicor.Mfg.UI;
> > using Epicor.Mfg.UI.FrameWork;
> > using Epicor.Mfg.UI.ExtendedProps;
> > using Epicor.Mfg.UI.FormFunctions;
> > using Epicor.Mfg.UI.Customization;
> > using Epicor.Mfg.UI.Adapters;
> > using Epicor.Mfg.UI.Searches;
> > using Epicor.Mfg.BO;
> > using Epicor.Mfg.Core;
> > using Epicor.Mfg.Lib;
> >
> >
> > public static class Script
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here ** static
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
> >
> >
> > public static void InitializeCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines ** // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization // Begin Wizard Added
> > Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > Number");
> > //myGrid.InitializeRow += new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> > _boReader = new
> > BOReader(((Session)oTrans.Session).ConnectionPool);
> >
> >
> > }
> > //private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
> >
> > //}
> >
> > public static void DestroyCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> > //myGrid.InitializeRow -= new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> >
> > }
> >
> > }
> > ----------errors------------
> >
> > Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> > instance
> >
> > members in a static class
> >
> > ** Compile Failed. **
> > FYI
> > Line 34 = BOReader _boReader;
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 1:14 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > We're always happy to help!
> >
> > Without looking deeper into it, I'm not sure why the grid is
> > different in our code. That form could work a bit differently, or
> > maybe it's just an error in the code we posted.
> >
> > The main purpose of the code in our example is to pull values from
> > other tables. Generally the Epicor dataviews contain all the fields
> > from a given table, but if that isn't the case for this scenario,
> > the code should still do the job.
> >
> > Regarding the BOReader, the first parameter is the BusinessObject
> > you want to use, not the table. BOReader basically calls the 'GetRows'
> > method on that BusinessObject with the WhereClause you provide and
> > only returns the fields you specify. Its main purpose is to allow
> > you to do quick queries against various BusinessObjects without the
> > hassle of instantiating/disposing a BO and pulling in references,
> > etc. It also saves you the performance hit inherent in returning a
> > potentially large dataset when you only need a column or two.
> >
> > As for your other errors, it's probably best to handle them one at a
> time.
> > If you'd like, post the errors you get when testing the code and the
> > offending code and we'll just go through em one by one.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...>
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > John,
> > > I was pointed to your blog and your example of adding a column to
> > > an Epicor tracker. My programming background is not in C# or VB
> > > but the logic normally makes sense and I am learning by example.
> > > The example you have on your blog looks like it is pulling in
> > > another table for the
> > information.
> > > The field I need is actually on the parttran table, it just is not
> > > listed in the Collection for the dashboard. I am getting some
> > > errors that I don't understand and was wondering if you could
> > > explain them to me or point me in the right direction. First was
> > > the error I got about the grid being a "static" grid. Why is this
> > > grid different from the one in your blog? After I changed the grid
> > > to static, I got errors on the BOReader statements and the
> > > grdMatLst statements. I assume these are all related. Also the on
> > > the DataSet ds statement with GetRows I
> > thought the first parameter "APInvoice"
> > > would be the table to read, "InvoiceNum=... would be the key, and
> > > "InvoiceDate" would be the field getting pulled. But the APInvoice
> > > table does not exist, APInvHed does.
> > > I appreciate all of the help you guys have given me and I realize
> > > this isn't your job. With that said, any additional help or
> > > pointers would be appreciated.
> > >
> > > Thanks
> > >
> > > Mike
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 10:49 AM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open
With"
> > > menus
> > >
> > > Just change:
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > To:
> > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers
> > > <mnumbers@...>
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I don't understand that. How do I do it?
> > > > Mike
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > On Behalf Of John Driggers
> > > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > "Open
> With"
> > > > menus
> > > >
> > > > Your grid needs to be static.
> > > >
> > > > *John Driggers*
> > > > **
> > > > *Chief Data Wrangler*
> > > > *
> > > > *
> > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > that?*
> > > > *
> > > > *:: 904.404.9233
> > > > :: waffqle@...
> > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > >
> > > > *
> > > >
> > > >
> > > > *
> > > >
> > > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > > <mnumbers@...>
> > > > wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > I am getting a compile error after adding the first 2 lines of
> code.
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > // Custom C# code for PartTranHistForm
> > > > >
> > > > > // Created: 10/17/2012 10:11:20 AM
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > using System;
> > > > >
> > > > > using System.Data;
> > > > >
> > > > > using System.Diagnostics;
> > > > >
> > > > > using System.Windows.Forms;
> > > > >
> > > > > using System.ComponentModel;
> > > > >
> > > > > using Epicor.Mfg.UI;
> > > > >
> > > > > using Epicor.Mfg.UI.FrameWork;
> > > > >
> > > > > using Epicor.Mfg.UI.ExtendedProps;
> > > > >
> > > > > using Epicor.Mfg.UI.FormFunctions;
> > > > >
> > > > > using Epicor.Mfg.UI.Customization;
> > > > >
> > > > > using Epicor.Mfg.UI.Adapters;
> > > > >
> > > > > using Epicor.Mfg.UI.Searches;
> > > > >
> > > > > using Epicor.Mfg.BO;
> > > > >
> > > > > public static class Script
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > > Added Module Level Variables' Comments! **
> > > > >
> > > > > // Begin Wizard Added Module Level Variables **
> > > > >
> > > > > // End Wizard Added Module Level Variables **
> > > > >
> > > > > // Add Custom Module Level Variables Here **
> > > > >
> > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > >
> > > > > public static void InitializeCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Variable Initialization' lines **
> > > > >
> > > > > // Begin Wizard Added Variable Initialization
> > > > >
> > > > > // End Wizard Added Variable Initialization
> > > > >
> > > > > // Begin Wizard Added Custom Method Calls
> > > > >
> > > > > // End Wizard Added Custom Method Calls
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > >
> > > > > }
> > > > >
> > > > > public static void DestroyCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Object Disposal' lines **
> > > > >
> > > > > // Begin Wizard Added Object Disposal
> > > > >
> > > > > // End Wizard Added Object Disposal
> > > > >
> > > > > // Begin Custom Code Disposal
> > > > >
> > > > > // End Custom Code Disposal
> > > > >
> > > > > }
> > > > >
> > > > > }
> > > > >
> > > > > -------------------
> > > > >
> > > > > Compiling Custom Code ...
> > > > >
> > > > > ----------errors------------
> > > > >
> > > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot
> > > > > declare instance members in a static class
> > > > >
> > > > > ** Compile Failed. **
> > > > >
> > > > > Any ideas on what I did wrong here? I copied from the Part
> > > > > Transaction History Tracker.
> > > > >
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > > > On Behalf Of Ted Koch
> > > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > "Open
> > With"
> > > > > menus
> > > > >
> > > > > You can add not a column to the collection. Check this.
> > > > >
> > > > >
> > > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-e
> > > > > pi
> > > > > co
> > > > > r-
> > > > > sp
> > > > > ecific
> > > > > ally-to-chart-tracker/
> > > > >
> > > > > ________________________________
> > > > > From: mike.numbers <mnumbers@...
> > > > > <mailto:mnumbers%40cignys.com>
> > > > > >
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > > Subject: [Vantage] How do I add a custom program to the "Open
With"
> > > > > menus
> > > > >
> > > > > I had to create a custom dashboard version of Part Transaction
> > > > > History because a field we needed was not part of the collection.
> > > > > How do I add my new version of this to all of the "Open With"
> > > > > menus that currently have the Epicor version of this program?
> > > > > 9.04.507a
> > > > >
> > > > > Mike
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> > > > > You must have already linked your email address to a yahoo id
> > > > > to enable
> > > access.
> > > > > )
> > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > > Builder and Crystal Reports and other 'goodies', please goto:
> > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > (2) To search through old msg's goto:
> > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > > [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]
>
> ------------------------------------
>
> 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/.%c2%a0
(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






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

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/.%c2%a0
(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]
I have been off for a week and am trying to get this to work. I am getting
the error message - "too many characters in character literal" on the
DataSet ds statement. I believe my single and double quotes are correct.
The problem has to be in the where clause section, but I don't know C+ well
enough to either shorten the phrase or correct it.

Any help would be appreciated.





//**************************************************

// Custom C# code for PartTranHistForm

// Created: 10/17/2012 10:11:20 AM

//**************************************************

using System;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using System.ComponentModel;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Searches;

using Epicor.Mfg.BO;

using Epicor.Mfg.Core;

using Epicor.Mfg.Lib;





public static class Script

{





// ** Wizard Insert Location - Do Not Remove 'Begin/End
Wizard Added Module Level Variables' Comments! **

// Begin Wizard Added Module Level Variables **



// End Wizard Added Module Level Variables **





// Add Custom Module Level Variables Here **

static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;

static BOReader _boReader;



public static void InitializeCustomCode()

{



// ** Wizard Insert Location - Do not delete
'Begin/End Wizard Added Variable Initialization' lines **

// Begin Wizard Added Variable
Initialization



// End Wizard Added Variable Initialization

// Begin Wizard Added Custom Method Calls



// End Wizard Added Custom Method Calls


myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");


myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR Number");

myGrid.InitializeRow += new
Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
Row);

_boReader = new
BOReader(((Session)oTrans.Session).ConnectionPool);





}

private static void grdMatLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)

{

DataSet ds =
_boReader.GetRows("PartTran","Company="'FormName.Session.CompanyID+'" AND
TranNum="'e.Row.Cells["TranNum"].Value.ToString()+'"","DMRNum");

}

public static void DestroyCustomCode()

{



// ** Wizard Insert Location - Do not delete
'Begin/End Wizard Added Object Disposal' lines **

// Begin Wizard Added Object Disposal



// End Wizard Added Object Disposal

// Begin Custom Code Disposal



// End Custom Code Disposal

myGrid.InitializeRow -= new
Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Initialize
Row);

_boReader=null;



}







}

----------errors------------



Error: CS1012 - line 55 (151) - Too many characters in character literal

Error: CS1012 - line 55 (151) - Too many characters in character literal



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ted Koch
Sent: Wednesday, October 17, 2012 4:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus





Try this...

DataSet ds =
_boReader.GetRows("PartTran","Company = '" +
FormName.Session.CompanyID + "' AND TranNum='" +
e.Row.Cells["TranNum"].Value.ToString()+"'","DMRNum");

________________________________
From: Mike Numbers <mnumbers@... <mailto:mnumbers%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, October 17, 2012 3:29 PM
Subject: RE: [Vantage] How do I add a custom program to the "Open With"
menus

I am no longer getting errors. I need some help with the DataSet
statement. If I understand correctly the format is:
DataSet ds = _boReader.GetRows("business object","where clause","returned
field");

How do I find the business object for PartTran?
I don't understand the format on the example you have in the Chart Tracker
example for the Where clause. Somehow we need to use the company/trannum
for the row.
The returned field should be "DMRNum".

Hopefully this will be the final question.

Thanks again.
Mike

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Jose Gomez
Sent: Wednesday, October 17, 2012 2:46 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] How do I add a custom program to the "Open With"
menus

You need to maky any and all declarations and functions static as such, do
that for EVERY function.

private static void grdMstLst_InitializeRow(object sender,
Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
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 Wed, Oct 17, 2012 at 2:42 PM, Mike Numbers <mnumbers@...
<mailto:mnumbers%40cignys.com> > wrote:

> **
>
>
> I had to add Epicor.Mfg.Lib.IBOReader.dll and
> Epicor.Mfg.Core.BLConnectionPool.dll.
>
> I uncommented the other statements and am now receiving the following
> message.
>
>
> Compiling Custom Code ...
>
> ----------errors------------
>
> Error: CS0708 - line 53 (149) - 'grdMstLst_InitializeRow': cannot
> declare
>
> instance members in a static class
>
> ** Compile Failed. **
> Line 53 = private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
>
> I tried putting static in front of grdMstLst but received another
> error so I took it back out.
> See code below:
>
>
> //**************************************************
> // Custom C# code for PartTranHistForm // Created: 10/17/2012 10:11:20
> AM
> //**************************************************
> using System;
> using System.Data;
> using System.Diagnostics;
> using System.Windows.Forms;
> using System.ComponentModel;
> using Epicor.Mfg.UI;
> using Epicor.Mfg.UI.FrameWork;
> using Epicor.Mfg.UI.ExtendedProps;
> using Epicor.Mfg.UI.FormFunctions;
> using Epicor.Mfg.UI.Customization;
> using Epicor.Mfg.UI.Adapters;
> using Epicor.Mfg.UI.Searches;
> using Epicor.Mfg.BO;
> using Epicor.Mfg.Core;
> using Epicor.Mfg.Lib;
>
> public static class Script
> {
>
> // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> Module Level Variables' Comments! ** // Begin Wizard Added Module
> Level Variables **
>
> // End Wizard Added Module Level Variables **
>
> // Add Custom Module Level Variables Here ** static
> Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; static BOReader
> _boReader;
>
>
> public static void InitializeCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Variable Initialization' lines ** // Begin Wizard Added Variable
> Initialization
>
> // End Wizard Added Variable Initialization // Begin Wizard Added
> Custom Method Calls
>
> // End Wizard Added Custom Method Calls
>
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> Number");
> myGrid.InitializeRow += new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
> _boReader = new
> BOReader(((Session)oTrans.Session).ConnectionPool);
>
>
> }
> private void grdMstLst_InitializeRow(object sender,
> Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) {
>
>
> }
> public static void DestroyCustomCode() {
>
> // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> Object Disposal' lines ** // Begin Wizard Added Object Disposal
>
> // End Wizard Added Object Disposal
> // Begin Custom Code Disposal
>
> // End Custom Code Disposal
> //myGrid.InitializeRow -= new
>
> Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_Init
> ialize
> Row);
>
> }
>
> }
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of John Driggers
> Sent: Wednesday, October 17, 2012 2:10 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> menus
>
> Set your BO reader as static as we did with the grid. That should sort
> that out.
>
> I noticed that you commented out the sections where you were wiring up
> the eventhandler on the grid. Assuming this fixes your BOReader issue,
> let's uncomment those next and see what we get.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> *
> *:: 904.404.9233
> :: waffqle@... <mailto:waffqle%40usdoingstuff.com>
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Wed, Oct 17, 2012 at 1:35 PM, Mike Numbers <mnumbers@...
<mailto:mnumbers%40cignys.com> > wrote:
>
> > **
> >
> >
> > Thanks again for your help.
> >
> > Below is my code. I have commented out statements that were giving
> > me errors. I eventually stopped following your example and sent you
> > my previous email. I uncommented the BOReader statements and tested my
code.
> > The error is at the bottom.
> >
> >
> > //**************************************************
> > // Custom C# code for PartTranHistForm // Created: 10/17/2012
> > 10:11:20 AM
> > //**************************************************
> > using System;
> > using System.Data;
> > using System.Diagnostics;
> > using System.Windows.Forms;
> > using System.ComponentModel;
> > using Epicor.Mfg.UI;
> > using Epicor.Mfg.UI.FrameWork;
> > using Epicor.Mfg.UI.ExtendedProps;
> > using Epicor.Mfg.UI.FormFunctions;
> > using Epicor.Mfg.UI.Customization;
> > using Epicor.Mfg.UI.Adapters;
> > using Epicor.Mfg.UI.Searches;
> > using Epicor.Mfg.BO;
> > using Epicor.Mfg.Core;
> > using Epicor.Mfg.Lib;
> >
> >
> > public static class Script
> > {
> >
> > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added
> > Module Level Variables' Comments! ** // Begin Wizard Added Module
> > Level Variables **
> >
> > // End Wizard Added Module Level Variables **
> >
> > // Add Custom Module Level Variables Here ** static
> > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid; BOReader _boReader;
> >
> >
> > public static void InitializeCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Variable Initialization' lines ** // Begin Wizard Added Variable
> > Initialization
> >
> > // End Wizard Added Variable Initialization // Begin Wizard Added
> > Custom Method Calls
> >
> > // End Wizard Added Custom Method Calls
> >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > myGrid.DisplayLayout.Bands[0].Columns.Add("DMRNum","DMR
> > Number");
> > //myGrid.InitializeRow += new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> > _boReader = new
> > BOReader(((Session)oTrans.Session).ConnectionPool);
> >
> >
> > }
> > //private void grdMstLst_InitializeRow(object sender,
> > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) //{
> >
> > //}
> >
> > public static void DestroyCustomCode() {
> >
> > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added
> > Object Disposal' lines ** // Begin Wizard Added Object Disposal
> >
> > // End Wizard Added Object Disposal
> > // Begin Custom Code Disposal
> >
> > // End Custom Code Disposal
> > //myGrid.InitializeRow -= new
> >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_In
> > it
> > ialize
> > Row);
> >
> > }
> >
> > }
> > ----------errors------------
> >
> > Error: CS0708 - line 34 (128) - 'Script._boReader': cannot declare
> > instance
> >
> > members in a static class
> >
> > ** Compile Failed. **
> > FYI
> > Line 34 = BOReader _boReader;
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of John Driggers
> > Sent: Wednesday, October 17, 2012 1:14 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] How do I add a custom program to the "Open With"
> > menus
> >
> > We're always happy to help!
> >
> > Without looking deeper into it, I'm not sure why the grid is
> > different in our code. That form could work a bit differently, or
> > maybe it's just an error in the code we posted.
> >
> > The main purpose of the code in our example is to pull values from
> > other tables. Generally the Epicor dataviews contain all the fields
> > from a given table, but if that isn't the case for this scenario,
> > the code should still do the job.
> >
> > Regarding the BOReader, the first parameter is the BusinessObject
> > you want to use, not the table. BOReader basically calls the 'GetRows'
> > method on that BusinessObject with the WhereClause you provide and
> > only returns the fields you specify. Its main purpose is to allow
> > you to do quick queries against various BusinessObjects without the
> > hassle of instantiating/disposing a BO and pulling in references,
> > etc. It also saves you the performance hit inherent in returning a
> > potentially large dataset when you only need a column or two.
> >
> > As for your other errors, it's probably best to handle them one at a
> time.
> > If you'd like, post the errors you get when testing the code and the
> > offending code and we'll just go through em one by one.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@... <mailto:waffqle%40usdoingstuff.com>
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> > On Wed, Oct 17, 2012 at 12:35 PM, Mike Numbers <mnumbers@...
<mailto:mnumbers%40cignys.com> >
> > wrote:
> >
> > > **
> >
> > >
> > >
> > > John,
> > > I was pointed to your blog and your example of adding a column to
> > > an Epicor tracker. My programming background is not in C# or VB
> > > but the logic normally makes sense and I am learning by example.
> > > The example you have on your blog looks like it is pulling in
> > > another table for the
> > information.
> > > The field I need is actually on the parttran table, it just is not
> > > listed in the Collection for the dashboard. I am getting some
> > > errors that I don't understand and was wondering if you could
> > > explain them to me or point me in the right direction. First was
> > > the error I got about the grid being a "static" grid. Why is this
> > > grid different from the one in your blog? After I changed the grid
> > > to static, I got errors on the BOReader statements and the
> > > grdMatLst statements. I assume these are all related. Also the on
> > > the DataSet ds statement with GetRows I
> > thought the first parameter "APInvoice"
> > > would be the table to read, "InvoiceNum=... would be the key, and
> > > "InvoiceDate" would be the field getting pulled. But the APInvoice
> > > table does not exist, APInvHed does.
> > > I appreciate all of the help you guys have given me and I realize
> > > this isn't your job. With that said, any additional help or
> > > pointers would be appreciated.
> > >
> > > Thanks
> > >
> > > Mike
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf Of John Driggers
> > > Sent: Wednesday, October 17, 2012 10:49 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: Re: [Vantage] How do I add a custom program to the "Open
With"
> > > menus
> > >
> > > Just change:
> > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > To:
> > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@... <mailto:waffqle%40usdoingstuff.com>
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> > >
> > > *
> > >
> > > On Wed, Oct 17, 2012 at 10:39 AM, Mike Numbers
> > > <mnumbers@... <mailto:mnumbers%40cignys.com> >
> > > wrote:
> > >
> > > > **
> > >
> > > >
> > > >
> > > > I don't understand that. How do I do it?
> > > > Mike
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
> > > > On Behalf Of John Driggers
> > > > Sent: Wednesday, October 17, 2012 10:34 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > "Open
> With"
> > > > menus
> > > >
> > > > Your grid needs to be static.
> > > >
> > > > *John Driggers*
> > > > **
> > > > *Chief Data Wrangler*
> > > > *
> > > > *
> > > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > > > that?*
> > > > *
> > > > *:: 904.404.9233
> > > > :: waffqle@... <mailto:waffqle%40usdoingstuff.com>
> > > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > > >
> > > > *
> > > >
> > > >
> > > > *
> > > >
> > > > On Wed, Oct 17, 2012 at 10:27 AM, Mike Numbers
> > > > <mnumbers@... <mailto:mnumbers%40cignys.com> >
> > > > wrote:
> > > >
> > > > > **
> > > >
> > > > >
> > > > >
> > > > > I am getting a compile error after adding the first 2 lines of
> code.
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > // Custom C# code for PartTranHistForm
> > > > >
> > > > > // Created: 10/17/2012 10:11:20 AM
> > > > >
> > > > > //**************************************************
> > > > >
> > > > > using System;
> > > > >
> > > > > using System.Data;
> > > > >
> > > > > using System.Diagnostics;
> > > > >
> > > > > using System.Windows.Forms;
> > > > >
> > > > > using System.ComponentModel;
> > > > >
> > > > > using Epicor.Mfg.UI;
> > > > >
> > > > > using Epicor.Mfg.UI.FrameWork;
> > > > >
> > > > > using Epicor.Mfg.UI.ExtendedProps;
> > > > >
> > > > > using Epicor.Mfg.UI.FormFunctions;
> > > > >
> > > > > using Epicor.Mfg.UI.Customization;
> > > > >
> > > > > using Epicor.Mfg.UI.Adapters;
> > > > >
> > > > > using Epicor.Mfg.UI.Searches;
> > > > >
> > > > > using Epicor.Mfg.BO;
> > > > >
> > > > > public static class Script
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
> > > > > Added Module Level Variables' Comments! **
> > > > >
> > > > > // Begin Wizard Added Module Level Variables **
> > > > >
> > > > > // End Wizard Added Module Level Variables **
> > > > >
> > > > > // Add Custom Module Level Variables Here **
> > > > >
> > > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid myGrid;
> > > > >
> > > > > public static void InitializeCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Variable Initialization' lines **
> > > > >
> > > > > // Begin Wizard Added Variable Initialization
> > > > >
> > > > > // End Wizard Added Variable Initialization
> > > > >
> > > > > // Begin Wizard Added Custom Method Calls
> > > > >
> > > > > // End Wizard Added Custom Method Calls
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
myGrid=(Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("
> > > > > f83d6262-a7d9-4fb5-a7d0-54644a9bb66b");
> > > > >
> > > > > }
> > > > >
> > > > > public static void DestroyCustomCode()
> > > > >
> > > > > {
> > > > >
> > > > > // ** Wizard Insert Location - Do not delete 'Begin/End Wizard
> > > > > Added Object Disposal' lines **
> > > > >
> > > > > // Begin Wizard Added Object Disposal
> > > > >
> > > > > // End Wizard Added Object Disposal
> > > > >
> > > > > // Begin Custom Code Disposal
> > > > >
> > > > > // End Custom Code Disposal
> > > > >
> > > > > }
> > > > >
> > > > > }
> > > > >
> > > > > -------------------
> > > > >
> > > > > Compiling Custom Code ...
> > > > >
> > > > > ----------errors------------
> > > > >
> > > > > Error: CS0708 - line 31 (123) - 'Script.myGrid': cannot
> > > > > declare instance members in a static class
> > > > >
> > > > > ** Compile Failed. **
> > > > >
> > > > > Any ideas on what I did wrong here? I copied from the Part
> > > > > Transaction History Tracker.
> > > > >
> > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
> > > > > On Behalf Of Ted Koch
> > > > > Sent: Wednesday, October 17, 2012 8:38 AM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Subject: Re: [Vantage] How do I add a custom program to the
> > > > > "Open
> > With"
> > > > > menus
> > > > >
> > > > > You can add not a column to the collection. Check this.
> > > > >
> > > > >
> > > > > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-e
> > > > > pi
> > > > > co
> > > > > r-
> > > > > sp
> > > > > ecific
> > > > > ally-to-chart-tracker/
> > > > >
> > > > > ________________________________
> > > > > From: mike.numbers <mnumbers@...
<mailto:mnumbers%40cignys.com>
> > > > > <mailto:mnumbers%40cignys.com>
> > > > > >
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > > > Sent: Wednesday, October 17, 2012 8:33 AM
> > > > > Subject: [Vantage] How do I add a custom program to the "Open
With"
> > > > > menus
> > > > >
> > > > > I had to create a custom dashboard version of Part Transaction
> > > > > History because a field we needed was not part of the collection.
> > > > > How do I add my new version of this to all of the "Open With"
> > > > > menus that currently have the Epicor version of this program?
> > > > > 9.04.507a
> > > > >
> > > > > Mike
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> > > > > You must have already linked your email address to a yahoo id
> > > > > to enable
> > > access.
> > > > > )
> > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > > Builder and Crystal Reports and other 'goodies', please goto:
> > > > > http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> > > > > <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]
> > > > >
> > > > > [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/.
<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/.
<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/.
<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/.
<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/.
<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

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





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