| Oracle® Objects for OLE Developer's Guide 11g Release 2 (11.2) for Microsoft Windows Part Number E12245-01 |
|
|
View PDF |
Applies To
Description
When read, the Value property provides a string representation of the value of the OraIntervalYM object using the format YEARS-MONTHS.
When set, the Value property accepts a Variant of type String, a numeric value, or an OraIntervalYM object.
Usage
string = OraIntervalYMObj.ValueOraIntervalYMObj.Value= value
Arguments
| Arguments | Description |
|---|---|
[in] value |
A Variant of type String, a numeric value, or an OraIntervalYM object. |
Data Type
String
Remarks
If the value set is a Variant of type String, it must be in following format: [+/-] YEARS-MONTHS.
If the value set is a numeric value, the value provided should represent the total number of years that the OraIntervalYM object represents.
Examples
Dim oraIYM as OraIntervalYM
'Create an OraIntervalYM using a string which represents 1 year and 6 months
Set oraIYM = oo4oSession.CreateOraIntervalYM("1-6")
'get the OraIntervalYM.Value return a string for the Value property,
' iymStr is set to "01-06"
iymStr = oraIYM.Value
'can also return a string for the Value property as follows
iymStr = oraIYM
'set the OraIntervalDS.Value using a string which represents 1 year and 6 months
oraIYM.Value = "1-6"
'set the OraIntervalYM.Value using a numeric value which represents
'1 years and 6 months
oraIYM.Value = 1.5
See Also:
CreateOraIntervalYM Method