Calling UD Form - Multiple Keys

Yahoo Archive
1
Hi,

Thanks for the below, I wasn't aware that hashing was available. I
will see if I can use that .

Thanks again for the insights.



--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I think you might be out of luck there. I tried creating a
hashtable
> of values to send as value in, and an array to send as value in.
> Neither worked.
>
> I guess you can go the 'Brute Force' way of doing it.
> Create a blank panel in your form, add appropriate adapters
display,
> enter the data needed for your UD table in that panel without
> invoking the UD Form.
>
> That is what we have done on our Part Entry form to display, add,
> edit, delete UD10 data which we are using as our Manufacturer's
Part
> Number info (Can't wait to see that functionality in 9)
>
> bw
>
> --- In vantage@yahoogroups.com, "brychanwilliams"
> <brychanwilliams@> wrote:
> >
> > Hi,
> >
> > Thanks for the below, I use the method below but I can't work out
> how
> > to pass multiple keys to the process caller. I am not sure if can
> be
> > done or not but it would seem strange if it can't .
> >
> > Thanks again.
> >
> > --- In vantage@yahoogroups.com, "mretzlercooper" <mretzler@>
wrote:
> > >
> > > This is how I launch a the UD11 form from SalesOrderForm with a
> > value
> > > being passed in (I only use Key1 in UD11)
> > >
> > > Dim lfo As LaunchFormOptions = New LaunchFormOptions()
> > > lfo.IsModal = true
> > > lfo.SuppressFormSearch = true
> > > lfo.ValueIn = "UD11KeyOfRecordIWantToDisplay"
> > > lfo.SuppressFormSearch = true
> > > ProcessCaller.LaunchForm
> (SalesOrderForm, "Epicor.Mfg.UI.UD11Entry",
> > > lfo)
> > >
> > >
> > > I am not sure if you can set ValueIn to an array of values or
> > > something, but you may want to look closer at that.
> > >
> > > --- In vantage@yahoogroups.com, "brychanwilliams"
> > > <brychanwilliams@> wrote:
> > > >
> > > > Hi, Thanks for the prompt reply. I have should have been
> clearer.
> > > >
> > > > What I want to achieve is the following;
> > > >
> > > > 1) In Project Entry, at a button click, create a project
budget
> > > > create the records as below. I can do that and then launch
the
> > form
> > > > so the that the rest of the information can be filled out.
> > > > 2) As the budget changes affectively new records will be
> entered.
> > > >
> > > > I am using processcaller.launchform statements...
> > > >
> > > > Thanks again.
> > > >
> > > > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > > > >
> > > > > Not sure how you are calling in the UD data, but the
GetList
> > > method
> > > > and
> > > > > GetRows method both take a query "Key1 = 'abc' AND Key2
> = 'xyz'
> > > AND
> > > > > Key3 = 'Open'"
> > > > >
> > > > > The listLookup will use the same kind of query in the
> > whereClause
> > > > >
> > > > > bw
> > > > >
> > > > > --- In vantage@yahoogroups.com, "brychanwilliams"
> > > > <brychanwilliams@>
> > > > > wrote:
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I am trying to use a UD table to store multiple versions
of
> a
> > > > project
> > > > > > Budgets. I was planning to use Key 1 as the project
code ,
> > Key
> > > 2
> > > > as
> > > > > the
> > > > > > project budget type and key 3 as the budget status.
> > > > > >
> > > > > > I can call the UD form from the project entry screen if I
> > just
> > > > use
> > > > > key1
> > > > > > but I would like more control and be able to pass all
three
> > > keys
> > > > > > through. My mind is a blank on this...
> > > > > >
> > > > > > Thanks for any help in advance.
> > > > > >
> > > > >
> > > >
> > >
> >
>
2
Hi,

I am trying to use a UD table to store multiple versions of a project
Budgets. I was planning to use Key 1 as the project code , Key 2 as the
project budget type and key 3 as the budget status.

I can call the UD form from the project entry screen if I just use key1
but I would like more control and be able to pass all three keys
through. My mind is a blank on this...

Thanks for any help in advance.
3
Not sure how you are calling in the UD data, but the GetList method and
GetRows method both take a query "Key1 = 'abc' AND Key2 = 'xyz' AND
Key3 = 'Open'"

The listLookup will use the same kind of query in the whereClause

bw

