[8.03.403x] UD Table Fields as Source of Controls

Yahoo Archive
1
--- In vantage@yahoogroups.com, "gyorkillinois" <gyork@...> wrote:
>
> Has anyone used a UD table to store data that can be displayed and
> maintained from either a standard form or a custom sheet? The Epicor
> Tools User Guide has an excellent example of how to use UD tables as
> the source of a combo box control on a form. Of course, the data is
> maintained via the UD table maintenance screen from the menu. I would
> like to use a UD table to store data that the user can maintain
> directly from controls on a custom sheet. If this is possible, I need
> some help with the code. Certainly many of you could benefit from
this
> use of UD tables. Thank you in advance.
>
> Gary York
>

I actually use UD tables to store several things we need for validation
as well as for custom reporting. To get started just add a menu option
that uses one of the UD tables UI programs, e.g.
Epicor.Mfg.UI.UD01Entry.dll. Start developer mode and then open up
that menu option to customize the UI.
2
Has anyone used a UD table to store data that can be displayed and
maintained from either a standard form or a custom sheet? The Epicor
Tools User Guide has an excellent example of how to use UD tables as
the source of a combo box control on a form. Of course, the data is
maintained via the UD table maintenance screen from the menu. I would
like to use a UD table to store data that the user can maintain
directly from controls on a custom sheet. If this is possible, I need
some help with the code. Certainly many of you could benefit from this
use of UD tables. Thank you in advance.

Gary York
3
Be wary of trusting the exact syntax of the Help file example. In 305I it had some subtle typos/errors in it which may or may not have been corrected in 403.

Your question is too broad to likely get any useful examples that will truly give you an understanding of what is needed (and not just blindly copying code).

Much of the code will be dependant upon what you are trying to accomplish: What are the event triggers (and in what apps)? How does the UD table relate to existing table data (how does the FKV need to be constructed)? Will the customization code populate the data on the fly in the app (presumably saving it also but perhaps not) or are going to preimport the needed data into the UD tables?

I suggest you do a search of the epicor sites to see what UD table related educational docs and/or explanatory example code might currently be out there.

Rob Brown



gyorkillinois <gyork@...> wrote:
Has anyone used a UD table to store data that can be displayed and
maintained from either a standard form or a custom sheet? The Epicor
Tools User Guide has an excellent example of how to use UD tables as
the source of a combo box control on a form. Of course, the data is
maintained via the UD table maintenance screen from the menu. I would
like to use a UD table to store data that the user can maintain
directly from controls on a custom sheet. If this is possible, I need
some help with the code. Certainly many of you could benefit from this
use of UD tables. Thank you in advance.

Gary York






---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]
4
From his question it seems he simply just needs to add the UD table
to the menu & then add the controls to the UD form.

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Be wary of trusting the exact syntax of the Help file example. In
305I it had some subtle typos/errors in it which may or may not have
been corrected in 403.
>
> Your question is too broad to likely get any useful examples
that will truly give you an understanding of what is needed (and not
just blindly copying code).
>
> Much of the code will be dependant upon what you are trying to
accomplish: What are the event triggers (and in what apps)? How does
the UD table relate to existing table data (how does the FKV need to
be constructed)? Will the customization code populate the data on
the fly in the app (presumably saving it also but perhaps not) or
are going to preimport the needed data into the UD tables?
>
> I suggest you do a search of the epicor sites to see what UD
table related educational docs and/or explanatory example code might
currently be out there.
>
> Rob Brown
>
>
>
> gyorkillinois <gyork@...> wrote:
> Has anyone used a UD table to store data that can be
displayed and
> maintained from either a standard form or a custom sheet? The
Epicor
> Tools User Guide has an excellent example of how to use UD tables
as
> the source of a combo box control on a form. Of course, the data
is
> maintained via the UD table maintenance screen from the menu. I
would
> like to use a UD table to store data that the user can maintain
> directly from controls on a custom sheet. If this is possible, I
need
> some help with the code. Certainly many of you could benefit from
this
> use of UD tables. Thank you in advance.
>
> Gary York
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo!
Mobile. Try it now.
>
> [Non-text portions of this message have been removed]
>
5
I've created the UD table and added it to the menu as required. What I
really want to do is add controls (date fields) to my custom sheet under
the Order Detail screen. The user would enter the dates to the controls
(dteEpiCustomxx) on the sheet and it would add them to the UD table.
They need the ability to add, change or delete the dates in the UD table
via the custom sheet. Once the dates are entered, they should be
displayed each time the sheet is opened. The non date fields on the
sheet are sourced from the OrderDtl adapter, which may be a problem
(mixing "apples and oranges").



I have searched every source I could think of (class books, HELP,
Vantage web site, other web sites, etc.) and have found no mention of
using UD table this way. Neither have I found any code samples.



Thank you,

