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 basic thing nobody asks is why do people take drugs of any sort?... Why do we have these accessories to normal living to live? I mean, is there something wrong with society thats making us so pressurized, that we cannot live without guarding ourselves against it?”
—John Lennon (19401980)
“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)
Related Phrases
Related Words