nPropertiesCount=rst.Properties.count put rst.Properties[propertyIndex] rst.Properties[propertyIndex]=newValue put rst.Properties[propertyIndex].Type objProperty=rst.Properties[propertyIndex].ref
Sets or gets
Any
recordset property value, if used in simple syntax.
Object property object wrapper, if further cascading property is requested.
Description
Allows access to the Value property of the property objects or to the Property object itself in Properties collection of the wrapped ADODB.Recordset object. Each Property object corresponds to a characteristic of the ADODB.Recordset object specific to the provider.
Some properties are read only, others are read and write capable.
Sample
A sample script, which displays all properties of the passed recordset object:
on ShowProperties rst
repeat with i= 0 to rst.Properties.Count - 1
put rst.Properties[i].Name & "=" & rst.Properties[i]
end repeat
end
