Chapter 89. sql1

Chapter 89. sql1
	Part III. SIMPOL-Language Libraries

Chapter 89. sql1

Table of Contents

sqlq1

This is the main interface to the SQL92 query engine for running reports against SIMPOL databases (both SBME and PPCS). The sqlq1 type is used to create and run queries.

sqlq1

Description

Type Tags

sqlq1

Object Value

Objects of type sqlq1 have no value, and it is an error to try to get or set this value.

sqlq1.new()

Description

Prototype

sqlq1.new ( sqlq1 me )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1

Properties

Property	Type	Description
__createcolumnnodetrees	function
__createkeywords	function
__createnodetree	function
__makeplan	function
__preparecolumnarray	function
__tokenizeclause	function
adddb1table	function
clearsettings	function
columns	array
defdisplayformats	array
filterfalse	boolean
findcolumndatatype	function
findcolumnsource	function
firstcolumn	__sql__column
firstsql1table	sql1_table
firstsqltable	__sql__table
getcolumncount	function
getcolumndatatype	function
getcolumndisplayformat	function
getcolumntableandfieldnames	function
getcolumntitle	function
getcolumnvalue	function
getrow	function
gettableindex	function
gotallrows	boolean
gotrow	boolean
hastable	function
keywords	array
lastsql1table	sql1_table
new	function
nulliszero	boolean
prepare	function
prepared	boolean
q1pi	q1planinst
retrieverecord	function
selectclause	string
selecttokens	array
setcolumndisplayformat	function
setdefaultformats	function
setnulliszero	function
setselectclause	function
setwhereclause	function
sqlnode	__sql__parsetreenode
type	type
whereclause	string
wheretokens	array

Methods

__createcolumnnodetrees()

Description

Prototype

sqlq1var.__createcolumnnodetrees ( sqlq1 me, array tokens, __sql__table firstsqltable, string errormessage, integer errorindex )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
tokens	None	array
firstsqltable	None	__sql__table
errormessage	None	string
errorindex	None	integer

__createkeywords()

Description

Prototype

sqlq1var.__createkeywords ( sqlq1 me )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1

__createnodetree()

Description

Prototype

sqlq1var.__createnodetree ( sqlq1 me, array tokens, __sql__table firstsqltable, __sql__column firstcolumn, string errormessage, integer errorindex )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
tokens	None	array
firstsqltable	None	__sql__table
firstcolumn	None	__sql__column
errormessage	None	string
errorindex	None	integer

__makeplan()

Description

Prototype

sqlq1var.__makeplan ( sqlq1 me, __sql__table firstsqltable, __sql__parsetreenode sqlnode, __sql__column firstcolumn )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
firstsqltable	None	__sql__table
sqlnode	None	__sql__parsetreenode
firstcolumn	None	__sql__column

__preparecolumnarray()

Description

Prototype

sqlq1var.__preparecolumnarray ( sqlq1 me )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1

__tokenizeclause()

Description

Prototype

sqlq1var.__tokenizeclause ( sqlq1 me, string clause, array tokens, string clausename, string errormessage, integer errorindex )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
clause	None	string
tokens	None	array
clausename	None	string
errormessage	None	string
errorindex	None	integer

adddb1table()

Description

Prototype

sqlq1var.adddb1table ( sqlq1 me, type(db1table) table, string aliasname )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
table	None	type(db1table)
aliasname	None	string

clearsettings()

Description

Prototype

sqlq1var.clearsettings ( sqlq1 me, boolean gotrow, boolean gotallrows, boolean prepared )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
gotrow	`.false`	boolean
gotallrows	`.false`	boolean
prepared	`.false`	boolean

findcolumndatatype()

Description

Prototype

sqlq1var.findcolumndatatype ( sqlq1 me, integer colno )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1
colno	None	integer

findcolumnsource()

Description

Prototype

sqlq1var.findcolumnsource ( sqlq1 me, integer colno )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1
colno	None	integer

getcolumncount()

Description

Prototype

sqlq1var.getcolumncount ( sqlq1 me )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1

getcolumndatatype()

Description

Prototype

sqlq1var.getcolumndatatype ( sqlq1 me, integer colno, string errormessage )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
colno	None	integer
errormessage	None	string

getcolumndisplayformat()

Description

Prototype

sqlq1var.getcolumndisplayformat ( sqlq1 me, integer colno, string errormessage )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
colno	None	integer
errormessage	None	string

getcolumntableandfieldnames()

Description

Prototype

sqlq1var.getcolumntableandfieldnames ( sqlq1 me, integer colno, string tablename, string fieldname, string errormessage )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
colno	None	integer
tablename	None	string
fieldname	None	string
errormessage	None	string

getcolumntitle()

Description

Prototype

sqlq1var.getcolumntitle ( sqlq1 me, integer colno, string errormessage )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
colno	None	integer
errormessage	None	string

getcolumnvalue()

Description

Prototype

sqlq1var.getcolumnvalue ( sqlq1 me, integer colno, string errormessage )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
colno	None	integer
errormessage	None	string

getrow()

Description

Prototype

sqlq1var.getrow ( sqlq1 me, string errormessage, integer error )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
errormessage	None	string
error	None	integer

gettableindex()

Description

Prototype

sqlq1var.gettableindex ( sqlq1 me, string tablename )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1
tablename	None	string

hastable()

Description

Prototype

sqlq1var.hastable ( sqlq1 me, string tablename )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1
tablename	None	string

prepare()

Description

Prototype

sqlq1var.prepare ( sqlq1 me, string errormessage, integer errorindex )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
errormessage	None	string
errorindex	None	integer

retrieverecord()

Description

Prototype

sqlq1var.retrieverecord ( sqlq1 me, integer tableindex, string errormessage )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
tableindex	`1`	integer
errormessage	None	string

setcolumndisplayformat()

Description

Prototype

sqlq1var.setcolumndisplayformat ( sqlq1 me, integer colno, string displayformat, string errormessage )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
colno	None	integer
displayformat	None	string
errormessage	None	string

setdefaultformats()

Description

Prototype

sqlq1var.setdefaultformats ( sqlq1 me, string defnumberformat, string defdateformat, string deftimeformat, string defdatetimeformat, string defintegerformat, string defbooleanformat )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
defnumberformat	None	string
defdateformat	None	string
deftimeformat	None	string
defdatetimeformat	None	string
defintegerformat	None	string
defbooleanformat	None	string

setnulliszero()

Description

Prototype

sqlq1var.setnulliszero ( sqlq1 me, boolean nulliszero )

Parameters

Parameter	Default value	Type name	Description
me	None	sqlq1
nulliszero	`.true`	boolean

setselectclause()

Description

Prototype

sqlq1var.setselectclause ( sqlq1 me, string selectclause, string errormessage, integer errorindex )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
selectclause	None	string
errormessage	None	string
errorindex	None	integer

setwhereclause()

Description

Prototype

sqlq1var.setwhereclause ( sqlq1 me, string whereclause, string errormessage, integer errorindex )

Parameters

Parameter	Default value	Type name
me	None	sqlq1
whereclause	None	string
errormessage	None	string
errorindex	None	integer


Chapter 88. soundlib		Chapter 90. STR