CursorLock database parameter

When used with the CursorScroll parameter, specifies locking
options for cursors in ODBC data source.

The values you can set for CursorLock control two aspects
of cursor locking:

Concurrent
access

Ensures that multiple users can simultaneously access data
that is accurate and current.
Collision detection

Detects collisions that occur when multiple users update the
same data at the same time.

CursorLock='<span>lock</span>_<span>value</span><span>'</span>

1	CursorLock='<span>lock</span>_<span>value</span><span>'</span>

Parameter	Description
lock_value	Specifies the type of locking you want to use for ODBC cursors. Values are: Lock Use the lowest level of locking sufficient to allow updates on table rows. Opt Use optimistic concurrency control. This means that table rows are not locked against updates by other users. To detect collisions, compare row versions or timestamps. OptVal Use optimistic concurrency control. This means that table rows are not locked against updates by other users. To detect collisions, compare selected values with their previous values. ReadOnly Prohibit updates on table rows by any user. For more about how the ODBC standard defines lock values, see your ODBC documentation.

Parameter

Description

lock_value

Specifies the type of locking you want
to use for ODBC cursors. Values are:

Lock

Use the lowest level of locking sufficient to allow updates
on table rows.
Opt

Use optimistic concurrency control.
This means that table rows are not locked against updates by other
users. To detect collisions, compare row versions or timestamps.
OptVal

Use optimistic concurrency control. This means that table
rows are not locked against updates by other users. To detect collisions,
compare selected values with their previous values.
ReadOnly

Prohibit updates on table rows by any user.

For more about how the ODBC standard defines
lock values, see your ODBC documentation.

If you do not specify a value for CursorLock, PowerBuilder defaults
to the cursor lock setting specified by your ODBC driver.

To set scrolling and locking options for cursors
in an ODBC data source:

August 14, 2023

Was this article helpful?

Connection Information