Dictionary D-type records

Dictionary D-Type Records  -  Data Items

Top  Previous  Next


A D-type record defines a field stored in a data file and has the definition shown below.


1:D  { descriptive text }
2:Field number. This is the position in the data record at which the field described by this dictionary entry can be found. A value of zero denotes the record id. When used with a data collection file, a D-type item can only reference the record id as the records in the file are not dynamic arrays.

For compatibility with other multivalue database products a value of 9998 or 9999 will be recognised by the query processor as references to the sequentially incremented item number within the query and the length of the record respectively. Both of these special cases are better implemented using I-type records.

3:{ Conversion code }
4:{ Display name. This will be used as the default column heading by the query processor. A special value of a backslash character can be used to specify that no heading is to be displayed. The text can commence with 'R'  (including the quotes) to right justify the heading, 'X' to suppress the normal dot filler characters, or 'RX' to apply both modifications. If the display name is multivalued, each value appears as a separate line.}
5:Format specification
6:Single/multivalue flag. Set as S if the field is always single valued or M if it can be multivalued.
7:{ Association name. Where a multivalued field has a value by value relationship with some other multivalued field defined in the same dictionary, this name links the fields together. See Associations for more details. }
8:Available for user use in any way. Not referenced by QM.
9-10:Reserved for internal use.
11:Available for user use in any way. Not referenced by QM.

Fields 12 onwards are reserved for internal use and users should not assume anything about their content.