Gary York



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Thursday, January 17, 2008 11:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [8.03.403x] UD Table Fields as Source of Controls



From his question it seems he simply just needs to add the UD table
to the menu & then add the controls to the UD form.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Robert Brown <robertb_versa@...>
wrote:
>
> Be wary of trusting the exact syntax of the Help file example. In
305I it had some subtle typos/errors in it which may or may not have
been corrected in 403.
>
> Your question is too broad to likely get any useful examples
that will truly give you an understanding of what is needed (and not
just blindly copying code).
>
> Much of the code will be dependant upon what you are trying to
accomplish: What are the event triggers (and in what apps)? How does
the UD table relate to existing table data (how does the FKV need to
be constructed)? Will the customization code populate the data on
the fly in the app (presumably saving it also but perhaps not) or
are going to preimport the needed data into the UD tables?
>
> I suggest you do a search of the epicor sites to see what UD
table related educational docs and/or explanatory example code might
currently be out there.
>
> Rob Brown
>
>
>
> gyorkillinois <gyork@...> wrote:
> Has anyone used a UD table to store data that can be
displayed and
> maintained from either a standard form or a custom sheet? The
Epicor
> Tools User Guide has an excellent example of how to use UD tables
as
> the source of a combo box control on a form. Of course, the data
is
> maintained via the UD table maintenance screen from the menu. I
would
> like to use a UD table to store data that the user can maintain
> directly from controls on a custom sheet. If this is possible, I
need
> some help with the code. Certainly many of you could benefit from
this
> use of UD tables. Thank you in advance.
>
> Gary York
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo!
Mobile. Try it now.
>
> [Non-text portions of this message have been removed]
>





--------------------------------------------------------------------------
*-* This e-mail is intended for use only by the person(s) to whom it is addressed. This e-mail may contain confidential information. If you have received this e-mail in error, please notify the sender immediately by reply e-mail, then delete this message from your system. Please do not copy this message or use it for any purpose, or disclose its contents to any person. Thank you for your assistance.


[Non-text portions of this message have been removed]
6
Maybe I am missing something...
But doesnt the OrderDtl table have 20 'spare' date fields that could
be used to store the data you need and then that data is part of the
OrderDtl record without the use of a UD table?

bw
--- In vantage@yahoogroups.com, "Gary York" <gyork@...> wrote:
>
> I've created the UD table and added it to the menu as required.
What I
> really want to do is add controls (date fields) to my custom sheet
under
> the Order Detail screen. The user would enter the dates to the
controls
> (dteEpiCustomxx) on the sheet and it would add them to the UD table.
> They need the ability to add, change or delete the dates in the UD
table
> via the custom sheet. Once the dates are entered, they should be
> displayed each time the sheet is opened. The non date fields on the
> sheet are sourced from the OrderDtl adapter, which may be a problem
> (mixing "apples and oranges").
>
>
>
> I have searched every source I could think of (class books, HELP,
> Vantage web site, other web sites, etc.) and have found no mention
of
> using UD table this way. Neither have I found any code samples.
>
>
>
> Thank you,
>
> Gary York
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Michael McWilliams
> Sent: Thursday, January 17, 2008 11:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: [8.03.403x] UD Table Fields as Source of
Controls
>
>
>
> From his question it seems he simply just needs to add the UD table
> to the menu & then add the controls to the UD form.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> Robert Brown <robertb_versa@>
> wrote:
> >
> > Be wary of trusting the exact syntax of the Help file example. In
> 305I it had some subtle typos/errors in it which may or may not
have
> been corrected in 403.
> >
> > Your question is too broad to likely get any useful examples
> that will truly give you an understanding of what is needed (and
not
> just blindly copying code).
> >
> > Much of the code will be dependant upon what you are trying to
> accomplish: What are the event triggers (and in what apps)? How
does
> the UD table relate to existing table data (how does the FKV need
to
> be constructed)? Will the customization code populate the data on
> the fly in the app (presumably saving it also but perhaps not) or
> are going to preimport the needed data into the UD tables?
> >
> > I suggest you do a search of the epicor sites to see what UD
> table related educational docs and/or explanatory example code
might
> currently be out there.
> >
> > Rob Brown
> >
> >
> >
> > gyorkillinois <gyork@> wrote:
> > Has anyone used a UD table to store data that can be
> displayed and
> > maintained from either a standard form or a custom sheet? The
> Epicor
> > Tools User Guide has an excellent example of how to use UD tables
> as
> > the source of a combo box control on a form. Of course, the data
> is
> > maintained via the UD table maintenance screen from the menu. I
> would
> > like to use a UD table to store data that the user can maintain
> > directly from controls on a custom sheet. If this is possible, I
> need
> > some help with the code. Certainly many of you could benefit from
> this
> > use of UD tables. Thank you in advance.
> >
> > Gary York
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Be a better friend, newshound, and know-it-all with Yahoo!
> Mobile. Try it now.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> --------------------------------------------------------------------
------
> *-* This e-mail is intended for use only by the person(s) to whom
it is addressed. This e-mail may contain confidential information. If
you have received this e-mail in error, please notify the sender
immediately by reply e-mail, then delete this message from your
system. Please do not copy this message or use it for any purpose, or
disclose its contents to any person. Thank you for your assistance.
>
>
> [Non-text portions of this message have been removed]
>
7
Hi Gary

