Files > SQLI_DOMAIN

name

SQLI_DOMAIN

number

1.5212

location

^DMSQ("DM",

description

The set from which all objects of that domain must be drawn. In SQLI, all table elements (SQLI_TABLE_ELEMENT) have a domain which restricts them to their domain set. For each data type there is a domain of the same name, representing the same set. Other domains have different set membership restrictions. Each domain has a data type, which determines the rules for comparing values from different domains, and the operators which may be used on them. The PRIMARY_KEY data type and domain is unique to SQLI. It is used to relate primary keys to foreign keys unambiguously (see SQLI_TABLE_ELEMENT)

Fields

#	Name	Location	Type	Details	Index	Description
.01	dm name(+)	0;1	FREE TEXT		B	Name of FileMan domain Includes names of standard SQL data types. Must not be a keyword.
1	dm data type(+)	0;2	POINTER	1.5211	E	IEN of a standard data type in SQLI_DATA_TYPE. Required.
2	dm comment	0;3	FREE TEXT			A short comment which describes the data type set
3	dm table	0;4	POINTER	1.5215	C	IEN of table in SQLI_TABLE if domain is of type PRIMARY_KEY Only primary and foreign keys have such domains.
4	dm width	0;5	NUMERIC			Default display width. Overrides data type display width.
5	dm scale	0;6	NUMERIC			Default number of decimal places displayed for numbers.
6	dm output format	0;7	POINTER	1.5214		Default output format for elements of this domain. Used to provide text value of pointer chains, etc.
7	dm int expr	1;E1,245	FREE TEXT			An M expression which returns the internal value of a base value. Expression uses placeholder {B} to represent the base value
8	dm int exec	2;E1,245	FREE TEXT			M code line which sets internal value, {I}, to some function of base value, {B}.
9	dm base expr	3;E1,245	FREE TEXT			An M expression which returns the internal value of base value, {B}.
10	dm base exec	4;E1,245	FREE TEXT			Code which when executed returns the base value of X
11	dm fileman field type	0;8	SET OF CODES	F:FREE TEXT N:NUMERIC P:POINTER D:DATE W:WORD-PROCESSING K:MUMPS B:BOOLEAN S:SET-OF-CODES V:VARIABLE POINTER	D	FileMan field type (F, N, D, DT, K, ...)