ADO: Referencing Fields

[icargill]

Assume I have an ADO recordset object, rs.

I can reference the fields in a number of ways, commonly people use

1. rs!FieldName

2. rs.Fields("FieldName&quot or rs.Fields(sVariable)

Obviously the second is useful for fields with spaces in the names, but what other relative merits are there?

Are there any (significant) performance issues?

 

[Foada]

Performance issues - none that I have ever run across. The ! syntax is a backward compatable item and is to be discontinued. As a matter of personal preference the ! syntax is less readable than the rs.Fields("FieldName&quot. Just my 2 cents worth. If you choose to battle wits with the witless be prepared to lose.