Suppose you have a table with this field:
Customer_Code
You can retrieve the field in many ways:
rs.(0)rs("Customer_Code")rs.fields(0)rs.fields("Customer_Code")rs.fields.item(0)rs.fields.item("Customer_Code")
In VBScript, the versions that use field indexes instead of names are faster and the extended syntax?rs.fields.item(0)?is fastest. The reason: Although VBScript, like VB, supports default properties, VBScript doesn’t have to search manually for the default property of the object being referenced.