Re: Need SQL statement to retrieve field attributes

[lars . j . pettersson]

Title: Need SQL statement to retrieve field attributes

**

Jenni, interesting question, I don't have the answer, I wonder where information is stored for display/attribute propertes. QBE is on the db tab. I know it's possible the get the field type with the use of sql, SELECT foption from field where fieldid = $Field-ID$ and schemaid = $Table Name$. 'Foption' = 2 is "Optional" for example. Should be possible to get qbe too (I guess).

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Wacholz, Jeanette (Jenni)
Sent: Tuesday, September 05, 2006 11:13 PM
To: arslist@ARSLIST.ORG
Subject: Need SQL statement to retrieve field attributes

**

Hi listers!

Is there an SQL statement that will retrieve all the attributes for every field on a form...or on all forms? We are specifically interested in seeing the QBE settings for the fields.

Jenni Wacholz
Coventry HealthCare
480-445-2517

"MMS <firsthealth.com>" made the following annotations.
------------------------------------------------------------------------------
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
==============================================================================

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___