STATEMENT

Insert

Update

Delete

Select

Set

Get

Template

quick reference

*

Comment, must be the first character

TemplateCode

X

X

X

X

X

X

X

the unassigned data in the template is sent

Stmt

X

X

X

X

X

X

insert, update, delete, select, set, get

Lang

X

X

X

X

X

X

X

Project specific language

Field

X

X

X

X

comma separated field list

ParamF

X

X

X

for INSERT and UPDATE

Where

X

X

X

X

WHERE field list (e.g. col_key=?)

ParamW

X

X

X

X

WHERE parameters (multitag)
(e.g.
<paramw>x1</paramw>
<paramw>x2</paramw>

Order

X

X

list of fields for ORDER BY

Group

X

X

list of fields for GROUP BY

OtherCmd

X

X

e.g LIMIT 10

ReturnSelect

X

X

TEMPLATE, STRING, CSV, JSON, XML

RowHeading

X

for ReturnSelect = STRING or CSV

QueryType

X

TABLE, RELATION, PIVOT

ResultTemplate

X

X

NOTAG, HTML (1+ htmlpage), PDF, DATA (html as stream)

AltColor

X

X

alternate row color in hex (e.g. '#bacf97')

ImgView

X

X

W=view+link, V=view, L=link

ImgWidth

X

X

image width

ImgHeight

X

X

image height

ReturnFile

X

For ReturnSelect=STRING : FILEURL, FILESTR

RowPerPage

X

X

Row per Page for ResultTemplate=HTML or PDF

PageSetIcon

X

X

01, 02, 03, 04. In the future they can always be added consecutively numerically

hPagePosIcon

X

X

HTL, HTC, HTR, HBL, HBC, HBR
H=header, T=top, B=bottom, L=left, C=center, R=right

fPagePosIcon

X

X

FTL, FTC, FTR, FBL, FBC, FBR
F=footer, T=top, B=bottom, L=left, C=center, R=right

pdfSizePage

X

X

A0...A4... etc.

pdfOrientament

X

X

Portrait/Landscape

key

X

X

X

for SET : key=value (e.g. name=henry)
For GET : key (e.g. col_key=name)
for DELETE : key (e.g. col_key=name)

ReturnGet

X

VALUE, IDTABLE, USER, IDKEY, FILEURL, FILESTR