Excalibur Software PropertyList 3.0
RecordsetProperty Recordset As ADODB._Recordset15
Description
Returns/sets an ADO 2.0 Recordset object containing
the fields in the PropertyList control.
Retrieving the Recordset
When returning a Recordset, the fields returned
do not include Header items. A new Recordset object
will be returned with every reference to the Recordset
property. Refer to the table below to determine what a
field's data type will become given the Property object's
ItemType.
Setting the Recordset
When setting the Recordset, the PropertyList will clear
all items currently in the Properties collection and
add the Recordset's fields to the collection with their
corresponding names and values. If
FilterFields is True, a
QueryFieldFilter event will
fire for each field in the Recordset, allowing you to prevent
it from being added to the PropertyList with the rest of
the fields.
When
AutoTypeTranslation is True (the default), item
types will be translated from ADO field types to PropertyList
item types automatically using the following logic:
| ADO Type | Translates to |
| adBoolean | ExPropBoolValue |
| adDouble | ExPropNumericValue |
| adInteger | ExPropOleColor |
| adDate,adDBDate | ExPropDatePicker |
| (Value contains null characters) | ExPropFontDlg |
| (All others) | ExPropStringValue |
If AutoTypeTranslation is False, a QueryADOType event will fire for each field in the Recordset, allowing you to perform manual type translation.