Chapter 58. odbcsql1

Chapter 58. odbcsql1
	Part III. SIMPOL-Language Libraries

Chapter 58. odbcsql1

Table of Contents

odbcsql1

odbcsql1

Description

Type Tags

sqlq1

Object Value

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

odbcsql1.new()

Description

Prototype

odbcsql1.new ( odbcsql1 me )

Parameters

Parameter	Default value	Type name	Description
me	None	odbcsql1

Properties

Property	Type	Description
clearsettings	function
columns	array
connection	odbc1connection
defdisplayformats	array
executed	boolean
findcolumndatatype	function
findcolumnsource	function
getcolumncount	function
getcolumndatatype	function
getcolumndisplayformat	function
getcolumntableandfieldnames	function
getcolumntitle	function
getcolumnvalue	function
getrow	function
gotallrows	boolean
gotrow	boolean
hastable	function
new	function
orderclause	string
prepare	function
prepared	boolean
rowdata	array
selectclause	string
setcolumndisplayformat	function
setdefaultformats	function
setodbcconnection	function
setorderclause	function
setselectclause	function
setwhereclause	function
statement	odbc1statement
type	type
whereclause	string

Methods

clearsettings()

Description

Prototype

odbcsql1var.clearsettings ( odbcsql1 me, boolean gotrow, boolean gotallrows, boolean prepared, boolean executed )

Parameters

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

findcolumndatatype()

Description

Prototype

odbcsql1var.findcolumndatatype ( odbcsql1 me, integer colno, string errormessage )

Parameters

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

findcolumnsource()

Description

Prototype

odbcsql1var.findcolumnsource ( odbcsql1 me, integer colno )

Parameters

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

getcolumncount()

Description

Prototype

odbcsql1var.getcolumncount ( odbcsql1 me, string errormessage )

Parameters

Parameter	Default value	Type name	Description
me	None	odbcsql1
errormessage	None	string

getcolumndatatype()

Description

Prototype

odbcsql1var.getcolumndatatype ( odbcsql1 me, integer colno, string errormessage )

Parameters

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

getcolumndisplayformat()

Description

Prototype

odbcsql1var.getcolumndisplayformat ( odbcsql1 me, integer colno, string errormessage )

Parameters

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

getcolumntableandfieldnames()

Description

Prototype

odbcsql1var.getcolumntableandfieldnames ( odbcsql1 me, integer colno, string tablename, string fieldname, string errormessage )

Parameters

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

getcolumntitle()

Description

Prototype

odbcsql1var.getcolumntitle ( odbcsql1 me, integer colno, string errormessage )

Parameters

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

getcolumnvalue()

Description

Prototype

odbcsql1var.getcolumnvalue ( odbcsql1 me, integer colno, string errormessage )

Parameters

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

getrow()

Description

Prototype

odbcsql1var.getrow ( odbcsql1 me, string errormessage, integer error )

Parameters

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

hastable()

Description

Prototype

odbcsql1var.hastable ( odbcsql1 me, string tablename )

Parameters

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

prepare()

Description

Prototype

odbcsql1var.prepare ( odbcsql1 me, string errormessage, integer errorindex )

Parameters

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

setcolumndisplayformat()

Description

Prototype

odbcsql1var.setcolumndisplayformat ( odbcsql1 me, integer colno, string displayformat, string errormessage )

Parameters

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

setdefaultformats()

Description

Prototype

odbcsql1var.setdefaultformats ( odbcsql1 me, string defnumberformat, string defdateformat, string deftimeformat, string defdatetimeformat, string defintegerformat, string defbooleanformat )

Parameters

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

setodbcconnection()

Description

Prototype

odbcsql1var.setodbcconnection ( odbcsql1 me, odbc1connection connection )

Parameters

Parameter	Default value	Type name	Description
me	None	odbcsql1
connection	None	odbc1connection

setorderclause()

Description

Prototype

odbcsql1var.setorderclause ( odbcsql1 me, string orderclause )

Parameters

Parameter	Default value	Type name	Description
me	None	odbcsql1
orderclause	None	string

setselectclause()

Description

Prototype

odbcsql1var.setselectclause ( odbcsql1 me, string selectclause, string errormessage, integer errorindex )

Parameters

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

setwhereclause()

Description

Prototype

odbcsql1var.setwhereclause ( odbcsql1 me, string whereclause, string errormessage, integer errorindex )

Parameters

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


objsetelementref		Chapter 59. PAD