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 |