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.