Hello!
It sounds like you have a solution, but I wanted to share my notes on this. I just documented how we assign an epicombo to the User Codes table. I hope it helps someone!
Naomi
In this scenario, we are adding a "Purchase Day" to the supplier record, so we can sort suggestions to buy by this purchase day. Some of our suppliers only allow us to order once a week...
Steps taken:
1. System Management > Utilities > User Codes
1. Created New Code Type - Weekdays
1.
Populated with each day of the week - ID 1MONDAY, Desc Monday, etc.
1. System Management > Utilities > Extended Properties (I found this is not necessary to work, but it keeps things clean)
1. Open Vendor Table
1.
Go to ShortChar02
1. Fields > Detail
1.
Set UD Code Type to Weekdays
2. Label: Purchase Day
1. Open supplier window with developer mode on.
2. Chose the BDSVendor Customization (whatever customization you may have live - or a new one if needed)
3. Tools, Customization
4. Drag an EpiCombo to the form.
1. Resized and renamed cmbPurchaseDay
1. Fields:
EpiBinding - EpiBinding VendorDetail.ShortChar02 - where the data gets written to
EpiCombo Section:
DisplayMember - CodeDesc
EpiBOName - UserCodes
EpiColumns - String[] Array - Be sure to click the "…" and type in CodeDesc in the pop up window!
EpiDataSetMode - RowsDataSet
EpiFieldName - (blank)
EpiHiddenColumnsAppend - String [] Array
EpiSort - CodeID (The codeIDs and CodeDescs are as follows respectively - 1MONDAY - Monday, 2TUESDAY - Tuesday, etc.) I did this on purpose so I could sort in the proper order. Another idea is to assign a ud field as a sequence number and sort on that if we want to stay away from "smart" IDs.
EpiStaticDataList - String [] Array
EpiTableName - UDCodes
RetrieveOnActivate - True
ValueMember - CodeID
EpiControl
EpicContextMenuKey - Blank
EpiKeyField - False
EpiLabel - lblPurchaseDay
EpiFilter
EpiFilters - String[] Array
EpiFiltersAppend - String[] Array
EpiFiltersParams - String[] Array
SearchFilter - CodeTypeID = 'Weekdays'
1. In the ToolBox click EpiLabel
1. Put next to the combo box
2. Size to match the others
3. Rename lblPurchaseDay
4. Text - Purchase Day:
5. Click New Combo box
6. Go to Epilabel - chose lblPurchaseDay
It sounds like you have a solution, but I wanted to share my notes on this. I just documented how we assign an epicombo to the User Codes table. I hope it helps someone!
Naomi
In this scenario, we are adding a "Purchase Day" to the supplier record, so we can sort suggestions to buy by this purchase day. Some of our suppliers only allow us to order once a week...
Steps taken:
1. System Management > Utilities > User Codes
1. Created New Code Type - Weekdays
1.
Populated with each day of the week - ID 1MONDAY, Desc Monday, etc.
1. System Management > Utilities > Extended Properties (I found this is not necessary to work, but it keeps things clean)
1. Open Vendor Table
1.
Go to ShortChar02
1. Fields > Detail
1.
Set UD Code Type to Weekdays
2. Label: Purchase Day
1. Open supplier window with developer mode on.
2. Chose the BDSVendor Customization (whatever customization you may have live - or a new one if needed)
3. Tools, Customization
4. Drag an EpiCombo to the form.
1. Resized and renamed cmbPurchaseDay
1. Fields:
EpiBinding - EpiBinding VendorDetail.ShortChar02 - where the data gets written to
EpiCombo Section:
DisplayMember - CodeDesc
EpiBOName - UserCodes
EpiColumns - String[] Array - Be sure to click the "…" and type in CodeDesc in the pop up window!
EpiDataSetMode - RowsDataSet
EpiFieldName - (blank)
EpiHiddenColumnsAppend - String [] Array
EpiSort - CodeID (The codeIDs and CodeDescs are as follows respectively - 1MONDAY - Monday, 2TUESDAY - Tuesday, etc.) I did this on purpose so I could sort in the proper order. Another idea is to assign a ud field as a sequence number and sort on that if we want to stay away from "smart" IDs.
EpiStaticDataList - String [] Array
EpiTableName - UDCodes
RetrieveOnActivate - True
ValueMember - CodeID
EpiControl
EpicContextMenuKey - Blank
EpiKeyField - False
EpiLabel - lblPurchaseDay
EpiFilter
EpiFilters - String[] Array
EpiFiltersAppend - String[] Array
EpiFiltersParams - String[] Array
SearchFilter - CodeTypeID = 'Weekdays'
1. In the ToolBox click EpiLabel
1. Put next to the combo box
2. Size to match the others
3. Rename lblPurchaseDay
4. Text - Purchase Day:
5. Click New Combo box
6. Go to Epilabel - chose lblPurchaseDay
----- Original Message -----
From: "Jose Gomez" <jose@...>
To: vantage@yahoogroups.com
Sent: Wednesday, February 29, 2012 9:47:05 AM
Subject: Re: [Vantage] Re: Cannot populate an EpiUltraCombo with list of values from UDCode
LoL they also have User Defined Codes which you can assign through extended
properties.
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Wed, Feb 29, 2012 at 12:29 PM, Vic Drecchio
<vic.drecchio@...>wrote:
> **
>
>
> Hmph. Perhaps yet another reason I should to upgrade to E9. Good tip.
>
> From: Christopher Heins
> Sent: Wednesday, February 29, 2012 12:25 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Cannot populate an EpiUltraCombo with list of
> values from UDCode
>
>
> OH BABY! Ijust found the Holy Grail [of combo-boxes]!
>
> In ToolBox - BAQCombo ... how did I miss it?
>
> You just have to tweak a BAQ Query to return the records you want, plop in
> a BAQCombo, link it to the query, and it populates on startup without a
> single line of script.
>
> Giddey-up ... that only took 12 hours!
>
> Thanks Jose,
>
> Christopher Heins
> Sr. Progress Programmer/Analyst
> [cid:mailto:image001.png%4001CCF6DD.3421AFD0]
> Desk# 973-560-5370
> Cell# 908-256-3662
> Skype: cheins.nj
> mailto:cheins%40pny.com<mailto:mailto:cheins%40pny.com>
>
> ________________________________
> NOT INTENDED AS A SUBSTITUTE FOR A WRITING
> NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR
> IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY
> CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING
> OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC
> TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW
> OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND
> ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN
> OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL
> THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER
> THIS DISCLAIMER.
>
> This e-mail message from PNY Technologies, Inc. is for the sole use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy all copies of the original message.
>
> [Non-text portions of this message have been removed]
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1913 / Virus Database: 2114/4840 - Release Date: 02/28/12
>
>
> [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]