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 |