Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
There are actually several kinds of recordsets. Some are read-only, meaning we can't change the data within them. Some allow us to scroll up and down among the data; some don't. We can control all of those attributes of a recordset when we create it directly using a CreateObject statement instead of letting ASP do it for us, as we have been doing.
Let's look at the issues we need to take into consideration, and then we'll look at syntax. When we create a recordset using