Re: Database Query

[Carter, Craig J Civ ARPC/DPD]

** …or just open the specific form and look at the attributes for that field.  The values should be listed there unless it’s a menu.  If it’s a menu, you can look at that once you determine what menu is being used.   //SIGNED// CRAIG J. CARTER From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Thursday, November 09, 2006 5:35 AM To: arslist@ARSLIST.ORG Subject: Re: Database Query   ** There are two tables that can help with this: field_enum and field_enum_values. Something like this would give you the fieldname, enum_label and enum value: select a.name,fieldname,enumId,value from field f, field_enum fe, field_enum_values fev, arschema a where f.schemaid = fe.schemaid and   fe.schemaid=fev.schemaid and   f.fieldid = fe.fieldid and   fe.fieldid=fev.fieldid and   a.schemaid = f.schemaid On 11/9/06, Rami S. Ayoub <[EMAIL PROTECTED]> wrote: ** Hi list.   When I'm trying to see any drop-down list in to database its become like 0 1 2 3 4 5. There is anyway or any Query can I see the actual value for the drop-down   Thanks Rami S Ayoub   __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___