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
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers
Are"_
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers
Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
