Return All Companies With Query

Yahoo Archive
1
Not in a system at the moment but I think progress.o4glrt.dll is the assembly reference you need to add.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Thanks Jim, in order to access the Progress.Open4GL.DynamicAPI namespace what file do I need to reference?
>
>
>
>
> ________________________________
> From: jckinneman <jckinneman@...>
> To: vantage@yahoogroups.com
> Sent: Friday, December 21, 2012 5:24 PM
> Subject: [Vantage] Re: Return All Companies With Query
>
> Very rough ;list of things that need to be done. If you are E9, C# is recommended, if on Vantage just need to convert to VB.
>
> ///
> using Progress.Open4GL.DynamicAPI;
>
> Epicor.Mfg.Core.Session session = (Epicor.Mfg.Core.Session)oTrans.Session;
>
> Progress.Open4GL.DynamicAPI.Session progressSession = session.ConnectionPool.Get();
>
> PersistentProc proc = default(PersistentProc);
>
> // setup a parameter with X being the number of items you will pass over and get back
> ParameterSet parms = new ParameterSet(X);
>
> // the next item depends on what you are passing over.
>
> // some string variable called StrValue that is being passed over but not going to be updated
> parms.setStringParameter(1, StrValue, ParameterSet.INPUT);
> // A datatable that the progress reoutin will be updating
> parms.setDataTableParameter(3, dt, ParameterSet.OUTPUT);
>
>
> proc = progressSession.runPersistentProcedure(@"Name of progress File to run", parms);
>
> // clean up
> proc.delete();
> session.ConnectionPool.Release(progressSession);
>
> In the progress program you need to have the same number and type of parameters. Beyond that nothing special about the progress routine.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
>
>
>
> --- In vantage@yahoogroups.com, Ted Koch <tkoch77@> wrote:
> >
> > I don't suppose you would have an example you could share?
> >
> >
> >
> >
> > ________________________________
> >Â From: jckinneman <jckinneman@>
> > To: vantage@yahoogroups.com
> > Sent: Friday, December 21, 2012 4:38 PM
> > Subject: [Vantage] Re: Return All Companies With Query
> >Â
> > You could do a direct call to progress from embedded and have it return the list. This bypasses the business objects and talks directly to the database so you can retrieve any data you wish this way.
> >
> > Jim Kinneman
> > Encompass Solutions, Inc
> >
> > --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@> wrote:
> > >
> > > How would I return a list of every company even if the user is not assigned to some companies within user security? I noticed when i run this code it only returns all the companies that I am assigned to...
> > >
> > > Â Â Â Â Â Â Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> > > Â Â Â Â Â Â Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> > > Â Â Â Â Â Â For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> > > Â Â Â Â Â Â Â Â Â EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> > > Â Â Â Â Â Â Next
> > >
> > > Thanks,
> > > -Ted
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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]
> >
>
>
>
>
> ------------------------------------
>
> 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]
>
2
How would I return a list of every company even if the user is not assigned to some companies within user security? I noticed when i run this code it only returns all the companies that I am assigned to...

Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
Next

Thanks,
-Ted
3
You are gonna ahve to do a session mod and change companies to get 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 Fri, Dec 21, 2012 at 3:56 PM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> How would I return a list of every company even if the user is not
> assigned to some companies within user security? I noticed when i run this
> code it only returns all the companies that I am assigned to...
>
> Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> Next
>
> Thanks,
> -Ted
>
>
>


[Non-text portions of this message have been removed]
4
I'm going to have to hard code this in then?




________________________________
From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, December 21, 2012 4:09 PM
Subject: Re: [Vantage] Return All Companies With Query

You are gonna ahve to do a session mod and change companies to get 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 Fri, Dec 21, 2012 at 3:56 PM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> How would I return a list of every company even if the user is not
> assigned to some companies within user security? I noticed when i run this
> code it only returns all the companies that I am assigned to...
>
> Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> Next
>
> Thanks,
> -Ted
>
>Â
>


