Shulou(Shulou.com)06/02 Report--

This article mainly explains "what is the use of ADO attributes". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what's the use of ADO attributes"?

The ADO property objects all correspond to a column in Recordset. Use the ADO property of the Field object to set or return data for the current record. Depending on the functionality provided by the provider, some collections, methods, or properties of the Field object may not be available.

With the collections, methods, and properties of the Field object, you can do the following: return the field name with the ADO property. Use the Value property to view or change the data in the field. Value is the default property of the Field object.

Return the basic properties of the field with the Type, Precision, and NumericScale properties.

Returns the declared field size with the DefinedSize property. Use the ADO property to return the actual size of the data in the given field. Use the Attributes property and the Properties collection to determine the type of functionality supported by a given field.

Use the AppendChunk and GetChunk methods to manipulate field values that contain long binary or long character data.

If the provider supports batch updates, use the OriginalValue and ADO properties to resolve differences between field values during batch updates. All metadata properties (Name, Type, DefinedSize, Precision, and NumericScale) are valid until you open the Recordset of the Field object. Setting them at this point will help you construct the format dynamically.

Set and return value sets or returns a Variant value that indicates the value of the object. The default value depends on the Type property. Describes setting or returning data from the ADO property object with the Value property, setting or returning parameter values with the Parameter object, or setting or returning property settings with the Property object. Whether the Value attribute is read / write or read-only depends on many factors. For more information, see the corresponding object topic.

The ADO property allows you to set and return long binary data with the Value property. Note that for the Parameter object, the ADO reads the Value property only once from the provider. If the command contains a Parameter whose Value property is empty, and you created a Recordset in the command, be sure to turn off Recordset before retrieving the Value property. Otherwise, for some providers, the Value property may be empty and will not contain the correct value.

For new Field objects that have been appended to the Fields collection of Record objects, the ADO property must be set before any other Field property can be specified. You must first assign a specific value to the Value property and call the Update of the Fields collection. Then access other properties (such as Type or Attributes).

At this point, I believe you have a deeper understanding of "what is the use of ADO attributes?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.