--- In vantage@yahoogroups.com, "brychanwilliams" <brychanwilliams@...>
wrote:
>
> Hi,
>
> I am trying to use a UD table to store multiple versions of a project
> Budgets. I was planning to use Key 1 as the project code , Key 2 as
the
> project budget type and key 3 as the budget status.
>
> I can call the UD form from the project entry screen if I just use
key1
> but I would like more control and be able to pass all three keys
> through. My mind is a blank on this...
>
> Thanks for any help in advance.
>
4
Hi, Thanks for the prompt reply. I have should have been clearer.

What I want to achieve is the following;

1) In Project Entry, at a button click, create a project budget
create the records as below. I can do that and then launch the form
so the that the rest of the information can be filled out.
2) As the budget changes affectively new records will be entered.

I am using processcaller.launchform statements...

Thanks again.

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Not sure how you are calling in the UD data, but the GetList method
and
> GetRows method both take a query "Key1 = 'abc' AND Key2 = 'xyz' AND
> Key3 = 'Open'"
>
> The listLookup will use the same kind of query in the whereClause
>
> bw
>
> --- In vantage@yahoogroups.com, "brychanwilliams"
<brychanwilliams@>
> wrote:
> >
> > Hi,
> >
> > I am trying to use a UD table to store multiple versions of a
project
> > Budgets. I was planning to use Key 1 as the project code , Key 2
as
> the
> > project budget type and key 3 as the budget status.
> >
> > I can call the UD form from the project entry screen if I just
use
> key1
> > but I would like more control and be able to pass all three keys
> > through. My mind is a blank on this...
> >
> > Thanks for any help in advance.
> >
>
5
This is how I launch a the UD11 form from SalesOrderForm with a value
being passed in (I only use Key1 in UD11)

Dim lfo As LaunchFormOptions = New LaunchFormOptions()
lfo.IsModal = true
lfo.SuppressFormSearch = true
lfo.ValueIn = "UD11KeyOfRecordIWantToDisplay"
lfo.SuppressFormSearch = true
ProcessCaller.LaunchForm(SalesOrderForm, "Epicor.Mfg.UI.UD11Entry",
lfo)


I am not sure if you can set ValueIn to an array of values or
something, but you may want to look closer at that.

--- In vantage@yahoogroups.com, "brychanwilliams"
<brychanwilliams@...> wrote:
>
> Hi, Thanks for the prompt reply. I have should have been clearer.
>
> What I want to achieve is the following;
>
> 1) In Project Entry, at a button click, create a project budget
> create the records as below. I can do that and then launch the form
> so the that the rest of the information can be filled out.
> 2) As the budget changes affectively new records will be entered.
>
> I am using processcaller.launchform statements...
>
> Thanks again.
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > Not sure how you are calling in the UD data, but the GetList
method
> and
> > GetRows method both take a query "Key1 = 'abc' AND Key2 = 'xyz'
AND
> > Key3 = 'Open'"
> >
> > The listLookup will use the same kind of query in the whereClause
> >
> > bw
> >
> > --- In vantage@yahoogroups.com, "brychanwilliams"
> <brychanwilliams@>
> > wrote:
> > >
> > > Hi,
> > >
> > > I am trying to use a UD table to store multiple versions of a
> project
> > > Budgets. I was planning to use Key 1 as the project code , Key
2
> as
> > the
> > > project budget type and key 3 as the budget status.
> > >
> > > I can call the UD form from the project entry screen if I just
> use
> > key1
> > > but I would like more control and be able to pass all three
keys
> > > through. My mind is a blank on this...
> > >
> > > Thanks for any help in advance.
> > >
> >
>
6
Hi,

Thanks for the below, I use the method below but I can't work out how
to pass multiple keys to the process caller. I am not sure if can be
done or not but it would seem strange if it can't .

Thanks again.

