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:
“It seems to me that our three basic needs, for food and security and love, are so mixed and mingled and entwined that we cannot straightly think of one without the others. So it happens that when I write of hunger, I am really writing about love and the hunger for it, and warmth and the love of it and the hunger for it ... and then the warmth and richness and fine reality of hunger satisfied ... and it is all one.”
—M.F.K. Fisher (b. 1908)
“Pythagoras, Locke, Socrates—but pages
Might be filled up, as vainly as before,
With the sad usage of all sorts of sages,
Who in his life-time, each was deemed a bore!
The loftiest minds outrun their tardy ages.”
—George Gordon Noel Byron (1788–1824)