Thanks for botht the suggestions I ended up using the second to pull the data and I can at least display the data in a message to start.
Dim UD102 As Boolean = UD102Adapt.GetByID(key1, key2, key3, key4, key5)
msgbox(UD102Adapt.Ud102Data.Tables("UD102A").Rows(i)("ShortChar01"))
Dim UD102 As Boolean = UD102Adapt.GetByID(key1, key2, key3, key4, key5)
msgbox(UD102Adapt.Ud102Data.Tables("UD102A").Rows(i)("ShortChar01"))
--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
>
>
> The GETBYID will return the parent record and ALL the children so you could filter that return dataset to the record(s) you are interested in.
>
> You can also as mentioned use the GETROWS method.
>
> The signature for this is (hand typed so may not be exact)
>
> GetRows(String WhereClauseUD102, String WhereClauseUD102Attach, String WhereClauseUD102A, int pagesize, int absolutePage, bool morepages)
>
> You would include something like this for the WhereClauseUD102A. Adding as many KeyX values as needed to locate the record you want. The UD102A table has both the Parent (UD102) key values in addtion to its own Keys (ChildKeyX).
>
> Key1 = 'ParentKeyValue' and ChildKey1 = 'specficchildvalue'
>
> A great tool for figuring out which object/method you need to use is the Business Logic Tester that comes with Epicor. Can also be used to update the database, normal cautions apply that only someone that knows what they are doing should use the BL tester for this purpose.
>
> Jim Kinneman
> Senior Consultant
> Encompass Solutions.
>
> --- In vantage@yahoogroups.com, "mmcwilliams22" <mmcwilliams22@> wrote:
> >
> > Yes.
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > Are you doing this on a customization?
> > >
> > > *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/>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > >
> > > On Fri, Jan 28, 2011 at 11:04 AM, mmcwilliams22 <mmcwilliams22@>wrote:
> > >
> > > >
> > > >
> > > > Do you have an example you could share?
> > > > Thanks
> > > >
> > > > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Jose Gomez
> > > > <jose@> wrote:
> > > > >
> > > > > There isn't a direct way to do that.
> > > > >
> > > > > Do a get Rows, with the UD102A where clause
> > > > >
> > > > > *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/>
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > >
> > > > >
> > > > > On Fri, Jan 28, 2011 at 10:51 AM, mmcwilliams22 <mmcwilliams22@
> > > > ...>wrote:
> > > >
> > > > >
> > > > > >
> > > > > >
> > > > > > I am trying to use the Adapter to connect to UD102A and return a
> > > > record,
> > > > > > but I cannot find how to "GetByID" for the child records. Using key1
> > > > and
> > > > > > childkey1 to return.
> > > > > > I do not see a method to call just for the parent. Can this be done or
> > > > do I
> > > > > > need to return the data another way?
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>