It's called FOPTION in the Field table.
>From the API files (ar.h)
#define AR_FIELD_OPTION_REQUIRED 1 /* tags for field
definition option */
#define AR_FIELD_OPTION_OPTIONAL 2
#define AR_FIELD_OPTION_SYSTEM 3 /* system field;
read-only to ALL users */
/* NOTE that fields
cannot be created */
/* with nor set to this
option */
#define AR_FIELD_OPTION_DISPLAY 4 /* display-only field; no
data will be */
/* stored for this field
in the DB */
Fred
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gavin Coleman
Sent: Wednesday, June 18, 2008 9:58 AM
To: [email protected]
Subject: How can I use SQL to provide a list of all Data Fields
Hi List - I'm trying to write a query builder tool for users to build
their own complex queries and save multiple queries. As part of this, I
would like to provide the user with a list of all data fields on a form.
(I.e. Excluding trim fields, table, column, display only fields). I've
had a look around the database system and believe it should be possible
to use a SQL menu to provide this.
Does anybody have a query that would provide what I'm looking for? I've
looked at the Database table - FIELD and the other related FIELD_
tables, but can't find the marker that would tell you whether or not
it's a data field.
Any help appreciated! If it's not possible, then I can always use a Data
Dictionary menu, but this also includes Display Only fields.
Thanks,
Gavin Coleman
Senior Analyst/Programmer
Computacenter (UK) Ltd
Services & Solutions
Hatfield Avenue
Hatfield, Hertfordshire, AL10 9TW, United Kingdom
T: +44 (0) 1707 631662
E: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
W: www.computacenter.com <http://www.computacenter.com/>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
