See Also
Applies To
OraFieldOraParameter
Description
Returns or sets the value of the given object. Not available at design time
and read/write at run time.
Usage
orafield.Value = data_value
data_value = orafield.Value
oraparameter.Value = data_value
data_value = oraparameter.Value
Remarks
Orafield.Value returns the value of the field as a variant. data_value =
orafield.Value sets the contents of the field. The variant type reflects the data
type as defined by the Type property. Fields can contain NULL values. You can
test the Value property with the Visual Basic function IsNull() to determine
whether the value is null upon return. You can also assign NULL to the Value
property whenever the current record is editable. Field values are cached locally as
the data is retrieved from the database. However, in the case of a LONG or LONG
RAW fields, some data may not be retrieved and stored locally. In these cases,
data is retrieved as required using the methods described in the GetChunk field
method. The maximum size of a LONG or LONG RAW field that can be retrieved
directly through the Value property is approximately 64KB. You must retrieve data
fields larger than 64KB indirectly, using the GetChunk method.
OraParameter.Value returns the value of the parameter as a variant. data_value
= oraparameter.Value sets the contents of the parameter. Note that changing
the variant data type of the value can have significant impact on the processing
of associated SQL and PL/SQL statements.
Note that fields of type DATE are returned in the default Visual Basic format
of "MM/DD/YY" even though the default Oracle date format is "DD-MMM-YY".
The Value argument can be an Oracle8i object, such as an OraBLOB. Note that a copy of the object is made at that point in time and the Value property must be
accessed to obtain a new object that refers to the Parameter's value. For
example, if iotype is ORATYPE_BOTH and an OraBlob obtained from a dynaset is passed in as the
input value, the Parameter Value property will need to be accessed one time after
the SQL has been executed so that the newly updated output value of the
parameter can be obtained. Similar to a dynaset, the object obtained from parameter
Value property always refers to the latest value of the Parameter. The Visual
Basic value NULL can also be passed as a value. The Visual Basic value EMPTY can
be used for BLOB and CLOB to mean an empty LOB, and for OBJECT, VARRAY and
NESTED TABLE to mean an object whose attributes are all NULL.
Data Type
Variant