Hi,
I have made a solution for the problem. You need to extract the labels from the enums in the AOT. Goes something like this: public void run() { EDAViewWizardEnum viewWizardEnumTable; EDAViewWizardLanguage viewWizardLanguageTable; Dictionary dictionary; DictEnum dictEnum; EnumId enumId; xInfo xInfo; int i, idx; RunBaseProgress progress; LanguageId currentLanguageId; ; Dictionary = new Dictionary(); xInfo = new xInfo(); select count(RecId) from viewWizardLanguageTable; progress = new RunBaseProgress(2); progress.setCaption("@EDA23"); progress.setAnimation(#AviUpdate); progress.setTotal(viewWizardLanguageTable.RecId, #second); progress.setTotal(dictionary.enumCnt(), #first); progress.setText("@SYS4195", #first); delete_from viewWizardEnumTable; startLengthyOperation(); while select viewWizardLanguageTable { Progress.setText(viewWizardLanguageTable.LanguageId, #second); currentLanguageId = xInfo.language(); xInfo.language(viewWizardLanguageTable.LanguageId); for (i = 1; i <= dictionary.enumCnt(); i++) { enumId = dictionary.enumCnt2Id(i); dictEnum = new DictEnum(enumId); if(dictEnum) { Progress.setText(dictEnum.name(), #first); idx = 0; for (idx = 0; idx < dictEnum.values(); idx++) { viewWizardEnumTable.LanguageId = viewWizardLanguageTable.LanguageId; viewWizardEnumTable.BaseEnumId = enumId; viewWizardEnumTable.BaseEnumName = dictEnum.name(); viewWizardEnumTable.BaseEnumLabel = dictEnum.label(); viewWizardEnumTable.BaseEnumValueName = dictEnum.index2Symbol(idx); viewWizardEnumTable.BaseEnumValueLabel = dictEnum.index2Label(idx); viewWizardEnumTable.BaseEnumValue = dictEnum.index2Value(idx); viewWizardEnumTable.insert(); } } Progress.incCount(1, #first); } Progress.incCount(1, #second); } xInfo.language(currentLanguageId); EndLengthyOperation(); } Then you need to make a table also from within Ax storing the fields that uses Enums and the Enum Id it uses. (As I create a view from within AX I did not need this table). You need to loop over the data dictionary (SysDictionary, sysDictTable, SysDictField). Here you will find the Property Enum and SQLName, remember the tableName (DBBackend). Now You can Join the Enumvalue with this table: Select custAccount, Name from CustTable LEFT OUTER JOIN BaseEnumValueLabel from viewWizardEnumTable Where languageId = 'en-us' And BASEENUMID = 53 (CustVendBlocked) <ID of the enum the field uses> And BASEENUMVALUE = CustTable.Blocked Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 ________________________________ "Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank." "The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks." ________________________________ -----Ursprüngliche Nachricht----- Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Ozanhan Anaç Gesendet: Mittwoch, 12. März 2008 15:47 An: development-axapta@yahoogroups.com Betreff: RE: [development-axapta] Enum values in SQL database Hi Anýl, As enum types stored in the application (not in SQL), there shouldn't be a flexible way to show that values. Instead, you can use HARDCODED switch cases in your views. For example : Create view vw_blabla As Select StatusIssue_Text = case StatusIssue when 0 then 'none' when 1 then 'sold' ....., StatusIssue, ...,.... from bmssa.INVENTTRANS Regards, Ozan _____ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Anil Ozay Sent: Wednesday, March 12, 2008 2:45 PM To: [EMAIL PROTECTED]; development-axapta@yahoogroups.com Subject: [development-axapta] Enum values in SQL database Hi, We want to create a view on SQL server for InventTrans and tha table has enum values. SQL uses integer values to store enum values but we want to show enum values to user. Is it possible to find the enum values on database to show in the view? Regards, Anil Ozay [Non-text portions of this message have been removed] No virus found in this incoming message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.6/1318 - Release Date: 07.03.2008 14:01 No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.6/1318 - Release Date: 07.03.2008 14:01 No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.6/1318 - Release Date: 07.03.2008 14:01 [Non-text portions of this message have been removed] Yahoo! Groups Links http://groups.yahoo.com/group/development-axapta/ Individual Email | Traditional http://groups.yahoo.com/group/development-axapta/join (Yahoo! ID required) mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] http://docs.yahoo.com/info/terms/ [Non-text portions of this message have been removed] ------------------------------------ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/development-axapta/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/