Field Mode requests may return the following parcels:
| Name | Flavor |
|---|---|
| Failure | 9 |
| Error | 49 |
| StatementError | 192 |
| OK | 17 |
| ResultSummary | 171 |
| Field | 18 |
| With | 33 |
| EndWith | 35 |
| FormatStart | 22 |
| FormatEnd | 23 |
| NullField | 19 |
| PosStart | 46 |
| Position | 34 |
| PosEnd | 47 |
| RecStart | 28 |
| RecEnd | 28 |
| SizeStart | 24 |
| Size | 26 |
| SizeEnd | 25 |
| TitleStart | 20 |
| TitleEnd | 21 |
| 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 |
| OK | 17 | (1, 0, 23, 3, 0, 0) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |
| SELECT FIELD1 FROM TABLE1; | ||
|---|---|---|
| Parcel | Flavor | Body |
| OK | 17 | (1, 1, 23, 1, 0, 0) |
| TitleStart | 20 | |
| Field | 18 | (title) |
| TitleEnd | 21 | |
| FormatStart | 22 | |
| Field | 18 | (format) |
| FormatEnd | 23 | |
| SizeStart | 24 | |
| Size | 26 | (size) |
| SizeEnd | 25 | |
| RecStart (1) | 27 | |
| Field | 18 | (data) |
| RecEnd (1) | 28 | |
| . . . |
. . . |
|
| RecStart (23) | 27 | |
| Field | 18 | (data) |
| RecEnd (23) | 28 | |
| EndStatement | 11 | (1) |
| EndRequest | 12 |
| SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1) | ||
|---|---|---|
| Parcel | Flavor | Body |
| OK | 17 | (1, 1, 24, 1, 0, 0) |
| TitleStart | 20 | |
| Field | 18 | (title) |
| TitleEnd | 21 | |
| FormatStart | 22 | |
| Field | 18 | (format) |
| FormatEnd | 23 | |
| SizeStart | 24 | |
| Size | 26 | (size) |
| SizeEnd | 25 | |
| With | 33 | (1) |
| PosStart | 46 | |
| Position | 34 | (1) |
| PosEnd | 47 | |
| TitleStart | 20 | |
| Field | 18 | (title) |
| TitleEnd | 21 | |
| FormatStart | 22 | |
| Field | 18 | (format) |
| FormatEnd | 23 | |
| SizeStart | 24 | |
| Size | 26 | (size) |
| SizeEnd | 25 | |
| EndWith | 35 | (1) |
| RecStart (1) | 27 | |
| Field | 18 | (data) |
| RecEnd (1) | 28 | |
| . . . |
. . . |
|
| RecStart (23) | 27 | |
| Field | 18 | (data) |
| RecEnd (23) | 28 | |
| With | 33 | (1) |
| Field | 18 | (data) |
| EndWith | 35 | (1) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |
| SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2; | ||
|---|---|---|
| Parcel | Flavor | Body |
| OK | 17 | (1, 1, 23, 1, 0, 0) |
| TitleStart | 20 | |
| Field | 18 | (title) |
| TitleEnd | 21 | |
| FormatStart | 22 | |
| Field | 18 | (format) |
| FormatEnd | 23 | |
| SizeStart | 24 | |
| Size | 26 | (size) |
| SizeEnd | 25 | |
| RecStart (1) | 27 | |
| Field | 18 | (data) |
| RecEnd (1) | 28 | |
| . . |
. . |
|
| RecStart (23) | 27 | |
| Field | 18 | (data) |
| RecEnd | 28 | |
| EndStatement | 11 | (1) |
| OK | 17 | (2, 1, 10, 1, 0, 0) |
| TitleStart | 20 | |
| Field | 18 | (title) |
| TitleEnd | 21 | |
| FormatStart | 22 | |
| Field | 18 | (format) |
| FormatEnd | 23 | |
| SizeStart | 24 | |
| Size | 26 | (size) |
| SizeEnd | 25 | |
| RecStart (1) | 27 | |
| Field | 18 | (data) |
| RecEnd (1) | 28 | |
| . . . |
. . . |
|
| RecStart (10) | 27 | |
| Field | 18 | (data) |
| RecEnd (10) | 28 | |
| EndStatement | 11 | (2) |
| EndRequest | 12 | |
| ECHO ̀SELECT FIELD1 FROM TABLE1́; | ||
|---|---|---|
| Parcel | Flavor | Body |
| OK | 17 | (1, 1, 0, 33, 0, 0) |
| RecStart | 27 | |
| Field | 18 | (data) |
| RecEnd | 28 | |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |