On the other hand, the Open method allows you to specify the CursorType (strategy and object used to access the data) and LockType (specify the degree of isolation from other users, and whether the cursor should support updates in immediate or batch modes).Ĭonnection.Execute(CommandText, RecordsAffected, Options) There are in fact three ways you can create a recordset.Īnother difference is the way the command is specified in the three methods:īoth the execute methods are intended for (but not limited to) executing commands that do not return data. Immediate Updating - all changes are written immediately to the database once you call the Update methodīatch Updating - the provider cache multiple changes and then send them to the database with the UpdateBatch method Recordset objects can support two types of updating If there are no reocrds, the BOF and EOF properties are True. When you first open a recordset, the currrent record pointer will point to the first record, and the BOF and EOF properties are False. The Recordset object is used to hold a set of records from a database table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |