Basic Usage
Some basic steps are required in order to be able to access and manipulate data using ADO :
- Create a connection object to connect to the database.
- Create a recordset object in order to receive data in.
- Open the connection
- Populate the recordset by opening it and passing the desired table name or SQL statement as a parameter to open function.
- Do all the desired searching/processing on the fetched data.
- Commit the changes you made to the data (if any) by using Update or UpdateBatch methods.
- Close the recordset
- Close the connection
Read more about this topic: ActiveX Data Objects
Famous quotes containing the words basic and/or usage:
“The research on gender and morality shows that women and men looked at the world through very different moral frameworks. Men tend to think in terms of justice or absolute right and wrong, while women define morality through the filter of how relationships will be affected. Given these basic differences, why would men and women suddenly agree about disciplining children?”
—Ron Taffel (20th century)
“I am using it [the word perceive] here in such a way that to say of an object that it is perceived does not entail saying that it exists in any sense at all. And this is a perfectly correct and familiar usage of the word.”
—A.J. (Alfred Jules)