[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



[Non-text portions of this message have been removed]
5
Yeah basically I'd recommend just copying some of the stuff you need into
UDXX and work with that.


*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 Fri, Dec 21, 2012 at 4:17 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> I'm going to have to hard code this in then?
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: Vantage <vantage@yahoogroups.com>
> Sent: Friday, December 21, 2012 4:09 PM
> Subject: Re: [Vantage] Return All Companies With Query
>
>
> You are gonna ahve to do a session mod and change companies to get 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 Fri, Dec 21, 2012 at 3:56 PM, tkoch77 <tkoch77@...> wrote:
>
> > **
>
> >
> >
> > How would I return a list of every company even if the user is not
> > assigned to some companies within user security? I noticed when i run
> this
> > code it only returns all the companies that I am assigned to...
> >
> > Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> > Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> > For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> > EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> > Next
> >
> > Thanks,
> > -Ted
> >
> >
> >
>
> [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]
>
>
>


[Non-text portions of this message have been removed]
6
That sucks. All I want is a list of every company.




________________________________
From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, December 21, 2012 4:28 PM
Subject: Re: [Vantage] Return All Companies With Query

Yeah basically I'd recommend just copying some of the stuff you need into
UDXX and work with that.


*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 Fri, Dec 21, 2012 at 4:17 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> I'm going to have to hard code this in then?
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: Vantage <vantage@yahoogroups.com>
> Sent: Friday, December 21, 2012 4:09 PM
> Subject: Re: [Vantage] Return All Companies With Query
>
>
> You are gonna ahve to do a session mod and change companies to get 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 Fri, Dec 21, 2012 at 3:56 PM, tkoch77 <tkoch77@...> wrote:
>
> > **
>
> >
> >
> > How would I return a list of every company even if the user is not
> > assigned to some companies within user security? I noticed when i run
> this
> > code it only returns all the companies that I am assigned to...
> >
> > Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> > Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> > For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> > EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> > Next
> >
> > Thanks,
> > -Ted
> >
> >
> >
>
> [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]
>
>Â
>


[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



[Non-text portions of this message have been removed]
7
Can you get them in a BAQ? if so you can call the BAQ from code.


*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 Fri, Dec 21, 2012 at 4:31 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> That sucks. All I want is a list of every company.
>
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: Vantage <vantage@yahoogroups.com>
> Sent: Friday, December 21, 2012 4:28 PM
>
> Subject: Re: [Vantage] Return All Companies With Query
>
> Yeah basically I'd recommend just copying some of the stuff you need into
> UDXX and work with that.
>
> *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 Fri, Dec 21, 2012 at 4:17 PM, Ted Koch <tkoch77@...> wrote:
>
> > **
>
> >
> >
> > I'm going to have to hard code this in then?
> >
> > ________________________________
> > From: Jose Gomez <jose@...>
> > To: Vantage <vantage@yahoogroups.com>
> > Sent: Friday, December 21, 2012 4:09 PM
> > Subject: Re: [Vantage] Return All Companies With Query
> >
> >
> > You are gonna ahve to do a session mod and change companies to get 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 Fri, Dec 21, 2012 at 3:56 PM, tkoch77 <tkoch77@...> wrote:
> >
> > > **
> >
> > >
> > >
> > > How would I return a list of every company even if the user is not
> > > assigned to some companies within user security? I noticed when i run
> > this
> > > code it only returns all the companies that I am assigned to...
> > >
> > > Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> > > Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0,
> False)
> > > For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> > > EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> > > Next
> > >
> > > Thanks,
> > > -Ted
> > >
> > >
> > >
> >
> > [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]
> >
> >
> >
>
> [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]
>
>
>


[Non-text portions of this message have been removed]
8
Tried a BAQ, it is behaving the same way.




________________________________
From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, December 21, 2012 4:34 PM
Subject: Re: [Vantage] Return All Companies With Query

Can you get them in a BAQ? if so you can call the BAQ from code.


*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 Fri, Dec 21, 2012 at 4:31 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> That sucks. All I want is a list of every company.
>
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: Vantage <vantage@yahoogroups.com>
> Sent: Friday, December 21, 2012 4:28 PM
>
> Subject: Re: [Vantage] Return All Companies With Query
>
> Yeah basically I'd recommend just copying some of the stuff you need into
> UDXX and work with that.
>
> *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 Fri, Dec 21, 2012 at 4:17 PM, Ted Koch <tkoch77@...> wrote:
>
> > **
>
> >
> >
> > I'm going to have to hard code this in then?
> >
> > ________________________________
> > From: Jose Gomez <jose@...>
> > To: Vantage <vantage@yahoogroups.com>
> > Sent: Friday, December 21, 2012 4:09 PM
> > Subject: Re: [Vantage] Return All Companies With Query
> >
> >
> > You are gonna ahve to do a session mod and change companies to get 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 Fri, Dec 21, 2012 at 3:56 PM, tkoch77 <tkoch77@...> wrote:
> >
> > > **
> >
> > >
> > >
> > > How would I return a list of every company even if the user is not
> > > assigned to some companies within user security? I noticed when i run
> > this
> > > code it only returns all the companies that I am assigned to...
> > >
> > > Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> > > Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0,
> False)
> > > For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> > > EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> > > Next
> > >
> > > Thanks,
> > > -Ted
> > >
> > >
> > >
> >
> > [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]
> >
> >
> >
>
> [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]
>
>Â
>


[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



[Non-text portions of this message have been removed]
9
You could do a direct call to progress from embedded and have it return the list. This bypasses the business objects and talks directly to the database so you can retrieve any data you wish this way.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> How would I return a list of every company even if the user is not assigned to some companies within user security? I noticed when i run this code it only returns all the companies that I am assigned to...
>
> Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> Next
>
> Thanks,
> -Ted
>
10
I don't suppose you would have an example you could share?




________________________________
From: jckinneman <jckinneman@...>
To: vantage@yahoogroups.com
Sent: Friday, December 21, 2012 4:38 PM
Subject: [Vantage] Re: Return All Companies With Query

You could do a direct call to progress from embedded and have it return the list. This bypasses the business objects and talks directly to the database so you can retrieve any data you wish this way.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> How would I return a list of every company even if the user is not assigned to some companies within user security? I noticed when i run this code it only returns all the companies that I am assigned to...
>
> Â Â Â Â Â Â Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> Â Â Â Â Â Â Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> Â Â Â Â Â Â For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> Â Â Â Â Â Â Â Â Â EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> Â Â Â Â Â Â Next
>
> Thanks,
> -Ted
>




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

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]
11
Very rough ;list of things that need to be done. If you are E9, C# is recommended, if on Vantage just need to convert to VB.

