Fred - thanks for the quick response! That's perfect - I realised just after I sent the email that the FOPTION was looking like the flag, but just wanted to make sure.
I keep forgetting to check the ar.h files. There's a ton of useful information in there. Cheers 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] W: www.computacenter.com "Grooms, Frederick W" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 18/06/2008 16:02 Please respond to arslist To: [email protected] cc: Subject: Re: How can I use SQL to provide a list of all Data Fields ** 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] W: www.computacenter.com __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
