Re: Database Query

[Frank Caruso]

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