///
using Progress.Open4GL.DynamicAPI;

Epicor.Mfg.Core.Session session = (Epicor.Mfg.Core.Session)oTrans.Session;

Progress.Open4GL.DynamicAPI.Session progressSession = session.ConnectionPool.Get();

PersistentProc proc = default(PersistentProc);

// setup a parameter with X being the number of items you will pass over and get back
ParameterSet parms = new ParameterSet(X);

// the next item depends on what you are passing over.

// some string variable called StrValue that is being passed over but not going to be updated
parms.setStringParameter(1, StrValue, ParameterSet.INPUT);
// A datatable that the progress reoutin will be updating
parms.setDataTableParameter(3, dt, ParameterSet.OUTPUT);


proc = progressSession.runPersistentProcedure(@"Name of progress File to run", parms);

// clean up
proc.delete();
session.ConnectionPool.Release(progressSession);

In the progress program you need to have the same number and type of parameters. Beyond that nothing special about the progress routine.

Jim Kinneman
Encompass Solutions, Inc




--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> I don't suppose you would have an example you could share?
>
>
>
>
> ________________________________
> From: jckinneman <jckinneman@...>
> To: vantage@yahoogroups.com
> Sent: Friday, December 21, 2012 4:38 PM
> Subject: [Vantage] Re: Return All Companies With Query
>
> You could do a direct call to progress from embedded and have it return the list. This bypasses the business objects and talks directly to the database so you can retrieve any data you wish this way.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@> wrote:
> >
> > How would I return a list of every company even if the user is not assigned to some companies within user security? I noticed when i run this code it only returns all the companies that I am assigned to...
> >
> > Â Â Â Â Â Â Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> > Â Â Â Â Â Â Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> > Â Â Â Â Â Â For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> > Â Â Â Â Â Â Â Â Â EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> > Â Â Â Â Â Â Next
> >
> > Thanks,
> > -Ted
> >
>
>
>
>
> ------------------------------------
>
> 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]
>
12
Thanks Jim, in order to access the Progress.Open4GL.DynamicAPI namespace what file do I need to reference?




________________________________
From: jckinneman <jckinneman@...>
To: vantage@yahoogroups.com
Sent: Friday, December 21, 2012 5:24 PM
Subject: [Vantage] Re: Return All Companies With Query

Very rough ;list of things that need to be done. If you are E9, C# is recommended, if on Vantage just need to convert to VB.

///
using Progress.Open4GL.DynamicAPI;

Epicor.Mfg.Core.Session session = (Epicor.Mfg.Core.Session)oTrans.Session;

Progress.Open4GL.DynamicAPI.Session progressSession = session.ConnectionPool.Get();

PersistentProc proc = default(PersistentProc);

// setup a parameter with X being the number of items you will pass over and get back
ParameterSet parms = new ParameterSet(X);

// the next item depends on what you are passing over.

// some string variable called StrValue that is being passed over but not going to be updated
parms.setStringParameter(1, StrValue, ParameterSet.INPUT);
// A datatable that the progress reoutin will be updating
parms.setDataTableParameter(3, dt, ParameterSet.OUTPUT);


proc = progressSession.runPersistentProcedure(@"Name of progress File to run", parms);

// clean up
proc.delete();
session.ConnectionPool.Release(progressSession);

In the progress program you need to have the same number and type of parameters. Beyond that nothing special about the progress routine.

Jim Kinneman
Encompass Solutions, Inc




--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> I don't suppose you would have an example you could share?
>
>
>
>
> ________________________________
>Â From: jckinneman <jckinneman@...>
> To: vantage@yahoogroups.com
> Sent: Friday, December 21, 2012 4:38 PM
> Subject: [Vantage] Re: Return All Companies With Query
>Â
> You could do a direct call to progress from embedded and have it return the list. This bypasses the business objects and talks directly to the database so you can retrieve any data you wish this way.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
> --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@> wrote:
> >
> > How would I return a list of every company even if the user is not assigned to some companies within user security? I noticed when i run this code it only returns all the companies that I am assigned to...
> >
> > Â Â Â Â Â Â Dim _company As New Company(ProjectEntryForm.Session.ConnectionPool)
> > Â Â Â Â Â Â Dim _companyDS As CompanyListDataSet = _company.GetList("", 0, 0, False)
> > Â Â Â Â Â Â For i As Integer = 0 To _companyDS.Tables(0).Rows.Count - 1
> > Â Â Â Â Â Â Â Â Â EpiMessageBox.Show(_companyDS.Tables(0).Rows(i)("Company"))
> > Â Â Â Â Â Â Next
> >
> > Thanks,
> > -Ted
> >
>
>
>
>
> ------------------------------------
>
> 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]
>




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

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]