Domain Source

The Domain Type field specifies the kind of values to be used in the attribute. The valid Domain Types displayed in the drop-down list:

• Nothing - This Domain Type does not perform any validation. No source code is required for this attribute. This is the default Domain Type.

• DBQuery - The DBQuery Domain Type lets you write an SQL query against the Core database to be used with this attribute. Selecting this type enables the Domain Query Results link.

  Use the format 'SELECT [value,caption] FROM…

  Example:

  Select distanceid,name

  from DistanceType

  where distanceid>25

• InfoScript - The InfoScript Domain Type Lets you to write source code using IDI's Infoscript language.

  You can enter about 10 lines of code using InfoScript.

  Example:

  if(value < 0 or value > 10)

  return "The value must be between 0 and 10'

  end

  The previous InfoScript means: If the script returns a value, then we assume the return value is an error message. The variable 'value' contains the value of the type at validation time.

• StaticList - Selecting the StaticList Domain Type lets you to enter a list of values that you do not want to add to the database. This list is displayed as a drop-down list in the IDI Desktop Client GUI.

  The format to be used is [arg1, arg2, arg3]

  Example:

  ['None','Abe Fuchs','AnnMarie Retas','Barry Schafer','Gerard Jones','Heather Wiese','Larry Rappaport']

• DBQueryPlus - The DBQueryPlus Domain Type lets you query against databases other than Core. The syntax is:

  Target;Alias;Query

  OR

  Target;Query for default alias

  Selecting this type enables the Domain Query Results link.