The Visual Basic Library for SQL Server (VBSQL), is an API interface to DB-Library.
VBSQL provides several types of cursors, as listed in the following table.
| Cursor type | Constant |
| Static cursor with read forward-only. | CURFORWARD |
| Keyset-driven cursor. | CURKEYSET |
| Dynamic cursor. | CURDYNAMIC |
| Keyset-driven, insensitive, server-side only. | CURINSENSITIVE |
You can control how the data source and VBSQL cursors manage concurrency with several locking options, as shown in the following table.
| Locking type | Constant |
| Read only. Changes are not permitted. | CURREADONLY |
| Pessimistic concurrency. | CURLOCKCC |
| Optimistic concurrency using row values. | CUROPTCCVAL |
| Optimistic concurrency using row versions. | CUROPTCC |
For More Information For more information on VBSQL cursors, search online for "Implementing VBSQL Cursors" in Visual Basic Books Online. For more information on using locks to handle multiuser concurrency situations, see Managing Concurrency with Cursor Locks.