Field Mode requests may return the following parcels:
- EndRequest (flavor 12)
- EndStatement (flavor 11)
- EndWith (flavor 35)
- Error (flavor 49)
- Failure (flavor 9)
- Field (flavor 18)
- FormatEnd (flavor 23)
- FormatStart (flavor 22)
- NullField (flavor 19)
- Ok (flavor 17)
- Position (flavor 34)
- PosEnd (flavor 47)
- PosStart (flavor 46)
- RecEnd (flavor 28)
- RecStart (flavor 28)
- Size (flavor 26)
- SizeEnd (flavor 25)
- SizeStart (flavor 24)
- TitleEnd (flavor 21)
- TitleStart (flavor 20)
- With (flavor 33)
The following examples assume successful completion of the request.
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 |
|