Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
backcolor	LONG	int				DIRECT	Value of the background color assigned to the control
bottom_c	LONG	smallint				DIRECT	Bottom boundary of the control
description	CHAR	varchar		255			Description of the purpose/use of the control; currently used only for buttons to indicate access restriction by privilege class
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dimmable	LONG	int				DIRECT	Indicates whether the item can be dimmed by the user; i.e., 0=dimmable, 1=not dimmable	Search (2)
flags	LONG	int				DIRECT	Stores a control's attribute in bitmap form; e.g., readonly, visible
flags2	LONG	int				DIRECT	Stores additional bitmapped control attributes
font	CHAR	varchar		80			The font assigned to the control
forecolor	LONG	int				DIRECT	Value of the foreground color assigned to the control
from_side	LONG	smallint				DIRECT	Reserved; not used
function_id	LONG	int				DIRECT	Reserved; not used
id	LONG	smallint				DIRECT	Control ID in .dat file
intval1	LONG	int				DIRECT	Multi-purpose integer attribute; use depends on type of control
intval2	LONG	int				DIRECT	Additional multi-purpose integer attribute; use depends on type of control
intval3	LONG	int				DIRECT	Additional multi-purpose integer attribute; use depends on type of control
intval4	LONG	int				DIRECT	Additional multi-purpose integer attribute; use depends on type of control
justification	LONG	smallint				DIRECT	Indicates left, right or center justification of the control's label
left_c	LONG	smallint				DIRECT	Left boundary of the control
name	CHAR	varchar		80			Name of the control	Search (4)
objid	LONG	int	3			DIRECT	Internal record number	Search (4)
right_c	LONG	smallint				DIRECT	Right boundary of the control
same_side	LONG	smallint				DIRECT	Reserved; not used
title	CHAR	varchar		255			Displayed label of the control	Search (2)
tlink_dtype	LONG	int				DIRECT	Data type of the control's title (source link) contextual object
tlink_fld	LONG	int				DIRECT	Field name of the control's title (source link) contextual object
tlink_fld_name	CHAR	varchar		80			Field name of the contextual object the control is title linked to
tlink_name	CHAR	varchar		80			Name of the control's title (source link) contextual object
to_ctrl_id	LONG	smallint				DIRECT	Reserved; not used
top_c	LONG	smallint				DIRECT	Top boundary of the control
type	LONG	smallint				DIRECT	Type of control; e.g., menubutton, button, etc	Search (2)
value1	CHAR	varchar		255			Multipurpose string attribute for a control's string value; use depends on the control
value2	CHAR	varchar		255			Second multipurpose string attribute for a control's string value; use depends on the control
value3	CHAR	varchar		255			Stores an edit mask for a control
vlink_dtype	LONG	int				DIRECT	Data type of the control's value link (destination link) to the contextual object
vlink_fld	LONG	int				DIRECT	Stores the field ID of the control's database field (or temporary data structure). It is a field belonging to the contextual object that is referenced by title in the vlink_name field
vlink_fld_name	CHAR	varchar		80			Field name of the contextual object the control is value linked to
vlink_name	CHAR	varchar		80			Title of the control's (destination link) contextual object
win_id	LONG	int				DIRECT	ID of form in which the control appears	Search (2)

Table Name:	control_db
Table Number:	264
Group:	User Interface
Description:	A control appearing on a Clarify form; used with privilege class mechanism to indicate that a control is disabled for particular privilege classes
Flags:
Baseline/Custom:	Baseline

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views
control_db2btn_action	OTM	btn_action	btn_action2control_db	Button actions linked to the control
control_db2privclass	MTM	privclass	privclass2control_db	Relation to privilege class for which the item is excluded	mtm_privclass1_ control_db2	Search (1)
item2value_item	OTM	value_item	value2control_db	Value items linked to the control
control2window_db	MTO	window_db	window2control_db	Form using the control		Search (4)

Index Name	Fields	Flags
control_db_index	id:control2window_db	UNIQUE
name_index	name:control2window_db	UNIQUE

Index Name	Fields	Additional Information
control_db_index	id, control2window_db	nonclustered, unique located on PRIMARY
ind_control2window_db	control2window_db	nonclustered located on PRIMARY
name_index	name, control2window_db	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

View ID	View Name	Tables
267	value_view	control_db, value_item
321	priv_controls	control_db, privclass, window_db
325	win_control	control_db, window_db
5296	priv_ctxtmenu	control_db, privclass, value_item, window_db
5297	win_ctxtmenu	control_db, value_item, window_db

Fields:

Relations:

Indexes: (Defined in Clarify Schema)

Indexes (Defined in Database):

Referenced in Views:

My Recent Objects

Quick Links

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog