Page History
...
Pos | Name | Type | Description | Default |
---|---|---|---|---|
<1> | Type | Option | The item's data type | Text |
<2> | Format | Formatted String | The item's output format | "" |
...
Choose the data type that best represents the data you plan to store within the item. When you set the ItemData property, be sure to pass the data in OpenInsight's internal format. The following data types are available.
Value | Abbr. | Description |
---|---|---|
Text | T | Plain text data sorted alphabetically |
TextNoCase | TNC | Plain text data sorted alphabetically case insensitively |
Number | N | Numerical data sorted by magnitude |
Date | D | Day, month, and year data sorted chronologically |
Time | TI | Hour, minute, and second data sorted chronologically |
DateTime | DT | Date and time data sorted chronologically |
Bool | B | True/false data sorted by magnitude, where false = 0 and true = 1 |
...
To Display As | Use |
---|---|
First Name: Kevin | First Name: %S% |
Kevin Esquire | %S% Esquire |
Code guru Kevin works for SRP Computer Solutions, Inc. | Code guru %S% works for SRP Computer Solutions, Inc. |
TextNoCase
The same as Text, but sorted case insensitively.
Number
Numbers are stored as floating point values within the item. Thus, if your data contains decimal values, make sure you include the decimal when you set the item's data. In other words, there is no equivalent MD2 format for the SRP Tree Control. Instead, an Excel-like syntax is employed to format and round off decimal numbers.
...
Dates are stored in a proprietary format within the SRP Tree Control. Currently, dates must be in OI's internal format when passing them to the ItemData property. In other words, the SRP Tree Control will not parse string dates on your behalf. Like Numbers, the SRP Tree Control uses an Excel-like syntax to format dates.
...
Times are stored in a proprietary format within the SRP Tree Control. Currently, times must be in OI's internal format when passing them to the ItemData property. In other words, the SRP Tree Control will not parse string time on your behalf. The SRP Tree Control uses an Excel-like syntax to format times.
...
DateTimes are stored in a proprietary format within the SRP Tree Control. Currently, date & times must be in OI's internal format when passing them to the ItemData property. In other words, the SRP Tree Control will not parse string date & times on your behalf. Like individual Dates and Times, the SRP Tree Control uses an Excel-like syntax for formatting.
...
To Display As | Use |
---|---|
True | False] |
Yes | No] |
T | F] |
The value is: True | False] |
, or ] when the value is True | , or ] when the value is" [True|False] |
Use the DefType property to set the default data type for new items.
...
Code Block |
---|
// Make all items' data types dates Set_Property(@Window:".OLE_TREE", "OLE.ItemType[All]", "Date":@FM:"MM/DD/YYYY") |