I'm not sure how far you have gotten but here's what you need to do to
get started.

1) If you want to use UD01 go to menu maintenance create a new menu
item. In the program field select or enter Epicor.mfg.UI.UD01Entry.dll.
DO NOT ENTER THE ENTIRE PATH NAME.

2) Save, log off / log on

3) In Developer mode open the new menu item and create your
customization. Initially it starts off with fields for key01 thru 05.
Using the tool box add other fields and set the data source to ud01 and
fields to whichever you want.

4) Save customization. Log off / log on.



You can now enter data in this new menu item. If you want to access
this data or enter it from another point in Vantage like from a form
which is launched from a button you need to do a little more.



1) For a button to open the customization you need to create a sub
process. The code for the button will run this process. You create a
sub process in Sub Process Maintenance. The Process ID is what the
button code will reference so remember what you enter here.

a. Select Non Menu Item as the type

b. "Epicor.Mfg.UI.UD01Entry.dll" as the program. DO NOT ENTER THE
ENTIRE PATH NAME.

c. Select the customization you created in step 3 above.

d. Save and exit.

2) Create a custom button on a form somewhere. In this example a
button is created on the DMR Processing screen. The code for the button
should look something like this. In this code Udsub101 is the process
id created earlier in sub process maintenance .



Try

'// create launch form options

Dim lfo as LaunchFormOptions = New LaunchFormOptions()

lfo.ValueIn = strDMRNum



'// variable for return value of process call

Dim rValue as boolean



'// call the process that launches the form

'// Dim [varName] As Object =
ProcessCaller.LaunchForm(Sender, AssemblyName, launchObject, returnVal)

Dim myForm As Object = ProcessCaller.LaunchForm(oTrans,
"udsub101", lfo, rValue)



'// any errors will execute the following code and message

catch ex as exception

messagebox.show(ex.message, "Invalid DMR Number!")

end try





Hope this helps

Mark





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of gyorkillinois
Sent: Thursday, January 17, 2008 11:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [8.03.403x] UD Table Fields as Source of Controls



Has anyone used a UD table to store data that can be displayed and
maintained from either a standard form or a custom sheet? The Epicor
Tools User Guide has an excellent example of how to use UD tables as
the source of a combo box control on a form. Of course, the data is
maintained via the UD table maintenance screen from the menu. I would
like to use a UD table to store data that the user can maintain
directly from controls on a custom sheet. If this is possible, I need
some help with the code. Certainly many of you could benefit from this
use of UD tables. Thank you in advance.

Gary York





[Non-text portions of this message have been removed]
8
Good point, but the user wants 36 date fields (don't ask why).

The "bigger picture" is the use of UD tables to store data that can be
added, changed & deleted from a Vantage standard screen or a custom
sheet. If it can be done, and I think it can, this has tremendous
potential.

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Maybe I am missing something...
> But doesnt the OrderDtl table have 20 'spare' date fields that could
> be used to store the data you need and then that data is part of the
> OrderDtl record without the use of a UD table?
>
> bw
9
Maybe these will help. You have to make sur eyou add the custom
assemblies to the cusomization.

This will create a new record with watever variable you use
and then populate the character01 with whatever you want.
Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
Dim udConnected As Boolean = udAdapter.BOConnect()
Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
udAdapter.Update()

This will let you read the data from UD01 table
Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
ud01Adapt.BOConnect()
Dim key1 As String = TBLot.ToString()
Dim key2 As String = String.Empty
Dim key3 As String = String.Empty
Dim key4 As String = String.Empty
Dim key5 As String = String.Empty
Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
key5)
If UD01 Then
variable = UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
uda01Adapt.dispose()

--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> --- In vantage@yahoogroups.com, "gyorkillinois" <gyork@> wrote:
> >
> > Good point, but the user wants 36 date fields (don't ask why).
> >
> > The "bigger picture" is the use of UD tables to store data that
> can be
> > added, changed & deleted from a Vantage standard screen or a
> custom
> > sheet. If it can be done, and I think it can, this has
tremendous
> > potential.
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > >
> > > Maybe I am missing something...
> > > But doesnt the OrderDtl table have 20 'spare' date fields that
> could
> > > be used to store the data you need and then that data is part
of
> the
> > > OrderDtl record without the use of a UD table?
> > >
> > > bw
> >
>