ADOxtra Property object properties:

Data accessing properties:

Value,

 

Property information properties:

Name,

Type,

Attributes

Property.Value

Syntax

put Property.Value

Property.Value=1

Sets or gets

Any

Value property of the Property object.

Description

Sets or gets the Value property of the wrapped ADODB.Property object. Use the Value property to set or return data from Property objects.

Property.Name

Syntax

put Property.Name

Returnss

String

value that indicates the name of the Property object.

Description

Returns the Name property of the wrapped ADODB.Property object. Use the Name property to retrieve the name of a Property object.

Property.Type

Syntax

put Property.Type

Returns

Integer

value that indicates the data type of a Property object. Refer to ADO documentation at msdn.microsoft.com for a complete list of possible values. Here is a subset of values that may be usefull in Lingo:

Constant	Value	Description
adBoolean	11	Indicates a boolean value.
adBSTR	8	Indicates a null-terminated character string (Unicode).
adChar	129	Indicates a string value.
adCurrency	6	Indicates a currency value. Currency is a fixed-point number with four digits to the right of the decimal point. It is stored in an eight-byte signed integer scaled by 10,000.
adDate	7	Indicates a date value. A date is stored as a double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day.
adDecimal	14	Indicates an exact numeric value with a fixed precision and scale.
adDouble	5	Indicates a double-precision floating-point value.
adEmpty	0	Specifies no value.
adInteger	3	Indicates a four-byte signed integer.
adGUID	72	Indicates a globally unique identifier (GUID).
adLongVarWChar	203	Indicates a long null-terminated Unicode string value.
adNumeric	131	Indicates an exact numeric value with a fixed precision and scale.
adSingle	4	Indicates a single-precision floating-point value.
adSmallInt	2	Indicates a two-byte signed integer.
adTinyInt	16	Indicates a one-byte signed integer.
adUnsignedInt	19	Indicates a four-byte unsigned integer.
adUnsignedSmallInt	18	Indicates a two-byte unsigned integer.
adUnsignedTinyInt	17	Indicates a one-byte unsigned integer.
adUserDefined	132	Indicates a user-defined variable.
adVarBinary	204	Indicates a binary value.
adVarChar	200	Indicates a string value.
adVarNumeric	139	Indicates a numeric value.
adVarWChar	202	Indicates a null-terminated Unicode character string.
adWChar	130	Indicates a null-terminated Unicode character string.

Description

Returns the Type property of the wrapped ADODB.Property object.

Property.Attributes

Syntax

put Property.Attributes

Returns

Integer

value that indicates characteristics of a Property object. It can be one or sum of the following values:

Constant	Value	Description
adPropNotSupported	0	Indicates that the property is not supported by the provider.
adPropRequired	1	Indicates that the user must specify a value for this property before the data source is initialized.
adPropOptional	2	Indicates that the user does not need to specify a value for this property before the data source is initialized.
adPropRead	512	Indicates that the user can read the property.
adPropWrite	1024	Indicates that the user can set the property.

Description

Returns the Attributes property of the wrapped ADODB.Property object.