SOTPR keyword

Applies to

Collection specifications

Property: Primary data source

Description

Forces WinStudio to save each modified row in a separate transaction when the user executes the Save operation on the collection.

Syntax

SOTPR( )

Remarks

When the user executes a save operation on the collection, WinStudio sends all modified rows to the IDO runtime to be processed. In the default behavior, all modified rows are processed within a single transaction. With SOTPR (save one transaction per row) specified, the middle tier executes a save-current operation for each row. If the save succeeds, the next row is processed. If it fails, processing stops and an error message is presented. Unlike the default behavior, the previous rows remain committed. Saving one row per transaction can alleviate blocking problems.

Example

SL.SLItems( SOTPR() )