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 |
|