CursorLock

Description

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.

Applies to

ODBC (if driver and back-end DBMS support this feature)

Syntax

CursorLock='lock_value'

1	CursorLock='lock_value'

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.

Default value

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

Examples

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

See also

CursorScroll

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2019

PB Docs 2019 Powerbuilder Documentation 2019

August 21, 2023

Was this article helpful?

Connection Information