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 <*> 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/