Category: DataBase
1. The delete method deletes current record. The user should display the record to delete and click a Delete command button or menu choice.
2. When a record is deleted, the current record is no longer valid. Therefore, a delete method must be followed by MoveNext method.
With datBooks.Recordset
.Delete
.MoveNext
End With
3. But what if the record being deleted is the last record in the table?
4. Remember that if the navigation buttons are used to navigate, moving beyond EOF just resets the current record to the last record.
-
What is a record set ? What are its type ? Explain
-
Explain deference between a data control and data-bound control
-
Explain how BOF and EOF properties are set and how they might be used in a project
-
What is grid control ? How will you create it
-
Seek method
-
What is SQL, and how is it used in Visual Basic
-
What is the purpose of record count and absolute position properties
-
What are the steps needed to add a new record to database
-
Which controls can be data bound
-
What are the steps needed to delete a record from database
-
When does a control’s Validate event occur? How is the Cancel argument used
-
What steps are needed to change the data in a database
-
When would it be a good idea to use a grid control
Dinesh Thakur is a Columinist and designer with strong passion and founder
of Computer Notes. if you have any ideas or any request please get @me on
