Summary
After reading this chapter, you should understand the Fields collection object, as well as the Field object, and the following key points about the two:
The Fields collection object contains a collection of Field objects, which each represent a column in the data source.
There are many different datatypes for fields, all of which can be identified with the Type property. For many types, alternate properties such as Precision and NumericScale can be used to better explain the definition of the field.
The supported functionality of a given Field object can be obtained using the Attributes property.
The next chapter of this book, Chapter 7, explains how commands can be sent to the data source in order to execute SQL statements, stored procedures, and other data source-specific commands.
Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
