Value Property

Sets or returns the value of an object.

Syntax

VOIDSetValue(LPVARIANT pv );

COleVariantGetValue(VOID);

Parameters

Type	Argument	Description
LPVARIANT	pv	A pointer to a COleVariant that contains the value to be inserted into the CdbField object.

Remarks

Generally, the Value property is used to retrieve and alter data in CdbRecordset objects.

The Value property is the default property of the CdbField, CdbParameter, and CdbProperty objects. Therefore, you can set or return the value of one of these objects by referring to them directly instead of specifying the Value property.

Trying to set or return the Value property in an inappropriate context (for example, the Value property of a CdbField object in the Fields collection of a CdbTableDef object) will cause a trappable error.

Notes

In an ODBCDirect workspace, you cannot read or set the Value property of a CdbRecordset field more than once without refreshing the current record. For example, to read and then set the Value property, first read the property, then use the Move 0 method to refresh the current record, then write the new value.
When reading decimal values from a Microsoft SQL Server database, they will be formatted using scientific notation through a Microsoft Jet workspace, but will appear as normal decimal values through an ODBCDirect workspace.