Visual Basic Database Tutorial - Part 4
When it comes down to databases, you can do virtually everything in code. Here are a few of the top properties and methods of the Recordset object for you to play around with:
MoveNext - Moves to the next record in the RecordsetMovePrevious - Moves to the previous recordMoveFirst - Moves to the first recordMoveLast - Moves to the last recordEdit - Enters edit mode, for changing fieldsUpdate - Saves any editsAddNew - Adds a new, empty recordDelete - Deletes the current recordRecordCount - (Number) Returns the number of records currently accessed (move to the last record to get total number of records)BOF - (Boolean) Hit when you step before the first record in a RecordsetEOF - (Boolean) Hit when you pass the last record in a Recordset
Indeed, using these simple properties and methods you could very simply replicate all the functionality of the Data control.
Go on, have a go! Try to build a simple Customer browsing application, similar to the one we created in the third tutorial.
Page 7 of 8
This article was originally published on November 20, 2002