Issuing Requests: Field Mode - Call-Level Interface Version 2

Issuing Requests: Field Mode

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.

Table 25: Update Table1 Set Field1 = 999999; 

Parcel	Flavor	Body
Ok	17	(1, 0, 23, 3, 0, 0)
EndStatement	11	(1)
EndRequest	12

Table 26: 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

Table 27: 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

Table 28: 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

Table 29: 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