--- In vantage@yahoogroups.com, "mretzlercooper" <mretzler@...> wrote:
>
> This is how I launch a the UD11 form from SalesOrderForm with a
value
> being passed in (I only use Key1 in UD11)
>
> Dim lfo As LaunchFormOptions = New LaunchFormOptions()
> lfo.IsModal = true
> lfo.SuppressFormSearch = true
> lfo.ValueIn = "UD11KeyOfRecordIWantToDisplay"
> lfo.SuppressFormSearch = true
> ProcessCaller.LaunchForm(SalesOrderForm, "Epicor.Mfg.UI.UD11Entry",
> lfo)
>
>
> I am not sure if you can set ValueIn to an array of values or
> something, but you may want to look closer at that.
>
> --- In vantage@yahoogroups.com, "brychanwilliams"
> <brychanwilliams@> wrote:
> >
> > Hi, Thanks for the prompt reply. I have should have been clearer.
> >
> > What I want to achieve is the following;
> >
> > 1) In Project Entry, at a button click, create a project budget
> > create the records as below. I can do that and then launch the
form
> > so the that the rest of the information can be filled out.
> > 2) As the budget changes affectively new records will be entered.
> >
> > I am using processcaller.launchform statements...
> >
> > Thanks again.
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > >
> > > Not sure how you are calling in the UD data, but the GetList
> method
> > and
> > > GetRows method both take a query "Key1 = 'abc' AND Key2 = 'xyz'
> AND
> > > Key3 = 'Open'"
> > >
> > > The listLookup will use the same kind of query in the
whereClause
> > >
> > > bw
> > >
> > > --- In vantage@yahoogroups.com, "brychanwilliams"
> > <brychanwilliams@>
> > > wrote:
> > > >
> > > > Hi,
> > > >
> > > > I am trying to use a UD table to store multiple versions of a
> > project
> > > > Budgets. I was planning to use Key 1 as the project code ,
Key
> 2
> > as
> > > the
> > > > project budget type and key 3 as the budget status.
> > > >
> > > > I can call the UD form from the project entry screen if I
just
> > use
> > > key1
> > > > but I would like more control and be able to pass all three
> keys
> > > > through. My mind is a blank on this...
> > > >
> > > > Thanks for any help in advance.
> > > >
> > >
> >
>
7
I think you might be out of luck there. I tried creating a hashtable
of values to send as value in, and an array to send as value in.
Neither worked.

I guess you can go the 'Brute Force' way of doing it.
Create a blank panel in your form, add appropriate adapters display,
enter the data needed for your UD table in that panel without
invoking the UD Form.

That is what we have done on our Part Entry form to display, add,
edit, delete UD10 data which we are using as our Manufacturer's Part
Number info (Can't wait to see that functionality in 9)

bw

--- In vantage@yahoogroups.com, "brychanwilliams"
<brychanwilliams@...> wrote:
>
> Hi,
>
> Thanks for the below, I use the method below but I can't work out
how
> to pass multiple keys to the process caller. I am not sure if can
be
> done or not but it would seem strange if it can't .
>
> Thanks again.
>
> --- In vantage@yahoogroups.com, "mretzlercooper" <mretzler@> wrote:
> >
> > This is how I launch a the UD11 form from SalesOrderForm with a
> value
> > being passed in (I only use Key1 in UD11)
> >
> > Dim lfo As LaunchFormOptions = New LaunchFormOptions()
> > lfo.IsModal = true
> > lfo.SuppressFormSearch = true
> > lfo.ValueIn = "UD11KeyOfRecordIWantToDisplay"
> > lfo.SuppressFormSearch = true
> > ProcessCaller.LaunchForm
(SalesOrderForm, "Epicor.Mfg.UI.UD11Entry",
> > lfo)
> >
> >
> > I am not sure if you can set ValueIn to an array of values or
> > something, but you may want to look closer at that.
> >
> > --- In vantage@yahoogroups.com, "brychanwilliams"
> > <brychanwilliams@> wrote:
> > >
> > > Hi, Thanks for the prompt reply. I have should have been
clearer.
> > >
> > > What I want to achieve is the following;
> > >
> > > 1) In Project Entry, at a button click, create a project budget
> > > create the records as below. I can do that and then launch the
> form
> > > so the that the rest of the information can be filled out.
> > > 2) As the budget changes affectively new records will be
entered.
> > >
> > > I am using processcaller.launchform statements...
> > >
> > > Thanks again.
> > >
> > > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > > >
> > > > Not sure how you are calling in the UD data, but the GetList
> > method
> > > and
> > > > GetRows method both take a query "Key1 = 'abc' AND Key2
= 'xyz'
> > AND
> > > > Key3 = 'Open'"
> > > >
> > > > The listLookup will use the same kind of query in the
> whereClause
> > > >
> > > > bw
> > > >
> > > > --- In vantage@yahoogroups.com, "brychanwilliams"
> > > <brychanwilliams@>
> > > > wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I am trying to use a UD table to store multiple versions of
a
> > > project
> > > > > Budgets. I was planning to use Key 1 as the project code ,
> Key
> > 2
> > > as
> > > > the
> > > > > project budget type and key 3 as the budget status.
> > > > >
> > > > > I can call the UD form from the project entry screen if I
> just
> > > use
> > > > key1
> > > > > but I would like more control and be able to pass all three
> > keys
> > > > > through. My mind is a blank on this...
> > > > >
> > > > > Thanks for any help in advance.
> > > > >
> > > >
> > >
> >
>