Re: Need SQL statement to retrieve field attributes

[Luke, Brian]

Title: Need SQL statement to retrieve field attributes

**

Try the FIELD_CHAR table column QBEMATCHOP.  The leading/ending/anywhere options are specific to character fields so wouldn't be stored in FIELD.

 

-Brian

---

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wacholz, Jeanette (Jenni)
Sent: Tuesday, September 05, 2006 2: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___