Record Mode requests may return the following parcels:
| Name | Flavor |
|---|---|
| Failure | 9 |
| Error | 49 |
| StatementError | 192 |
| Success | 8 |
| StatementStatus | 205 |
| Record | 10 |
| With | 33 |
| EndWith | 35 |
| EndStatement | 11 |
| EndRequest | 12 |
The following examples assume successful completion of the request when using Original Statement-status. If using Enhanced Statement-status, OK parcels may be replaced by StatementStatus parcels. See Parcels for Basic Applications or Parcels for Advanced Applications for detailed descriptions of parcels.
| UPDATE TABLE1 SET FIELD1 = 999999; | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 23, 0, 0, 3, 0) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |
| SELECT FIELD1 FROM TABLE1; | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 23, 0, 1, 1, 0) |
| Record (1) . . . Record (23) |
10 . . . 10 |
(data) . . . (data) |
| EndStatement | 11 | (1) |
| EndRequest | 12 |
| SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1); | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 24, 0, 1, 1, 0) |
| Record (1) . . . Record (23) |
10 . . . 10 |
(data) . . . (data) |
| With | 33 | (1) |
| Record | 10 | (data) |
| EndWith | 35 | (1) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |
| SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2; | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 23, 0, 1, 1, 0) |
| Record (1) . . . Record (23) |
10 . . . 10 |
(data) . . . (data) |
| EndStatement | 11 | (1) |
| Success | 8 | (2, 10, 0, 1, 1, 0) |
| Record (1) . . . Record (10) |
10 . . . 10 |
(data) . . . (data) |
| EndStatement | 11 | (2) |
| EndRequest | 12 | |
| ECHO ̀SELECT FIELD1 FROM TABLE1́; | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 0, 0, 1, 33, 0) |
| Record | 10 | (echoed string) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |