What is the purpose of a recordset?

Just trying to get a grasp on database concepts, but it seems like I could just edit a database using .execute statements, if that's true, what is the purpose of a recordset?

Also, going through on a trial run with a mysql database, I've managed to save an entry (using a recordset), but how do I save any changes to the actual database? Thanks.

Quote:

---

Originally Posted by Nove

Just trying to get a grasp on database concepts, but it seems like I could just edit a database using .execute statements, if that's true, what is the purpose of a recordset?

Also, going through on a trial run with a mysql database, I've managed to save an entry (using a recordset), but how do I save any changes to the actual database? Thanks.

---

Recordsets are extremely useful (and pretty much required) for retrieving, sorting, searching, and displaying data from a database. I do not personally use them for updating data; I prefer to use SQL INSERT/UPDATE/DELETE statements via the Connection object's Execute method.

Regards,

Nove,

Recordset are mainly used to return multiple record data from the database for viewing or to peruse through.

Quote:

---

Originally Posted by Nove

but how do I save any changes to the actual database? Thanks.

---

By using either the recordset's .AddNew/.Update methods or by using SQL INSERT INTO or UPDATE querys.