To be honest I think its the FOption field I should have been writing about in the first place in my first mail..
Thanks for the catch Martin.. Joe ________________________________ From: "Grooms, Frederick W" <[email protected]> To: [email protected] Sent: Wednesday, May 27, 2009 4:48:21 PM Subject: Re: Values of FieldType and FBOption in the table field.. ** Oops … Time to clean the glasses You are correct that there are 2 fields in the Field table… FOPTION and FBOPTION My bad Fred From:Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:39 PM To: [email protected] Subject: AW: Values of FieldType and FBOption in the table field.. ** this is foption not fboption ________________________________ Von:Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Grooms, Frederick W Gesendet: Mittwoch, 27. Mai 2009 21:32 An: [email protected] Betreff: Re: Values of FieldType and FBOption in the table field.. ** Actually I believe the FBOPTION in FIELD is: #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 Conny Martin Sent: Wednesday, May 27, 2009 2:21 PM To: [email protected] Subject: AW: Values of FieldType and FBOption in the table field.. ** Joe, from ar.h FBOption #define AR_FIELD_BITOPTION_NONE 0x0000 /* no bit option */ #define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to audit */ #define AR_FIELD_BITOPTION_COPY 0x0002 /* BIT 1 - bit option to copy when some field is being audited */ /* 0x0003 BIT 0 & 1 - indicates AUDIT + COPY */ #define AR_FIELD_BITOPTION_LOG_KEY1 0x0004 /* BIT 2 - bit option to indicate this field is log key 1 */ #define AR_FIELD_BITOPTION_LOG_KEY2 0x0008 /* BIT 3 - bit option to indicate this field is log key 2 */ #define AR_FIELD_BITOPTION_LOG_KEY3 0x000c /* BIT 2 & 3 - bit option to indicate this field is log key 3 */ #define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any audit option is set */ #define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if any audit log key is set */ FieldType #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ HTH Kind Regards Conny ________________________________ Von:Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 27. Mai 2009 20:56 An: [email protected] Betreff: Values of FieldType and FBOption in the table field.. ** I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
