Specials
DataMgr has a selection of special functions that it can perform on selected columns. These can be defined either using the "Special" attribute of the "field" tag in the XML passed to loadXML() or it can be defined using the "Special" argument of the setColumn() method.
- CreationDate
- Only used with CF_SQL_DATE
- DataMgr will automatically put the current date/time when inserting a record if no value is passed in for this field.
- LastUpdatedDate
- Only used with CF_SQL_DATE
- DataMgr will automatically put the current date/time when inserting or updating a record if no value is passed in for this field.
- DeletionMark
- Only used with CF_SQL_BIT or CF_SQL_DATE
- DataMgr will only retrieve records where this field is 0 (zero) for CF_SQL_BIT or NULL for either type.
- If a table has a DeletionMark field, DataMgr will use it (setting it to true for CF_SQL_BIT or to the current date for CF_SQL_DATE) instead of deleting a record when calling deleteRecord().
- Sorter
- Only used with CF_SQL_INTEGER
- If no orderby argument is passed to getRecords(), this field will be the order by field.
- When inserting a record, DataMgr will automatically assign this field to the next highest value (one higher than the highest value in the table) if no other value is passed in.
- UUID
- Only used with character fields such as CF_SQL_VARCHAR or CF_SQL_CHAR
- DataMgr will automatically put in a UUID when inserting a record if no value is passed in for this field.