Value Property

See Also

Applies To

OraField

OraParameter

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 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.

Data Type

Variant