Status

concerns

The Status attribute property can be used to query the processing status of the table variable.

 

Syntax

Status

Return value

Type

Description

TableStatus

State description of the Table-Variable

Parameter

None

 

TableStatus

Description

0 - TS_RecOK

The record was saved successfully

1 – TS_RecNew

The record is new

2 – TS_RecModified

The record has been modified

4 – TS_RecDeleted

The record has been deleted

8 – TS_RecUnmodified

The record has not been modified

16 – TS_RecInvalid

The record has not been saved because its location (bookmark) is invalid

64 – TS_RecMultipleChanges

The record has not been saved because it would change multiple records

128 – TS_RecPendigChanges

The record has not been saved because it is currently being inserted

256 – TS_RecCanceled

The record has not been saved because the action was canceled

1024 – TS_RecCantRelease

The record has not been saved because it was currently locked (Record Lock)

2048 – TS_RecConcurrencyViolation

The record has not been saved because optimistic concurrent use

4096 – TS_RecIntegrityViolation

The record has not been saved due to data integrity violation

8192 – TS_RecMaxChangesExceeded

The record has not been saved due to too many pending changes

16384 – TS_RecObjectOpen

The record has not been saved due to a conflict with an OpenStorage Object

32768 – TS_RecOutOfMemory

The record was not saved (too little memory)

65536 – TS_RecPermissionDenied

The record was not saved due to insufficient rights

131072 – TS_RecSchemaViolation

The record was not saved due to violation of the underlying database schema

262144 – TS_RecDBDeleted

The record has already been deleted from the data source