Jose and Bryan,
I'll be working on it in the next few days and will post back.
Thank you both for your thoughts and examples,
Dave
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Wednesday, April 06, 2011 12:12 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Question on BO call
I believe this will accomplish what you want... with minor updates
LaborAdapter laborAdpt = new LaborAdapter(oTrans);
laborAdpt.BOConnect();
bool morePages;
SearchOptions opts = new SearchOptions(SearchMode.AutoSearch);
opts.NamedSearch.WhereClauses.Add("LaborDtl", String.Format("Where CLAUSE HERE")); opts.DataSetMode = DataSetMode.RowsDataSet; LaborDataSet laborDS = (LaborDataSet)laborAdpt.GetRows(opts, out morePages); foreach(LaborDataSet.LaborHedRow ldtr in laborDS.LaborHed) { laborAdpt.GetByID(ldtr.LaborHedSeq);
for (int i =0; i < laborAdpt.LaborData.LaborDtl.Count;i++)
{
laborAdpt.LaborData.LaborDtl[i]["ColumnName"]="newValue";
}
laborAdpt.Update();
}
*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?*
I'll be working on it in the next few days and will post back.
Thank you both for your thoughts and examples,
Dave
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Wednesday, April 06, 2011 12:12 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Question on BO call
I believe this will accomplish what you want... with minor updates
LaborAdapter laborAdpt = new LaborAdapter(oTrans);
laborAdpt.BOConnect();
bool morePages;
SearchOptions opts = new SearchOptions(SearchMode.AutoSearch);
opts.NamedSearch.WhereClauses.Add("LaborDtl", String.Format("Where CLAUSE HERE")); opts.DataSetMode = DataSetMode.RowsDataSet; LaborDataSet laborDS = (LaborDataSet)laborAdpt.GetRows(opts, out morePages); foreach(LaborDataSet.LaborHedRow ldtr in laborDS.LaborHed) { laborAdpt.GetByID(ldtr.LaborHedSeq);
for (int i =0; i < laborAdpt.LaborData.LaborDtl.Count;i++)
{
laborAdpt.LaborData.LaborDtl[i]["ColumnName"]="newValue";
}
laborAdpt.Update();
}
*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 Wed, Apr 6, 2011 at 11:58 AM, Jose Gomez <jose@...> wrote:
> Sure you can, but it is the exact same thing, you still need to call
> the GetByID or GetRows and plus you consume an extra licence...
>
> *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 Wed, Apr 6, 2011 at 11:50 AM, bsapot <bsapot@...> wrote:
>
>>
>>
>> You can connect a BO without an adapter. You have to pull the Session
>> object from the form you are using and instantiate the BO using that.
>>
>> Here is a link to a customization I did without using the adapter
>> including some sample code:
>>
>> http://www.datixinc.com/wordpress/2011/03/automatic-pack-slip-number-
>> generation/
>>
>> In the sample I'm using Company but you could easily substitute LaborDtl.
>>
>> Let me know if that helps.
>>
>> Regards,
>>
>> Bryan
>>
>> Bryan Sapot
>> President
>> Datix, Inc
>> www.datixinc.com
>>
>>
>> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>> >
>> > Here is an example on using GetRows on a UD table but should work
>> > the
>> same
>> > way for any other module
>> > UD100Adapter ud100Adapter = new UD100Adapter(oTrans);
>> > ud100Adapter.BOConnect(); bool morePages; SearchOptions opts = new
>> > SearchOptions(SearchMode.AutoSearch);
>> > //Replace this search clause witht he LaborDtl one
>> > opts.NamedSearch.WhereClauses.Add("UD100",
>> > String.Format("UD100.Key2 =
>> '{0}'
>> > AND CheckBox03=false", custNum.ToString())); opts.DataSetMode =
>> > DataSetMode.RowsDataSet; UD100DataSet ud100ds =
>> > (UD100DataSet)ud100Adapter.GetRows(opts, out morePages); foreach
>> > (UD100DataSet.UD100Row r in ud100ds.UD100) { //Do something here }
>> >
>> >
>> > Hope this helps
>> >
>> > *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 Wed, Apr 6, 2011 at 8:09 AM, Jose Gomez <jose@...> wrote:
>> >
>> > > None of the Dtl datatables have a BO directly they are all
>> > > accessed
>> through
>> > > the main BO in your case Labor
>> > > you'll nned
>> > >
>> > > Epicor.Mfg.IF.Labor
>> > > Epicor.Mfg.BO.Labor
>> > > Epicor.Mfg.AD.Labor
>> > >
>> > > then you can use the get rows method and pass null or empty
>> > > strings everywhere except the LaborDtl where clause this will
>> > > return a fairly large dataset which includes the LaborHed
>> amongst
>> > > others but you can still loop through the Dtl's and change the
>> > > values
>> > >
>> > > then call the Update Method.
>> > >
>> > > Hope that was clear enough. I'll try to find an example for you
>> > > in a
>> fwe
>> > > mins when I get in the office.
>> > >
>> > >
>> > > *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 Wed, Apr 6, 2011 at 7:54 AM, David Beberman <dbeberman@...
>>
>> > > > wrote:
>> > >
>> > >>
>> > >>
>> > >> Jose, thanks for the reply.
>> > >>
>> > >> I'm trying to read in a set of LaborDtl rows (filtered by a
>> > >> Where
>> clause),
>> > >> update some fields in the dataset, then update the dataset to disk.
>> > >>
>> > >> My issue is that I don't believe an Adapter exists for the
>> BO.LaborDtl.dll
>> > >> - its not in my client folder.
>> > >>
>> > >> An IF and BO exists, just not an AD.
>> > >>
>> > >> As an alternate to this BO, I looked into BO.Labor.dll, which
>> > >> does
>> return
>> > >> a dataset with much more than I need (for this use anyway).
>> > >>
>> > >> The Getrows in Labor.dll has 8-10 possible where clauses to pass
>> > >> into
>> it.
>> > >>
>> > >> I've been using the BL tester tool to try to find the right way
>> > >> to
>> form
>> > >> the call to Getrows (filter the Detail gathered but return any
>> related
>> > >> header row).
>> > >>
>> > >> I'm having trouble in getting results that I need - do you have
>> > >> an
>> example
>> > >> from something you may have done ?
>> > >>
>> > >> Thanks again,
>> > >> Dave
>> > >>
>> > >>
>> > >> -----Original Message-----
>> > >> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
>> > >> On
>> Behalf
>> > >> Of Jose Gomez
>> > >> Sent: Wednesday, April 06, 2011 7:35 AM
>> > >> To: vantage@yahoogroups.com
>> > >> Subject: Re: [Vantage] Question on BO call
>> > >>
>> > >> To make an update to ANY BO you need the AD and BO dll's
>> > >> included in
>> your
>> > >> Script
>> > >>
>> > >> Then you connect to the adapter using the current form OTrans
>> > >>
>> > >> then you use the standard methods to get and put data sych as
>> > >>
>> > >> GetByID to get the record yoiu want
>> > >>
>> > >> Adapter.AdapterData.Table[Row][Column]="SOMETHING" to set a
>> > >> value
>> > >>
>> > >> then Adapter.Update() will update the data you added / changed
>> > >>
>> > >> If you are trying to create a new record you need to first use
>> > >> the GetNewLaborDtl method...
>> > >>
>> > >> Not sure what problems you are running into with the search
>> > >> criteria
>> being
>> > >> too limited....??
>> > >>
>> > >> *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 Tue, Apr 5, 2011 at 5:55 PM, davidbeberman <dbeberman@...
>>
>> > >> >wrote:
>> > >>
>> > >> >
>> > >> >
>> > >> > Hi All,
>> > >> >
>> > >> > I'm trying to find the best way to make an update to the
>> > >> > LaborDtl table within a customization.
>> > >> >
>> > >> > The program im customizing has nothing to do with LaborDtl - I
>> > >> > am using it as a shell to start Utility Scripts in code.
>> > >> >
>> > >> > I've located a BO using the BL tester tool called
>> > >> > Bo.LaborDtl.dll
>> but
>> > >> > this has no AD(adapter for BOConnect) to connect with.
>> > >> >
>> > >> > A BO.Labor.dll exists which allows for header/detail retrieval
>> > >> > (has
>> an
>> > >> > AD) but the Search parameters are very inefficient to just
>> > >> > bring in
>> a
>> > >> > subset of filtered detail rows with open header criteria.
>> > >> >
>> > >> > Any suggestions ?
>> > >> >
>> > >> > Thank you,
>> > >> > Dave Beberman
>> > >> > Sr. Business Analyst
>> > >> > Ferguson Perforating
>> > >> >
>> > >> > Im using vb.net code customizing 9.0.5.602A.
>> > >> >
>> > >> > P.S. There is an undocumented method called
>> > >> > InvokeAssemblyMethod within iCustomScriptManager that looks
>> > >> > like a possibility but I
>> cant
>> > >> > find anything about it. I have an open call with support on
>> > >> > this -
>> has
>> > >> anyone used it?
>> > >> >
>> > >> >
>> > >> >
>> > >>
>> > >> [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
>> > >>
>> > >> --------------------------------- This e-mail and any
>> > >> attachments may contain confidential and privileged information.
>> > >> If you are not the intended recipient, please notify the sender
>> > >> immediately by return e-mail, delete this e-mail and destroy any
>> > >> copies. Any dissemination or use of this information by a person
>> > >> other than the intended recipient is unauthorized and may be
>> > >> illegal.
>> > >>
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>> > [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
---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.