VBSQL Cursors
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.