One reason for the existence of database applications is to modify data in databases.You will learn how to modify data in relational databases by using ADO functions, as well as SQL statements, in your C++ programs.
However, bear in mind that queries execute much faster if you use a forward-only cursor.
In database applications, performance is always an issue.
Therefore, you should typically use forward-only cursors and save dynamic, keyset, or static cursors for when you need the features they offer. If you don't specify a cursor type, ADO opens a forward-only cursor by default.
However, you can't see records that other users add, nor can you access records that other users delete. Additions, changes, or deletions by other users are not visible.
A forward-only cursor enables you to see changes made by other users and to scroll only forward through records.
This improves performance when you need to make only a single pass through a .The type of cursor you choose depends on your requirements.There are four different types of cursor in ADO--dynamic, keyset, static, and forward only--each with unique capabilities and attributes.A dynamic cursor enables you to view additions, changes, and deletions made by other users while the recordset is open.A dynamic cursor also enables all types of movement through the , including the ability to move n number of records forward or backward, move to the first record, and move to the last record.A keyset cursor enables you to see changes made by other users.