Returns or sets the value of the given object. Not available at design time
and read/write at run time.
orafield.Value = data_value
data_value = orafield.Value
oraparameter.Value = data_value
data_value = oraparameter.Value
Orafield.Value returns the value of the field as a variant. data_value =
orafield.Value sets the contents of the field. 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 Oracle9i object, such as an OraBLOB.
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.