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

This article introduces the knowledge of "how to determine how to delete records in ADO database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The ADO database needs to assign values to the fields of the information, and if FiledList is a field name, then the ADO database as a single numeric value, then the ADO database must also be an array of the same type as FieldList. This allows you to perform simple operations.

After adding new records to the recordset using the AddNew method, you should use UpDate to store the added data in the database. However, you use the CancelUpdate method to cancel the operation before using the ADO database.

(B) modify the recordset

In fact, it doesn't make much difference to modify and check the data re-assignment in the recordset, as long as you use the ADO database of the field to be modified by the SQL statement to find out the re-assignment. I won't go into details here.

(C) deletion of records

The method to delete the data in the recordset in the ADO database is the Delete method, which is the same as the method of the DAO object, but in ADO it has the ability to delete a set of records.

Its syntax is as follows:

Recordset.Delete AffectRecords

Among them, the AffectRecords parameter determines how the Delete method works, and its values are as follows: adAffectCurrent deletes only the current records adAffectGroup deletes those records that conform to the ADO database property settings. In order to delete one set of data at a time, set the Filter property.

(d) query records

The query method in ADO database is very flexible, and there are several query methods. Use the Execute method of the connection object to execute the SQL command and return the query recordset. Use the Execute method of the Command object to execute the SQL command set in the CommandText property to return the query recordset.

This is the end of the content of "how to determine ADO database delete records". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.