Table Name:	window_db
Table Number:	263
Group:	User Interface
Description:	System object; contains descriptive and control information about a version of a form
Flags:
Baseline/Custom:	Baseline

select * from table_window_db

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
backcolor	LONG	int			-1	DIRECT	Value of the background color of the form
banner_color	LONG	int			-1	DIRECT	Value of the color assigned to the banner Default=-1 use parent color
banner_icon	LONG	smallint			-1	DIRECT	Index value of the icon assigned to the banner. Default=-1 use parent icon
base_flag	CHAR	varchar		20			Indicates whether form is a base line form; i.e., B=baseline	Search (1)
bottom_c	LONG	smallint				DIRECT	Bottom boundary of the form
description	CHAR	varchar		255			Description of the purpose/use of the form	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dialog_name	CHAR	varchar		40			Name of form	Search (6)
dimmable	LONG	int				DIRECT	Indicates if user is allowed to make a form readonly; i.e., 0=allowed, 1=not allowed	Search (1)
dlg_time_stamp	CLK_TIME	datetime	46				Date/time of last update to the form	Search (2)
factor_bottom	LONG	int				DIRECT	Form stretching factor for bottom
factor_left	LONG	int				DIRECT	Form stretching factor for left
factor_right	LONG	int				DIRECT	Form stretching factor for right
factor_top	LONG	int				DIRECT	Form stretching factor for top
flags	LONG	int				DIRECT	Stores a form's attribute; e.g., readonly, visible
form	LONG	smallint				DIRECT	Indicates whether the form is modal or modeless
id	LONG	int				DIRECT	Form ID number, which is independent of form version	Search (6)
intval1	LONG	int	16			DIRECT	Original X coordinate
intval2	LONG	int				DIRECT	Original Y coordinate
intval3	LONG	int				DIRECT	Original state
left_c	LONG	smallint				DIRECT	Left boundary of the form
locale	LONG	smallint			0	DIRECT	Language of the form; i.e., 0=English, 1=SJIS, 2=French, 3=German, 4=Spanish, 5=Chinese Big5 (traditional character), 6=Chinese GB (simplified character), 7=Korean, 8-12 (Reserved), Default=0
min_height	LONG	smallint				DIRECT	Minimum height of the form in pixels
min_width	LONG	smallint				DIRECT	Minimum width of the form in pixels
objid	LONG	int	3			DIRECT	Internal record number	Search (4)
preload	CHAR	varchar		20			Indicates whether the form will be preloaded or not. The field was used by UI Editor for display purposes	Search (2)
right_c	LONG	smallint				DIRECT	Right boundary of the form
title	CHAR	varchar	2	255			Form title	Search (6)
top_c	LONG	smallint				DIRECT	Top boundary of the form
type	LONG	smallint				DIRECT	Indicates whether the form is created dynamically or is predefined
value1	CHAR	varchar		80			Multipurpose string attribute for a window; use depends on the flag
ver_cl_srce	CHAR	varchar		40			The Clarify source control number of the form
ver_clarify	CHAR	varchar		40			Clarify baseline version of the form	Search (6)
ver_customer	CHAR	varchar		40			Customer version of the form; for forms that have been modified locally	Search (6)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table
window2control_db	OTM	control_db	control2window_db	Controls for form
window2ctx_obj_db	OTM	ctx_obj_db	ctx_obj2window_db	Contextual objects for the form
window_db2rc_config	MTM	rc_config	rc_config2window_db	Resource configurations for the form	mtm_window_db4_ rc_config1
window_db2rc_init	MTM	rc_config	rc_init2window_db	Initial resource configuration for the form	mtm_window_db5_ rc_config2
window_db2readonly	OTM	readonly	readonly2window_db	Indicates if a form is readonly for a privilege class; reserved, future
window_db2item	OTM	value_item	item2window_db	Values for the window's controls

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
window_db_index	id:ver_clarify:ver_customer:locale	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
window_db_index	id, ver_clarify, ver_customer, locale	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
321	priv_controls	control_db, privclass, window_db
322	priv_readonly	privclass, readonly, window_db
325	win_control	control_db, window_db
389	win_head	rc_config, window_db
390	win_init	rc_config, window_db
5296	priv_ctxtmenu	control_db, privclass, value_item, window_db
5297	win_ctxtmenu	control_db, value_item, window_db
5362	win_cobj_v	ctx_obj_db, window_db

My Recent Objects

window_db

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

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