-----Original Message-----** Hi Jenni,
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Michiel Beijen
Sent: Tuesday, September 05, 2006 2:45 PM
To: [email protected]
Subject: Re: Need SQL statement to retrieve field attributes
The QBE setting is only applicable to Character fields (makes sense I guess) so this property is stored in the field_char table. The next SQL statement would give you a nice list:
select name, fieldname, qbematchop
from field, field_char, arschema
where field.schemaid = field_char.schemaid
and field.fieldid = field_char.fieldid
and field.schemaid = arschema.schemaid
order by 1, 2
This would give you a list of all character fields on all forms with their QBE setting. This would be an integer which translates as follows:
1 = anywhere
2 = leading
3 = equal
For more information, please refer to the database reference guide.
Regards,
Michiel
On 9/5/06, Wacholz, Jeanette (Jenni) <[EMAIL PROTECTED]> wrote:**__20060125_______________________This posting was submitted with HTML in it___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___
"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.
==============================================================================
