Certain methods require that you pass the internal ID for specific field
values. For example, the input for the SetValue method for the Field object
requires the internal database value.
The following list describes the internal
value format for most
SBM
field types:
- Binary/Trinary: Internal values are 0, 1, and 2, representing
the first, second, and third values.
- Date/Time: Internal value is a number representing seconds
since Jan 1 1970 in GMT or just elapsed seconds for elapsed time.
- Folder: The TS_ID for the folder specified in the TS_FOLDERS
table.
- Multi-Group: Comma-separated list (with leading and trailing
commas) of TS_IDs from the TS_GROUPS table.
- Multi-Relational: Comma-separated list (with leading and
trailing commas) of TS_IDs from the relational table.
- Multi-Selection: Comma-separated list (with leading and
trailing commas) of TS_IDs from the TS_SELECTIONS table.
-
Multi-User: Comma-separated list (with leading and trailing
commas) of TS_IDs from the TS_USERS table.
Important: If the
Groups and Users selection mode is enabled for
the field, the value can also include group identifiers (TS_IDs from the
TS_GROUPS table), which are in the form
G1,
G2, and so forth.
- Numeric: Same as display value.
- Single Relational: The TS_ID of the item in the relational
table.
- Single Selection: The TS_ID of the selection from the
TS_SELECTIONS table.
- Summation: Same as display value.
- Text: Same as display value.
- User: The TS_ID of value from the TS_USERS table.
Copyright © 2007–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.