[ver]
	4
[sty]
	
[files]
[charset]
	82
	ANSI (Windows, IBM CP 1252)
[revisions]
	0
[prn]
	Apple LaserWriter II NTX
[port]
	LPT1:
[lang]
	1
[fldnames]
	Field1
	Field2
	Field3
	Field4
	Field5
	Field6
	Field7
	Field8
[desc]
	
	
	
	
	
	802648470
	41
	794467469
	4029
	64
	3097
	18921
	34
	53
	
	
	
	
	
	
	1
[fopts]
	0
	1
	0
	0
	
	
[lnopts]
	2
	Body Text
	1
[docopts]
	5
	2
[GramStyle]
	
[ParaNum]
	1
[tag]
	Body Text
	2
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		100
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Body Text
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Ahead
	3
	[fnt]
		Arial
		220
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		240
		4
		79
		0
		3
		100
	[brk]
		112
	[line]
		16
		2160
		3
		0
		1
		1
		1
		65
		10
		1
	[spec]
		0
		1
		
		0
		1
		1
		0
		2
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		wr
	Body Text
	0
	0
[tag]
	Bhead title
	4
	[fnt]
		Arial
		200
		0
		16385
	[algn]
		1
		1
		0
		0
		0
	[spc]
		40
		220
		4
		79
		0
		3
		100
	[brk]
		80
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		2
		
		0
		1
		1
		0
		2
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		wr
	Body Text
	0
	0
[tag]
	Chead title
	5
	[fnt]
		Arial
		180
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		200
		4
		79
		0
		3
		100
	[brk]
		112
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		3
		
		0
		1
		1
		0
		2
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		wr
	Body Text
	0
	0
[tag]
	Bhead
	6
	[fnt]
		Arial
		200
		0
		16385
	[algn]
		1
		1
		0
		0
		0
	[spc]
		40
		220
		4
		180
		0
		3
		100
	[brk]
		68
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		2
		
		0
		1
		1
		0
		2
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Body Text
	0
	0
[tag]
	Chead
	7
	[fnt]
		Arial
		180
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		200
		4
		100
		0
		3
		100
	[brk]
		68
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		3
		
		0
		1
		1
		0
		2
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Body Text
	0
	0
[tag]
	Numbered list
	8
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		300
		300
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		5
		<*:>.
		0
		3
		1
		0
		2
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Numbered list
	0
	0
[tag]
	1st lev para
	9
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		300
		0
		0
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		68
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	1st lev para
	0
	0
[tag]
	Bullet
	11
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		120
		180
		180
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		</U>
		0
		3
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Bullet
	2
	1
	160
	1
	400
	0
[tag]
	Indnt bullet
	12
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		420
		180
		180
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		16
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		</U>
		0
		3
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Indnt bullet
	0
	0
[tag]
	2nd lev para
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		600
		0
		0
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	2nd lev para
	0
	0
[tag]
	See also prnt
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	See also prnt
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Book art
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Book art
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Callout text
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Callout text
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Figure title
	0
	[fnt]
		Arial
		180
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		200
		4
		40
		60
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Figure title
	0
	0
[tag]
	Chapter title
	0
	[fnt]
		Arial
		280
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		300
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		2
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Chapter title
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	1st pg foot
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	1st pg foot
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Right pg foot
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Right pg foot
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Left pg foot
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Left pg foot
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Table title
	0
	[fnt]
		Arial
		180
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		200
		4
		60
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		7
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Table title
	0
	0
[tag]
	Table col hd
	0
	[fnt]
		Arial
		180
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		200
		4
		100
		0
		3
		100
	[brk]
		4
	[line]
		10
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		6
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		256
		1
		0
		
		
		
	Table col hd
	0
	0
[tag]
	Table Text
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		1
		0
		0
		0
	[spc]
		40
		200
		4
		79
		0
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		256
		1
		0
		
		
		
	Table Text
	0
	0
[tag]
	See also hlp
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		40
		4
		180
		0
		3
		100
	[brk]
		96
	[line]
		9
		0
		3
		0
		1
		1
		1
		70
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	See also btn
	0
	120
[tag]
	See also btn
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		240
	[spc]
		24
		200
		4
		0
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	See also btn
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Crossref
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		513
		3
		0
		300
		600
	[spc]
		24
		200
		4
		19
		0
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Crossref
	0
	0
[tag]
	Indnt caution
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		300
		720
		0
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		Caution
		0
		3
		1
		1
		0
		0
		0
	[nfmt]
		256
		1
		2
		.
		,
		$
	Indnt caution
	0
	0
[tag]
	Indnt tip
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		300
		324
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		Tip
		0
		3
		1
		1
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Indnt tip
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Indnt note
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		300
		468
		0
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		Note
		0
		3
		1
		1
		0
		0
		0
	[nfmt]
		256
		1
		2
		.
		,
		$
	Indnt note
	0
	0
[tag]
	Caution
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		720
		0
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		Caution
		0
		3
		1
		1
		0
		0
		0
	[nfmt]
		256
		1
		2
		.
		,
		$
	Caution
	0
	0
[tag]
	Tip
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		324
		0
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		Tip
		0
		3
		1
		1
		0
		0
		0
	[nfmt]
		256
		1
		2
		.
		,
		$
	Tip
	0
	0
[tag]
	Note
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		468
		0
	[spc]
		40
		200
		4
		19
		60
		3
		100
	[brk]
		4
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		Note
		0
		3
		1
		1
		0
		0
		0
	[nfmt]
		256
		1
		2
		.
		,
		$
	Note
	0
	0
[tag]
	Mono
	0
	[fnt]
		Courier New
		180
		0
		32768
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		48
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Mono
	15
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	1
	2880
	1
	3360
	1
	3840
	1
	4320
	1
	4800
	1
	5280
	1
	5760
	1
	6240
	1
	6720
	1
	7200
	0
[tag]
	Indnt mono
	0
	[fnt]
		Courier New
		180
		0
		32768
	[algn]
		1
		3
		300
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		32
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Indnt mono
	15
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	1
	2880
	1
	3360
	1
	3840
	1
	4320
	1
	4800
	1
	5280
	1
	5760
	1
	6240
	1
	6720
	1
	7200
	0
[tag]
	Dhead
	0
	[fnt]
		Arial
		180
		0
		16385
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		200
		4
		100
		0
		3
		100
	[brk]
		68
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		4
		
		0
		1
		1
		0
		2
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		$
	Body Text
	0
	0
[tag]
	Parameter
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		0
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Parameter
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	Formula
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Formula
	0
	0
[tag]
	Browse
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		+
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Browse
	0
	0
[tag]
	Keyword
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		K
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Keyword
	0
	0
[tag]
	Context
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		#
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Context
	0
	0
[tag]
	Title
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		$
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Title
	0
	0
[tag]
	Macros
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		!
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Macros
	0
	0
[tag]
	Footnote
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		244
		0
	[spc]
		40
		2400
		3
		0
		0
		1
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		256
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	Footnote
	0
	0
[tag]
	Alink
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		A
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Alink
	0
	0
[tag]
	Butnbar
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		40
		200
		4
		0
		0
		3
		100
	[brk]
		48
	[line]
		16
		0
		3
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		\li-140 
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		272
		1
		2
		.
		,
		wr
	Butnbar
	0
	0
[tag]
	Window
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		>
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Window
	0
	0
[tag]
	Win95 macros
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		W
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Win95 macros
	0
	0
[tag]
	Win31 macros
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		X
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Win31 macros
	0
	0
[tag]
	Build tag
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		139
		139
	[spc]
		24
		200
		4
		0
		0
		3
		100
	[brk]
		4
	[line]
		16
		0
		3
		0
		1
		2
		2
		20
		20
		1
	[spec]
		0
		0
		*
		0
		3
		1
		256
		1
		0
		0
	[nfmt]
		280
		1
		3
		.
		,
		$
	Build tag
	0
	0
[tag]
	_COND_IF
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	_COND_IF
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	_COND_ELSE
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	_COND_ELSE
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[tag]
	_COND_ENDIF
	0
	[fnt]
		Arial
		180
		0
		16384
	[algn]
		1
		3
		0
		0
		0
	[spc]
		24
		200
		4
		19
		60
		3
		100
	[brk]
		36
	[line]
		8
		0
		1
		0
		1
		1
		1
		10
		10
		1
	[spec]
		0
		0
		
		0
		1
		1
		0
		0
		0
		0
	[nfmt]
		280
		1
		2
		.
		,
		$
	_COND_ENDIF
	5
	1
	480
	1
	960
	1
	1440
	1
	1920
	1
	2400
	0
[frm]
	1
	1573060
	360
	9185
	4418
	9550
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	35
	0
	0
	64852 24203
	[frmlay]
		9516
		4058
		1
		0
		0
		1
		9185
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 2403 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
Connected successfully

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Failed to connect

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	8860
	5031
	9633
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	34
	1
	6912
	0 1280
	[frmlay]
		10199
		4671
		1
		0
		0
		1
		8860
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 3016 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
Cursor position is at the last row

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Error

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	10371
	5228
	11144
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	33
	2
	0
	25856 0
	[frmlay]
		9200
		4868
		1
		0
		0
		1
		10371
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 818 86 2 0
			 1 3835 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The stored procedure executed successfully

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Error

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	10298
	4819
	10663
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	32
	3
	255
	65280 255
	[frmlay]
		4834
		4459
		1
		0
		0
		1
		10298
		0
		0
		2
		0
		1
		1
		0
		1
		1044
		9242
		0
	[tbl]
		 4 2 0 86 4132 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
			 2 279 86 2 0 2 0
			 3 279 86 2 0 2 0
		[e]
		[w]
			 0 2096 86 2 0
			 1 2148 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
DB_NORESULT

>
			 0 1 0 0 0 0 0 1 0 0 0 0
no result

>
			 1 0 0 0 0 0 0 1 0 0 0 0
DB_ROWSUNKNOWN

>
			 1 1 0 0 0 0 0 1 0 0 0 0
rows unknown

>
			 2 0 0 0 0 0 0 1 0 0 0 0
DB_ROWSLIMITED

>
			 2 1 0 0 0 0 0 1 0 0 0 0
rows artificially limited

>
			 3 0 0 0 0 0 0 1 0 0 0 0
+<+">n<-">

>
			 3 1 0 0 0 0 0 1 0 0 0 0
result set has <+">n<-"> rows

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	8740
	3847
	9513
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	30
	4
	768
	4 24916
	[frmlay]
		6468
		3487
		1
		0
		0
		1
		8740
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 784 86 2 0
			 1 2488 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
Exclusive mode is in effect

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Error

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	9368
	5440
	9733
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	28
	5
	0
	33752 2796
	[frmlay]
		4355
		5080
		1
		0
		0
		1
		9368
		0
		0
		2
		0
		0
		0
		0
		1
		1284
		9482
		0
	[tbl]
		 2 2 0 86 4132 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 733 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
SilentMode is successfully set.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Error

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	2364
	6113
	2729
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	14
	6
	0
	20502 7935
	[frmlay]
		4646
		5753
		1
		0
		0
		1
		2364
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 784 86 2 0
			 1 4754 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The cursor is on the last record.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
The cursor is not on the last record.

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	7226
	5841
	8199
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	13
	7
	3190
	65367 2166
	[frmlay]
		6468
		5481
		1
		0
		0
		1
		7226
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 479 86 2 0 1 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 784 86 2 0
			 1 4482 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
Values in the current row are different in cache from those in the database.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Values have not been altered.

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	7591
	6633
	8364
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	12
	8
	3738
	0 0
	[frmlay]
		8857
		6273
		1
		0
		0
		1
		7591
		0
		0
		2
		0
		1
		0
		2
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 4618 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The row was updated successfully

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
The row has been altered by another user or process

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	6920
	4401
	7285
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	11
	9
	3738
	0 0
	[frmlay]
		779
		4041
		1
		0
		0
		1
		6920
		0
		0
		2
		0
		1
		0
		2
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 2386 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
@Body Text@DB_COMMIT

>
			 0 1 0 0 0 0 0 1 0 0 0 0
@Body Text@changes are committed

>
			 1 0 0 0 0 0 0 1 0 0 0 0
@Body Text@DB_ROLLBACK

>
			 1 1 0 0 0 0 0 1 0 0 0 0
@Body Text@changes are rolled back

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	11245
	5440
	12697
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	10
	10
	255
	20497 18061
	[frmlay]
		10558
		5080
		1
		0
		0
		1
		11245
		0
		0
		2
		0
		1
		1
		0
		1
		684
		3448
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 958 86 2 0 1 0
		[e]
		[w]
			 1 3425 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
TRUE

>
			 0 1 0 0 0 0 0 1 0 0 0 0
Parameter was successfully set.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
FALSE

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Parameter name or ordinal value was not found.

Parameter argument for string value was not enclosed in quotes. (??correct)

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	9319
	5440
	10492
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	8
	11
	255
	20497 18061
	[frmlay]
		10378
		5080
		1
		0
		0
		1
		9319
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 479 86 2 0 1 0
			 1 479 86 2 0 1 0
		[e]
		[w]
			 1 3425 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
TRUE

>
			 0 1 0 0 0 0 0 1 0 0 0 0
Current value in specified column is updated by <+">value.<-">

>
			 1 0 0 0 0 0 0 1 0 0 0 0
FALSE

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Value cannot be changed, as when the database is read-only.

>
		[e]
	[tble]
[frm]
	1
	1573060
	960
	2515
	2878
	4560
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	5
	12
	0
	5356 22103
	[frmlay]
		1736
		1918
		1
		0
		0
		1
		2515
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 7 1 200 86 1440 86 1 43 43
		[h]
			 0 200 86 2 0 1 0
			 1 200 86 2 0 1 0
			 2 200 86 2 0 1 0
			 3 200 86 2 0 1 0
			 4 200 86 2 0 1 0
			 5 200 86 2 0 1 0
			 6 200 86 2 0 1 0
		[e]
		[w]
			 0 1789 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
DataSource Name

>
			 1 0 0 0 0 0 0 1 0 0 0 0
DisconnectTimeOut

>
			 2 0 0 0 0 0 0 1 0 0 0 0
Exclusive

>
			 3 0 0 0 0 0 0 1 0 0 0 0
IsSupported

>
			 4 0 0 0 0 0 0 1 0 0 0 0
IsTimedOut

>
			 5 0 0 0 0 0 0 1 0 0 0 0
IsConnected

>
			 6 0 0 0 0 0 0 1 0 0 0 0
SilentMode

>
		[e]
	[tble]
[frm]
	1
	1573060
	960
	4939
	6100
	6698
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	6
	13
	0
	7767 46952
	[frmlay]
		5878
		5140
		1
		0
		0
		1
		4939
		0
		0
		2
		0
		0
		0
		0
		1
		1104
		9302
		0
	[tbl]
		 6 2 200 86 4132 86 1 43 43
		[h]
			 0 200 86 2 0 2 0
			 1 200 86 2 0 2 0
			 2 200 86 2 0 2 0
			 3 200 86 2 0 2 0
			 4 200 86 2 0 2 0
			 5 200 86 2 0 1 0
		[e]
		[w]
			 0 2437 86 2 0
			 1 2488 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
ConnectTo

>
			 0 1 0 0 0 0 0 1 0 0 0 0
GetRegistrationInfo

>
			 1 0 0 0 0 0 0 1 0 0 0 0
Disconnect

>
			 1 1 0 0 0 0 0 1 0 0 0 0
ListDataSources

>
			 2 0 0 0 0 0 0 1 0 0 0 0
ExecProcedure

>
			 2 1 0 0 0 0 0 1 0 0 0 0
ListFields

>
			 3 0 0 0 0 0 0 1 0 0 0 0
GetError

>
			 3 1 0 0 0 0 0 1 0 0 0 0
ListProcedures

>
			 4 0 0 0 0 0 0 1 0 0 0 0
GetErrorMessage

>
			 4 1 0 0 0 0 0 1 0 0 0 0
ListTables

>
			 5 0 0 0 0 0 0 1 0 0 0 0
GetExtendedErrorMessage

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	10178
	7530
	12046
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	7
	14
	0
	15488 29728
	[frmlay]
		5668
		7170
		1
		0
		0
		1
		10178
		0
		0
		2
		0
		1
		1
		0
		1
		504
		6320
		0
	[tbl]
		 5 4 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 4 0
			 1 279 86 2 0 4 0
			 2 279 86 2 0 4 0
			 3 279 86 2 0 4 0
			 4 279 86 2 0 3 0
		[e]
		[w]
			 0 1466 86 2 0
			 1 1466 86 2 0
			 2 1738 86 2 0
			 3 2113 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
SQL_CHAR

>
			 0 1 0 0 0 0 0 1 0 0 0 0
SQL_SMALLINT

>
			 0 2 0 0 0 0 0 1 0 0 0 0
SQL_TIME

>
			 0 3 0 0 0 0 0 1 0 0 0 0
SQL_LONGVARBINARY

>
			 1 0 0 0 0 0 0 1 0 0 0 0
SQL_NUMERIC

>
			 1 1 0 0 0 0 0 1 0 0 0 0
SQL_FLOAT

>
			 1 2 0 0 0 0 0 1 0 0 0 0
SQL_TIMESTAMP

>
			 1 3 0 0 0 0 0 1 0 0 0 0
SQL_BIGINT

>
			 2 0 0 0 0 0 0 1 0 0 0 0
SQL_NUMERIC

>
			 2 1 0 0 0 0 0 1 0 0 0 0
 SQL_REAL

>
			 2 2 0 0 0 0 0 1 0 0 0 0
SQL_VARCHAR

>
			 2 3 0 0 0 0 0 1 0 0 0 0
SQL_TINYINT

>
			 3 0 0 0 0 0 0 1 0 0 0 0
 SQL_DECIMAL

>
			 3 1 0 0 0 0 0 1 0 0 0 0
SQL_DOUBLE

>
			 3 2 0 0 0 0 0 1 0 0 0 0
SQL_BINARY

>
			 3 3 0 0 0 0 0 1 0 0 0 0
SQL_BIT

>
			 4 0 0 0 0 0 0 1 0 0 0 0
SQL_INTEGER

>
			 4 1 0 0 0 0 0 1 0 0 0 0
SQL_DATE

>
			 4 2 0 0 0 0 0 1 0 0 0 0
SQL_VARBINARY

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	7547
	5313
	8112
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	15
	15
	0
	47658 12
	[frmlay]
		8398
		4953
		1
		0
		0
		1
		7547
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 479 86 2 0 1 0
		[e]
		[w]
			 0 699 86 2 0
			 1 4039 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
This database will operate in auto-commit mode.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
This database will operate in transaction mode, allowing manual commit or rollback.

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	10934
	6054
	11585
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	17
	16
	0
	47658 12
	[frmlay]
		8578
		5694
		1
		0
		0
		1
		10934
		0
		0
		2
		0
		1
		1
		0
		1
		684
		3448
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 200 86 2 0 1 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 4039 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The connection to the data source or database is currently established.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Error

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	2614
	6054
	3387
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	19
	17
	0
	47658 12
	[frmlay]
		8758
		5694
		1
		0
		0
		1
		2614
		0
		0
		2
		0
		1
		1
		0
		1
		864
		3628
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 4039 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The result set or database is read-only

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
The result set or database can be updated.

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	8265
	7587
	8630
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	21
	18
	0
	47658 12
	[frmlay]
		8758
		7227
		1
		0
		0
		1
		8265
		0
		0
		2
		0
		1
		1
		0
		1
		864
		3628
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 5572 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The result set has been retrieved with at least one row of data.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
No result set is available.

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	7884
	5662
	8249
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	20
	19
	0
	47658 12
	[frmlay]
		13340
		5302
		1
		0
		0
		1
		7884
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 3647 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The listed option is supported

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
The listed option is not supported.

>
		[e]
	[tble]
[frm]
	13
	1573060
	360
	9770
	5440
	10543
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	22
	20
	0
	33752 2796
	[frmlay]
		4175
		5080
		1
		0
		0
		1
		9770
		0
		0
		2
		0
		0
		0
		0
		1
		1104
		9302
		0
	[tbl]
		 2 2 0 86 4132 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 733 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The connection has timed out

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Error

>
		[e]
	[tble]
[frm]
	1
	1573060
	960
	9092
	3850
	9993
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	25
	21
	0
	5356 22103
	[frmlay]
		1916
		2890
		1
		0
		0
		1
		9092
		0
		0
		2
		0
		1
		1
		0
		1
		684
		3448
		0
	[tbl]
		 3 1 200 86 1440 86 1 43 43
		[h]
			 0 200 86 2 0 1 0
			 1 200 86 2 0 1 0
			 2 200 86 2 0 1 0
		[e]
		[w]
			 0 2761 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
Connection

>
			 1 0 0 0 0 0 0 1 0 0 0 0
QueryExecuteTimeOut

>
			 2 0 0 0 0 0 0 1 0 0 0 0
SQL

>
		[e]
	[tble]
[frm]
	1
	1573060
	960
	10372
	3441
	11273
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	24
	22
	0
	7767 46952
	[frmlay]
		5878
		2481
		1
		0
		0
		1
		10372
		0
		0
		2
		0
		0
		0
		0
		1
		1104
		9302
		0
	[tbl]
		 3 1 200 86 4132 86 1 43 43
		[h]
			 0 200 86 2 0 1 0
			 1 200 86 2 0 1 0
			 2 200 86 2 0 1 0
		[e]
		[w]
			 0 2352 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
GetError

>
			 1 0 0 0 0 0 0 1 0 0 0 0
GetErrorMessage

>
			 2 0 0 0 0 0 0 1 0 0 0 0
GetExtendedErrorMessage

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	8905
	5552
	9270
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	27
	23
	0
	5356 22103
	[frmlay]
		1916
		5192
		1
		0
		0
		1
		8905
		0
		0
		2
		0
		1
		1
		0
		1
		684
		3448
		0
	[tbl]
		 5 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
			 2 279 86 2 0 2 0
			 3 279 86 2 0 2 0
			 4 279 86 2 0 1 0
		[e]
		[w]
			 0 2318 86 2 0
			 1 2659 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
CacheLimit

>
			 0 1 0 0 0 0 0 1 0 0 0 0
IsBeginOfData

>
			 1 0 0 0 0 0 0 1 0 0 0 0
CurrentRow

>
			 1 1 0 0 0 0 0 1 0 0 0 0
IsEndOfData

>
			 2 0 0 0 0 0 0 1 0 0 0 0
FetchBatchSize

>
			 2 1 0 0 0 0 0 1 0 0 0 0
IsReadOnly

>
			 3 0 0 0 0 0 0 1 0 0 0 0
HasRowChanged

>
			 3 1 0 0 0 0 0 1 0 0 0 0
IsResultSetAvailable

>
			 4 0 0 0 0 0 0 1 0 0 0 0
IsAutoCommit

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	8928
	5347
	9293
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	26
	24
	0
	7767 46952
	[frmlay]
		6058
		4987
		1
		0
		0
		1
		8928
		0
		0
		2
		0
		0
		0
		0
		1
		1284
		9482
		0
	[tbl]
		 17 2 0 86 4132 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
			 2 279 86 2 0 2 0
			 3 279 86 2 0 2 0
			 4 279 86 2 0 2 0
			 5 279 86 2 0 2 0
			 6 279 86 2 0 2 0
			 7 279 86 2 0 2 0
			 8 279 86 2 0 2 0
			 9 279 86 2 0 2 0
			 10 279 86 2 0 2 0
			 11 279 86 2 0 2 0
			 12 279 86 2 0 2 0
			 13 279 86 2 0 2 0
			 14 279 86 2 0 2 0
			 15 279 86 2 0 2 0
			 16 279 86 2 0 1 0
		[e]
		[w]
			 0 2284 86 2 0
			 1 2488 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
AddRow

>
			 0 1 0 0 0 0 0 1 0 0 0 0
LastRow

>
			 1 0 0 0 0 0 0 1 0 0 0 0
Close

>
			 1 1 0 0 0 0 0 1 0 0 0 0
LocateRow

>
			 2 0 0 0 0 0 0 1 0 0 0 0
DeleteRow

>
			 2 1 0 0 0 0 0 1 0 0 0 0
NextResultSet

>
			 3 0 0 0 0 0 0 1 0 0 0 0
Execute

>
			 3 1 0 0 0 0 0 1 0 0 0 0
NextRow

>
			 4 0 0 0 0 0 0 1 0 0 0 0
FieldExpectedDataType

>
			 4 1 0 0 0 0 0 1 0 0 0 0
NumColumns

>
			 5 0 0 0 0 0 0 1 0 0 0 0
FieldID

>
			 5 1 0 0 0 0 0 1 0 0 0 0
NumParameters

>
			 6 0 0 0 0 0 0 1 0 0 0 0
FieldInfo

>
			 6 1 0 0 0 0 0 1 0 0 0 0
NumResultSets

>
			 7 0 0 0 0 0 0 1 0 0 0 0
FieldName

>
			 7 1 0 0 0 0 0 1 0 0 0 0
NumRows

>
			 8 0 0 0 0 0 0 1 0 0 0 0
FieldNativeDataType

>
			 8 1 0 0 0 0 0 1 0 0 0 0
Options

>
			 9 0 0 0 0 0 0 1 0 0 0 0
FieldSize

>
			 9 1 0 0 0 0 0 1 0 0 0 0
RefreshRow

>
			 10 0 0 0 0 0 0 1 0 0 0 0
FirstRow

>
			 10 1 0 0 0 0 0 1 0 0 0 0
Query

>
			 11 0 0 0 0 0 0 1 0 0 0 0
GetError

>
			 11 1 0 0 0 0 0 1 0 0 0 0
PrevRow

>
			 12 0 0 0 0 0 0 1 0 0 0 0
GetErrorMessage

>
			 12 1 0 0 0 0 0 1 0 0 0 0
SetParameter

>
			 13 0 0 0 0 0 0 1 0 0 0 0
GetExtendedErrorMessage

>
			 13 1 0 0 0 0 0 1 0 0 0 0
SetValue

>
			 14 0 0 0 0 0 0 1 0 0 0 0
GetParameter

>
			 14 1 0 0 0 0 0 1 0 0 0 0
Transactions

>
			 15 0 0 0 0 0 0 1 0 0 0 0
GetParameterName

>
			 15 1 0 0 0 0 0 1 0 0 0 0
UpdateRow

>
			 16 0 0 0 0 0 0 1 0 0 0 0
GetValue

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	7943
	6957
	8716
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	29
	25
	3738
	0 0
	[frmlay]
		8857
		6597
		1
		0
		0
		1
		7943
		0
		0
		2
		0
		1
		0
		2
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 1 4942 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The changes were committed or rolled back successfully

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Error

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	5152
	6113
	5517
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	31
	26
	0
	20502 7935
	[frmlay]
		4826
		5753
		1
		0
		0
		1
		5152
		0
		0
		2
		0
		1
		1
		0
		1
		684
		3448
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 784 86 2 0
			 1 4754 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
The cursor is on the first record.

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
The cursor is not on the first record.

>
		[e]
	[tble]
[frm]
	1
	1573060
	360
	9527
	4255
	9892
	0
	1
	1
	1 0 0 0 0 0 0
	0
	16777215
	36
	27
	3327
	0 65280
	[frmlay]
		9878
		3895
		1
		0
		0
		1
		9527
		0
		0
		2
		0
		1
		1
		0
		1
		504
		3268
		0
	[tbl]
		 2 2 0 86 1440 86 1 43 43
		[h]
			 0 279 86 2 0 2 0
			 1 279 86 2 0 2 0
		[e]
		[w]
			 0 937 86 2 0
			 1 2743 86 2 0
		[e]
		[data]
			 0 0 0 0 0 0 0 1 0 0 0 0
True

>
			 0 1 0 0 0 0 0 1 0 0 0 0
Disconnected successfully

>
			 1 0 0 0 0 0 0 1 0 0 0 0
False

>
			 1 1 0 0 0 0 0 1 0 0 0 0
Failed to disconnect

>
		[e]
	[tble]
[lay]
	Standard
	3079
	[rght]
		12960
		10166
		1
		960
		1200
		3
		960
		720
		0
		1
		0
		1
		0
		2
		1
		960
		9446
		1
		1
		3120
	[lft]
		12960
		10166
		1
		720
		1200
		3
		960
		960
		0
		1
		0
		1
		0
		2
		1
		720
		9206
		1
		1
		3120
	[hlft]
	[lyfrm]
		1
		3008
		0
		0
		10166
		960
		0
		1
		3
		1 0 0 0 0 0 0
		0
		0
		3
	[frmlay]
		960
		10166
		1
		720
		180
		3
		0
		960
		0
		1
		0
		1
		1
		0
		1
		720
		9206
		1
		2
		4674
	[txt]
>
	[hrght]
	[lyfrm]
		1
		11200
		0
		0
		10166
		960
		0
		1
		3
		1 0 0 0 0 0 0
		0
		0
		1
	[frmlay]
		960
		10166
		1
		960
		180
		3
		0
		720
		0
		1
		0
		1
		1
		0
		1
		960
		9446
		1
		2
		4674
	[txt]
>
	[flft]
	[lyfrm]
		1
		5056
		0
		11760
		10166
		12960
		0
		1
		3
		1 0 0 0 0 0 0
		0
		0
		4
	[frmlay]
		12960
		10166
		1
		720
		480
		3
		11940
		960
		0
		1
		0
		1
		1
		0
		1
		720
		9206
		1
		3
		9900
	[txt]
<:R1,6,1,480,1,960,1,1440,1,1920,1,2400,4,8116,>Lotus Strictly Confidential	DataAccess Object Methods and Properties	<:P10,0,>

>
	[frght]
	[lyfrm]
		1
		13248
		0
		11760
		10166
		12960
		0
		1
		3
		1 0 0 0 0 0 0
		0
		0
		2
	[frmlay]
		12960
		10166
		1
		960
		480
		3
		11940
		720
		0
		1
		0
		1
		1
		0
		1
		960
		9446
		1
		3
		9900
	[txt]
<:R1,6,1,480,1,960,1,1440,1,1920,1,2400,4,8063,>Lotus Strictly Confidential	DataAccess Object  Methods and Properties	<:P10,0,>

>
[elay]
[l1]
	0
[pg]
	1
	20 0 6 0 1 0 0 200 65535 Standard	65535 0 0	0 0 0 0 0 0 0 65535 0 0 65535 0 0 0 0 0
[edoc]
@Chapter title@<+B><:#300,8486>LotusScript Data Access Object methods and properties

<:#200,8486>(??This information to be incorporated in the <+">Lotus Notes Release 4 Programmer's Guide.<-">)

@Bhead title@<:#220,8486>Connection Class

<:#200,8486>Represents the ODBC Data Access features for connecting to a data source. 

@Chead@<:#200,8486>Properties

<:t12>

@Chead@<:#200,8486>Methods

@1st lev para@<:t13>

@Chead@<:#200,8486>Access

<:#200,8486>To create a new Connection object, use the New method.

@Bhead title@<:#220,8486>Query Class

<:#200,8486>Represents the ODBC Data Access features for defining a query.

@Ahead@<:#240,8486>New Method

<:#200,8486>	<+!>Dim<-!> <+">variableName<-"> <+!>As New Query<-!>

<:#200,8486>	<+!>Set<-!> <+">variableName<-"> = <+!>New Query<-!>

@Chead@<:#200,8486>Properties

<:t21>

@Chead@<:#200,8486>Methods

<:t22>

@Chead@<:#200,8486>Access

To create a new Query object, use the New method.

@Bhead title@<:#220,8486>ResultSet Class

<:#200,8486>Represents the ODBC Data Access features for performing operations on a result set.

@Ahead@<:#240,8486>New Method

<:#200,8486>	<+!>Dim<-!> <+">variableName<-"> <+!>As New ResultSet<-!>

<:#200,8486>	<+!>Set<-!> <+">variableName<-"> = <+!>New ResultSet<-!>

@Chead@Properties<:t23>

@Chead@<:#200,8486>Methods

<:t24>

@Chead@<:#200,8486>Access

<:#200,8486>To create a new ResultSet object, use the New method.

@Bhead title@CacheLimit Property

<:#200,8486>Specifies the number of rows to retrieve in a result set.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer<-"> = <+"><+!>ResultSetObj<-!><-">.<+!> CacheLimit<-!>

<:#200,8486><+"><+!>ResultSetObj<-!><-"><+!>. CacheLimit <-!>= <+">integer<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Integer<-">

@1st lev para@<:#200,8486>Returns the number of rows to retrieve in a result set. Disable by setting cache limit to 0.

@Chead@<:#200,8486>Usage

<:#800,8486>Use when you do not want to retrieve the entire result set. When you set a cache limit, only the number of rows specified is available, regardless of the actual number of rows that may have been available in the result set. For example if you've set the cac
he limit to 100, only the first 100 rows of a result set is available.

@Chead@<:#200,8486>Errors

<:#200,8486>??

@Chead@<:#200,8486>See also

@1st lev para@CurrentRow

@1st lev para@LastRow

@1st lev para@<:#200,8486>NextRow

@1st lev para@QueryExecuteTimeOut

@1st lev para@Options

@Bhead title@<:#220,8486>Connection Property

<:#200,8486>Relates a connection object with a query.

@Chead@<:#200,8486>Defined In

<:#200,8486>Query

@Chead@<:#200,8486>Syntax

<:#200,8486><+!>SET<-!> <+!><+">QueryObj.<-">Connection = <+">ConnectionObj.<-"><-!>

@Chead@<:#200,8486>Usage

<:#400,8486>You must use the connection property to link a connection object with a query. A query must be connected to a valid connection before it can be used or validated.

@Chead@<:#200,8486>Errors

<:#200,8486>Invalid Object

@Chead@<:#200,8486>See Also

@1st lev para@Query (??)

@Bhead title@<:#220,8486>CurrentRow Property

<:#200,8486>Reads or sets the current row.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer<-"> = <+"><+!>ResultSetObj<-!><-">.<+!> CurrentRow<-!>

<:#200,8486><+"><+!>ResultSetObj<-!><-"><+!>. CurrentRow <-!>= <+">integer<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Integer<-">

@1st lev para@<:#200,8486>Returns the location of the current row.

@Chead@<:#200,8486>Usage

<:#600,8486>Setting the current row value is equivalent to positioning the cursor to that row and may require retrieving records. Unless caching is enabled through Options, or unless the driver supports cursor positioning, it may not be possible to set the row at a loc
ation before the current row.

@Chead@<:#200,8486>Errors

<:#200,8486>No valid Result Set or table, Invalid Row referenced

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>NumRows

@1st lev para@<:#200,8486>FirstRow

@1st lev para@<:#200,8486>LastRow

@1st lev para@<:#200,8486>NextRow

@1st lev para@<:#200,8486>PrevRow

@1st lev para@<:#200,8486>LocateRow

@1st lev para@<:#200,8486>Options

@1st lev para@GetError

@Bhead title@DataSourceName Property

<:#200,8486>Reads the name of the connected data source.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">string<-"> =<+!><+"> ConnectionObj.<-"><-!><+!> DataSourceName<-!>

@Chead@<:#200,8486><+!>Return Values<-!>

String. The ODBC name of the connected data source.

@Chead@<:#200,8486>Usage

<:#200,8486>??info needed

@Chead@<:#200,8486>Errors

<:#200,8486>??

@Chead@<:#200,8486>See Also

@1st lev para@<:#200,8486>ConnectTo

@1st lev para@Disconnect

@1st lev para@ListDataSources

@Bhead title@<:#220,8486>DisconnectTimeOut Property

<:#200,8486>Specifies how long to maintain a connection before timing out and disconnecting.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+"><+!>ConnectionObj<-!><-">. <+!>DisconnectTimeOut <-!>=<+">seconds<-">

<:#200,8486><+">seconds<-"> =<+!><+"> ConnectionObj.<-"><-!><+!> DisconnectTimeOut<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Integer

@1st lev para@<:#200,8486>The number of seconds that expires before a disconnect occurs.<+"> 

@Chead@<:#200,8486>Usage

<:#400,8486>The disconnect time out is normally set to zero, indicating that no time out is set. If you set a time out value, and that period expires, a disconnect occurs.

<:#200,8486>DisconnectTimeOut prevents:

@Bullet@<:#200,8486>unwanted metered use of a database

@Bullet@<:#200,8486>users from retaining active connections to databases with limited available connections

@Bullet@<:#200,8486>access to an active, password-protected database from an unattended workstation

<:#600,8486>A reconnection attempt is automatically performed, prompting for a password if appropriate, if the data source has been timed out and is subsequently reused. This is only an issue when a script is used with visual objects.

If this parameter is one of the options selected in an autoregistration database (LOTUSDS.INI??), the disconnect timeout may be automatically set.

@Chead@<:#200,8486>Errors

<:#200,8486>None

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>Connect

@1st lev para@<:#200,8486>Disconnect

@1st lev para@<:#200,8486>IsConnected

@Bhead title@<:ZProps><:Z~Props>Exclusive Property

<:#400,8486>Sets a mode where a separate connection is made, rather than use an existing connection that has been cached. (??is this a correct way of saying this?)

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ConnectionObj. <-">Exclusive<-!>

<:#200,8486><+!><+">ConnectionObj. <-">Exclusive<-!> = status<+!><-">

@Chead@<:#200,8486>Return Values

<+">boolean<-"><:t4>

@Chead@<:#200,8486>Usage

<:#400,8486>Connections are usually cached to optimize connection time access. Exclusive mode must be set prior to connection; it cannot be set after a connection has been established.

@Chead@<:#200,8486>Errors

<:#200,8486>(??is there an error if you attempt to set Exclusive mode after connection?))

<:#200,8486><+!>See Also<-!>

@1st lev para@ConnectTo

@Bhead title@<:#220,8486>FetchBatchSize Property

<:#200,8486>Specifies the number of records that will be fetched at any one time.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer<-"> = <+"><+!>ResultSetObj<-!><-"><+!><+">.<-!><-"><+!> FetchBatchSize<-!>

<:#200,8486><+"><+!>ResultSetObj.<-!><-"> <+!>FetchBatchSize<-!> = <+">integer<-"><-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<+">Integer<-">. The number of records retrieved at a time. The default return value is zero (unlimited).

@Chead@<:#200,8486>Usage

<:#400,8486>You can use FetchBatchSize as a performance tuning parameter. Fetching multiple records is faster than individual single records.

@Chead@<:#200,8486>Errors

<:#200,8486>None

@Chead@<:#200,8486>See also:

NextRow

@Bhead title@<:#220,8486>HasRowChanged Property

<:#200,8486>Read-only. Indicates if values in the current row have changed.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ResultSetObj<-!><-"><+!>.HasRowChanged<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@Chead@<:t7>Errors

Not connected, No valid result set or data

@Bhead title@<:#220,8486>IsBeginOfData Property

<:#200,8486>Read-only. Indicates whether the cursor position is at the beginning of the result set.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

@1st lev para@<:#200,8486><+">status<-"> = <+"><+!>ResultSetObj.<-!><-"><+!> IsBeginOfData<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

<:t26>

@Bhead title@<:#220,8486>IsEndOfData Property

<:#200,8486>Read-only. Indicates whether the cursor position is at the end of the result set.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

@1st lev para@<:#200,8486><+">status<-"> = <+"><+!>ResultSetObj.<-!><-"><+!> IsEndOfData<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<+">boolean<-"><:t6>

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, No table or result set

@Chead@<:#200,8486>See also

IsResultSetAvailable

@Bhead title@<:#220,8486>IsAutoCommit Property

<:#200,8486>Reflects the auto-commit behavior of the object.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ResultSetObj.<-!><-"><+!> IsAutoCommit<-!>

<:#200,8486><+"><+!>ResultSetObj.<-!><-"> <+!>IsAutoCommit<-!> = <+">status<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@1st lev para@<:t15>

@Chead@<:#200,8486>Usage

<:#400,8486>When the back-end database is auto-commit, all changes are automatically and permanently changed. If the database is not auto-commit, the changes may be rolled back or committed at close.

If a database supports manual commit or rollback (transaction mode), you can set IsAutoCommit either way. If set True, the ResultSet object will commit each change. If the database is auto-commit, you cannot change it to manual. If you attempt to set IsAuto
Commit to False, it will stay True.

<:#200,8486>Options( DB_AUTOCOMMIT ) is identical to setting this property to true.

@Chead@<:#200,8486>See also

@1st lev para@Options( AutoCommit )

@Bhead title@<:#220,8486>IsConnected Property

<:#200,8486>Read-only. Indicates whether the physical connection is valid.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ConnectionObj.<-"><-!><+!> IsConnected<-!>

@Chead@<:#200,8486><-!>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@1st lev para@<:t16>

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>ConnectTo

@1st lev para@<:#200,8486>Disconnect

@1st lev para@<:#200,8486>DisconnectTimeOut

@1st lev para@IsTimedOut

@Bhead title@<:#220,8486>IsReadOnly  Property

<:#200,8486>Read-only. Tests and returns access status.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj.<-"><-!><+!> IsReadOnly<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@1st lev para@<:t17>

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

@Chead@<:#200,8486>See also

@1st lev para@IsResultSetAvailable

@1st lev para@IsSupported

@Bhead title@<:#220,8486>IsResultSetAvailable Property

<:#200,8486>Read-only. After a query, indicates if a result set exists in cache.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetOb<-"><-!><+!><+">j<-"><-!><+!><+">.<-!><-"><+!> IsResultSetAvailable<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@Bhead title@<:t18>

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

@Chead@<:#200,8486>See also

@1st lev para@Execute

@Bhead title@<:#220,8486>IsSupported  Property

<:#200,8486>Indicates whether an option is supported.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ConnectionObj.<-!><-"><+!> IsSupported<-!>( 
<+">option<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">option<-">

@1st lev para@<:#200,8486>Options that can be tested are:

@1st lev para@<:#200,8486>DB_ASYNCHRONOUS (??Only one that is currently supported?)

@1st lev para@<:#200,8486>(DB_PROCEDURES

@1st lev para@<:#200,8486>DB_CURSORS

@1st lev para@<:#200,8486>DB_READONLY?? Not supported yet?)

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@1st lev para@<:t19>

@Chead@<:#200,8486>See also

@1st lev para@Options

@1st lev para@IsReadOnly

@Bhead title@<:#220,8486>IsTimedOut  Property

<:#200,8486>Indicates whether a connection has timed out.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ConnectionObj.<-!><-"><+!> IsTimedOut<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@1st lev para@<:t20>

@Chead@<:#200,8486>Usage

<:#200,8486>The time out value, expressed in seconds, is set by DisconnectTimeOut.

@Chead@<:#200,8486>See also

@1st lev para@DisconnectTimeOut

@1st lev para@IsConnected

@Bhead title@<:#220,8486>Query Property

<:#200,8486>Use to relate a query object with a result set object.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+!>SET <+">ResultSetObj.<-">Query <-!>= <+"><+!>QueryObj<-!><-"><-">

@Chead@<:#200,8486><+!>Usage<-!>

You must associate the result set with a valid query object to execute the query. 

@Chead@Errors

<:#200,8486>

@Chead@See Also

Execute

@Bhead title@QueryExecuteTimeOut Property

Specifies a time out value in seconds for query execution.

@Chead@Defined In

Query

@Chead@Syntax

<+">integer value<-"> = <+!><+">QueryObj.<-">QueryExecuteTimeOut<-!><-">

<+!><+">QueryObj.<-">QueryExecuteTimeOut<-!><+!> = <+">integer<-"><-!>

@Chead@<+!>Usage<-!>

Use for optimization of result set retrieval, or to ensure timely results in a browsing application.

@Chead@Errors


@Chead@See Also

@1st lev para@IsResultSetAvailable

@Bhead title@SilentMode Property

<:#200,8486>Prevents a UserID and Password dialog box from being displayed during program execution.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ConnectionObj.<-"><-!><+"> <-"><+!>SilentMode<-!>

<:#200,8486><+!><+">ConnectionObj.<-"><-!><+"> <-"><+!>SilentMode<-!><+!> = <-!><+">status<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:t5>

@Chead@<:#200,8486>Usage

<:#600,8486>If SilentMode is set, and a UserID and Password are required, the connection is attempted, but may fail. SilentMode may not work for all drivers, but is supported for drivers that support SQLBrowseConnect (such as Oracle and Sybase drivers).

@Chead@<:#200,8486>Errors

<:#200,8486>(??Is there an error if the above instance occurs?)

@Chead@<:#200,8486>See Also

@1st lev para@<:#200,8486>ConnectTo

@Bhead title@<:#220,8486>SQL Property

<:#200,8486>Sets or retrieves an SQL statement.

@Chead@<:#200,8486>Defined In

<:#200,8486>Query

@Chead@<:#200,8486>Syntax

<:#200,8486><+"><+!>QueryObj.<-!><-"><+!> SQL<-!>=<+!> <-!><+">SQLStatement<-">

<:#200,8486><+">SQLStatement <-">=<+!> <-!><+"><+!>QueryObj.<-!><-"><+!> SQL<-!>

@Chead@<:#200,8486>Return Values

<:#200,8486><+">SQLStatement<-">

@Chead@<:#200,8486>Usage

<:#600,8486>When an SQL statement is stored, it is automatically checked for syntactical correctness. There is no practical limit to the (??size, length, type of?) SQL statement written, nor is the SQL statement limited to a query (select statement). The SQL statement 
is not executed until an Execute is performed.

<:#400,8486>SQL statement execution depends on a user's access rights. A user may not be authorized to alter certain fields or tables, perform certain operations, or access certain tables or columns.

@Chead@<:#200,8486>Errors

<:#200,8486>SQL statement invalid

@Chead@<:#200,8486>See also

@1st lev para@SetParameter

@1st lev para@Execute

@1st lev para@ListFields

@1st lev para@ListTables

@Bhead title@<:#220,8486>AddRow  Method

<:#200,8486>Adds data (row or result set)  to a table. 

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!>ResultSetObj.<-!><+!> AddRow<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@Chead@<:#200,8486>Usage

The row added contains no valid data for any column, but must be populated with data using SetValue. The row will not be updated until UpdateRow is executed. If the data source supports transaction model commit/rollback, changes must be followed by a Commit
 or Rollback. (??Question from QE: Does IsReadOnly apply here, or just at UpdateRow?)

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, No result set, No table created

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>SetValue

@1st lev para@<:#200,8486>Options( DB_AutoCommit )

@1st lev para@<:#200,8486>IsAutoCommit

@1st lev para@Transactions

@1st lev para@UpdateRow

@Bhead title@Close Method

Close a result set and commit or rollback changes. (??Is the result set no longer available?)

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!>ResultSetObj.<-!><+!> Close<-!> ( <+">CloseOption )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">CloseOption<-">

@1st lev para@DB_CLOSE. Closes without commit (no changes or updates). (??Same as rollback?)

@1st lev para@<:#200,8486>DB_COMMIT. Changes are committed.

@1st lev para@<:#200,8486>DB_ROLLBACK. Changes are rolled back.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@Chead@<:#200,8486>Usage

<:#600,8486>Some data sources are auto-commit, which means that any change will automatically be made to the database. These databases cannot be rolled back. to determine if a database is in auto-commit mode, use IsAutoCommit.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, No result set, No table created

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>IsAutoCommit

@1st lev para@Transactions

@Bhead title@<:#220,8486>ConnectTo Method

<:#200,8486>Connects to a data source.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ConnectionObj.<-!><-"><+!> ConnectTo <-!>( 
<+">DataSourceName <-"><[>,<+"> UserID<-">, <+">Password<-"> ] <[>,<+"> dsType, Path<-">] )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">DataSourceName<-">

@1st lev para@<:#200,8486><+">String.<-"> The name of the data source you want to connect to.

<:#200,8486><+">UserID

@1st lev para@<:#200,8486><+">String.<-"> Optional. The name of the user ID.

<:#200,8486><+">Password

@1st lev para@<:#200,8486><+">String.<-"> Optional. The password for the user ID.

<:#200,8486><+">dsType

@1st lev para@<:#200,8486><+">String. <-">The data source type, e.g., Sybase.

<:#200,8486><+">Path

@1st lev para@<:#200,8486><+">String. <-">The path information to locate the data source.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

<:t0>

@Chead@<:#200,8486>Example

@Mono@<:#400,8486>volunteers. ConnectTo ( "Volunteers", "NULL", "NULL", "Sybase", "\\server\foo\able" )

@Chead@<:#200,8486>Usage

<:#400,8486>Use to establish a connection to a data source, whether or not it is already registered. If already registered, the data source type and path are not required.

<:#600,8486>If not already registered, the data source will be autoregistered. The last parameter may contain multiple strings if they are necessary to complete the autoregistration of the data source as an ODBC data source type.

@Chead@<:#200,8486>Errors

<:#200,8486>Cannot register, Cannot connect, User ID rejected, Cannot reach path

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>Disconnect

@1st lev para@DisconnectTimeOut

@Bhead title@<:#220,8486>DeleteRow Method

<:#200,8486>Deletes the record represented by the current row in the specified table from the database.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj<-!><+!>.<-!><-"><+!> DeleteRow<-!> ( 
<+">TableName<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">TableName<-">

<:#200,8486><+">	String. <-">The name of the table from which you want to delete the record.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@Chead@<:#200,8486>Usage

<:#400,8486>If the database supports transaction processing, the deleted row must be committed or rolled back using either Close or Transactions. Delete may not be possible if the result or database is read-only.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, No current row

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>Close

@1st lev para@<:#200,8486>Transactions

@1st lev para@<:#200,8486>IsAutoCommit

@1st lev para@<:#200,8486>IsReadOnly

@1st lev para@IsSupported( DB_READONLY )

@1st lev para@Options( AutoCommit )

@Bhead title@<:#220,8486>Disconnect  Method

<:#200,8486>Disconnects from the data source.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ConnectionObj<-!><-"><+!><+">.<-!><-"><+!> Disconnect<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:t27>

@Chead@<:#200,8486>Usage

If the database has been updated using SetValue, UpdateRow, or DeleteRow, and the table has not been committed or rolled back as required, a TransactionUpdate event is generated. You must select commit or rollback. Alternatively, you can set the disconnect 
behavior in Options.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>ConnectTo

@1st lev para@<:#200,8486>DisconnectTimeOut

@1st lev para@<:#200,8486>IsConnected

@1st lev para@Events

@1st lev para@Options

@Bhead title@<:#220,8486>ExecProcedure Method

<:#200,8486>Executes a stored procedure.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ConnectionObj<-!><-"><+!><+">.<-!><-"><+!> ExecProdedure<-!>( 
<+">ProcedureName, arg1, arg2... )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">ProcedureName<-">

@1st lev para@<:#200,8486><+">String. <-">The name of the procedure you want to execute.

<:#200,8486><+">arg1, arg 2...<-">

@1st lev para@<+">String, integer, or real.<-"> Arguments that may be needed by the procedure. Argument data types must be consistent with the requirements of the procedure.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

<:t2>

@Chead@<:#200,8486>Examples

<:#200,8486>Stored procedures typically have names such as "AddEmployee," or "CreditReport."

@Chead@<:#200,8486>Usage

<:#400,8486>Not all data sources support or maintain stored procedures. Executing a stored procedure standardizes the process of maintaining data and data integrity at the back-end database level.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, ODBC Error

@Chead@<:#200,8486>See also

@1st lev para@ListProcedures

@Bhead title@<:#220,8486>Execute Method

<:#200,8486>Executes an SQL statement.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> =<+"> <+!>ResultSetObj.<-"><-!><+!> Execute<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@Chead@<:#200,8486>Usage

<:#600,8486>This method us used to execute a query, refresh a result set in a query, or any other valid SQL statement. NumColumns changes to reflect the actual columns in the result set. Rows is set to DB_ROWSUNKNOWN. NextRow accurately sets whether a result set contai
ns any valid rows.

<:#800,8486>You can execute the SQL statement in either synchronous or asynchronous modes. In synchronous mode, Execute waits until execution is complete before returning. In asynchronous mode, Execute returns as soon as possible while execution continues. This is most
 practical when accessing data residing in back-end systems.

@Chead@<:#200,8486>Errors

<:#200,8486>NotConnected, ODBC Error

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>SQL

@1st lev para@<:#200,8486>NumColumns

@1st lev para@<:#200,8486>NumRows

@1st lev para@<:#200,8486>NextRow

@1st lev para@<:#200,8486>FetchBatchSize

@1st lev para@<:#200,8486>Options( Asynchronous )

@Bhead title@FieldExpectedDataType Method

<:#200,8486>Given a column number, sets the expected data type for that column.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">dataType<-"> = <+!><+">ResultSetObj.<-"><-!><+!> FieldExpectedDataType<-!> (<+"> column_id<-">, 
<+">dataType<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id<-">

@1st lev para@<:#200,8486><+">Integer<-">. Indicates the column for which the data type will be converted to the new data type.

<:#200,8486><+">dataType<-">

@1st lev para@<:#200,8486><+">dataType.<-"> Indicates the data type to convert to.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">dataType<-">.

@1st lev para@<:#400,8486>DB_UNDEFINED, DB_CHAR, DB_SHORT, DB_LONG, DB_DOUBLE, DB_DATE, DB_TIME, DB_BINARY, DB_BOOL, DB_DATETIME

@Chead@<:#200,8486>Usage

<:#400,8486>Allows conversion from the actual data type for a column value in a result set to the data type expected by the application.

<:#600,8486>No specific data conversion routines are assigned when a field value is retrieved from the database. All field values are returned as they appear in the database. A real value will return as a real value, integers as integers, and strings as strings.

<:#600,8486>An application may have special field value requirements, for example, it may need field values returned as strings. Some data type conversions are not possible, for example, as returning names as real numbers.

<:#600,8486>To determine the database data type, use FieldNativeDataType to return the data type as stored in the database for this column. Use FieldSize to return the field size at the database. Use FieldInfo, which contains all known field information,  to return the
 field information as a Field object.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, Invalid column id

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>FieldNativeDataType

@1st lev para@FieldSize

@Bhead title@<:#220,8486>FieldID

<:#200,8486>Returns the field ID of a field as an integer value.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer<-"> = <+!><+">ResultSetObj.<-"><-!><+!> <-!><+!>FieldID<-!>( 
<+">column_Name<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_Name<-">

@1st lev para@<:#200,8486><+">String<-">. The name of the field in the result set.

@Chead@<:#200,8486>Return Values

@1st lev para@<:#200,8486><+">Integer<-">. 

@Chead@<:#200,8486>Usage

The field ID in the result set corresponds to the relative column number, that is, the first column has a field ID of 1, the second column's field ID is 2, etc.

<:#600,8486>The field ID is required only when you know the field's name, but not the column ID. If the result set is ever changed, a field's relative position, and consequently its ID, would change also. FieldID offers a way of always determining the field ID dynamica
lly.

@Chead@<:#200,8486>Examples

@Mono@<:#400,8486>ssn_id% = obj.FieldID( "SSN" )<**>text = GetValue( ssn_id% )

<:#200,8486>or

@Mono@<:#200,8486>text = GetValue( obj.FieldID( "SSN" ) )

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, No valid table or result

@Chead@<:#200,8486>See also

@1st lev para@GetValue

@1st lev para@FieldName

@1st lev para@NumColumns

@Bhead title@<:#220,8486>FieldInfo Method

<:#200,8486>Returns

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status <-">= <+!><+">ResultSetObj.<-"><-!><+!> <-!><+!>FieldInfo<-!>( 
<+">column_id <-">or<+"> column_Name <-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id

@1st lev para@<:#200,8486><+">Integer.

<:#200,8486><+">column_Name<-">

@1st lev para@<:#200,8486><+">String<-">. 

@Chead@<:#200,8486>Return Values

@1st lev para@<:#400,8486><+">Boolean<-">. Returns the field information as a Field object, which contains all of the known field information.

@Chead@<:#200,8486>Usage

<:#200,8486>Use to determine specifically which fields have changed and what their new values are.

@Chead@<:#200,8486>Examples

<:#200,8486>

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, Invalid column id

@Chead@<:#200,8486>See also

@1st lev para@??

@Bhead title@<:#220,8486>FieldName Method

<:#200,8486>Returns the field name for a specified column.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">fieldName<-"> = <+!><+">ResultSetObj.<-"><-!><+!> <-!><+!>FieldName<-!>( 
<+">column_id <-">)

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id<-">

@1st lev para@<:#200,8486><+">Integer<-">. The column ID of the field in the result set.

@Chead@<:#200,8486>Return Values

@1st lev para@<:#200,8486><+">String<-">. 

@Chead@<:#200,8486>Usage

<:#200,8486>

@Chead@<:#200,8486>Examples

@Mono@<:#200,8486>

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, Invalid column id

@Chead@<:#200,8486>See also

FieldID

@Bhead title@FieldNativeDataType Method

<:#200,8486>Given a specific column, returns the native data type for that column.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">formatValue<-"> = <+!><+">ResultSetObj.<-"><-!><+!> FieldNativeDataType<-!>( column_id or column_Name )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id<-">

@1st lev para@<:#200,8486><+">Integer<-">.

<:#200,8486><+">column_Name.<-">

@1st lev para@<:#200,8486><+">String.<-">

@Chead@<:#200,8486>Return Values

@1st lev para@<:#200,8486><+">formatValue.<-"> 

@Chead@<:t14>Usage

<:#400,8486>The native data type is the that of the field as stored in the database. The data type of the returned data value will always be the value set by the expected data type. Use FieldInfo to retrieve this value.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, Invalid column id or name

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>FieldExpectedDataType

@1st lev para@FieldInfo

@Bhead title@<:#220,8486>FieldSize Method

<:#200,8486>Returns the maximum size of data for a field.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">size<-"> = <+!><+">ResultSetObj.<-"><-!><+!> FieldSize<-!>( <+">column_id<-">  or column_Name)

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id<-">

@1st lev para@<:#200,8486><+">Integer.<-">

<:#200,8486><+">column_Name.<-">

@1st lev para@<:#200,8486><+">String.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Integer.<-">

@Chead@<:#200,8486>Usage

<:#200,8486>??

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

<:#200,8486>Invalid column id or name

@Chead@<:#200,8486>See also

@1st lev para@
@Bhead title@<:#220,8486>FirstRow  Method

<:#200,8486>Sets the current row to the first row in a result set. Equivalent to setting CurrentRow to 1.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj.<-"><-!><+!> FirstRow<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486>None

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Boolean<-">

@1st lev para@<:#200,8486>Returns True if successful; otherwise, returns False, indicating an error.

@Chead@<:#200,8486>Usage

<:#400,8486>You may not be able to set the row before the current row, unless you have enabled caching, or the driver supports cursor positioning.

<:#200,8486>If FirstRow fails, use GetError to examine the meaning.

@Chead@<:#200,8486>Errors

<:#200,8486>No valid query executed, Invalid row number, Not connected

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>NumRows

@1st lev para@<:#200,8486>CurrentRow

@1st lev para@<:#200,8486>LastRow

@1st lev para@<:#200,8486>NextRow

@1st lev para@<:#200,8486>PrevRow

@1st lev para@<:#200,8486>LocateRow

@1st lev para@<:#200,8486>Options

@1st lev para@GetError

@Bhead title@<:#220,8486>GetValue Method

<:#200,8486>Retrieves the value of the column referenced by <+">column_id<-">, and copies the results to the 
<+">Variable<-"> field.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">Value<-"> = <+!><+">ResultSetObj.<-"><-!><+!> GetValue<-!>( <+">column_id or column_Name, 
<-">Variable )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id<-">

@1st lev para@<:#200,8486><+">Integer<-">.

<:#200,8486><+">column_Name.<-">

@1st lev para@<:#200,8486><+">String<-">.

<:#200,8486><+">Variable<-">

@1st lev para@<:#200,8486>??Data type set by FieldExpectedDataType?

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Value.<-">

@Chead@<:#200,8486>Usage

<:#600,8486>The data type of the returned data is determined by the value set for this column by the FieldExpectedDataType property. For example, you can set the expected value to return a real value for an integer numeric field.

@Chead@<:#200,8486>Errors

<:#200,8486>No table or result, Column reference is invalid

@Chead@<:#200,8486>See also

@1st lev para@FieldID

@1st lev para@<:#200,8486>FieldExpectedDataType

@1st lev para@FieldNativeDatatype

@1st lev para@FieldName

@Bhead title@<:#220,8486>GetError Method

<:#200,8486>Returns an error code value.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection, Query, ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer value <-"> = <+"><+!>ConnectionObj<-!><-"><+!><+">.<-!><-"><+!> GetError<-!>

<:#200,8486><+">integer value <-"> = <+"><+!>QueryObj<-!><-"><+!><+">.<-!><-"><+!> GetError<-!>

<:#200,8486><+">integer value <-"> = <+"><+!>ResultSetObj<-!><-"><+!><+">.<-!><-"><+!> GetError<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Integer<-">. ??Does this map to the error status code table?

@Chead@<:#200,8486>Usage

<:#600,8486>Errors are produced by any of the methods or properties in any of the three objects. Error code values are grouped into three general categories: bad parameter errors, database errors, and errors indicating that the method or property is not supported by th
is database.

@Chead@<:#200,8486>Example

<:#200,8486>The following shows how to use GetError to locate and trap errors:

@Mono@<:#200,8486>(??NEED TO GET A NEW EXAMPLE showing new model)

@Mono@<:#2200,8486>SUB Initialize<**>	DIM dat AS NEW DataAccess<**>	DIM datasource AS String<**><**>	datasource = "Zzzzzz"			'assume this doesn't exist<**>	dat.ConnectTo(datasource)<**><**>IF dat.GetError <<<;> DBstsSUCCESS then<**>'...do error handling here<**><**>END SUB

@Chead@<:#200,8486>See Also

@1st lev para@<:#200,8486>GetErrorMessage

@1st lev para@GetExtendedErrorMessage

@Bhead title@<:#220,8486>GetErrorMessage Method

<:#200,8486>Returns the short error message text associated with any error value.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection, Query, ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">error message text<-"> = <+"><+!>ConnectionObj.<-!><-"><+!> GetErrorMessage<-!>( 
<+">errorvalue )<-">

<:#200,8486><+">error message text<-"> = <+"><+!>QueryObj.<-!><-"><+!> GetErrorMessage<-!>( 
<+">errorvalue )<-">

<:#200,8486><+">error message text<-"> = <+"><+!>ResultSetObj.<-!><-"><+!> GetErrorMessage<-!>( 
<+">errorvalue )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">errorvalue or <-"><+">error code keyword<-">

@1st lev para@<:#400,8486>Optional. The error code value returned by GetError, or by DB_LASTERROR to refer to the last error code. Error code keywords are the last four letters in the error code, as follows:

@1st lev para@<:#200,8486>DBstsSUCCESS	Not an error, SUCCESS (cannot be trapped by ON ERROR)

@1st lev para@<:#400,8486>DBstsFAIL		Failure not explained

@1st lev para@<:#400,8486>DBstsMEMF		Memory allocation failure

@1st lev para@<:#400,8486>DBstsNCON		Not connected

@1st lev para@<:#400,8486>DBstsCCON		Unable to connect

@1st lev para@<:#400,8486>DBstsNOEX		Could not execute

@1st lev para@<:#400,8486>DBstsINVR		Invalid row

@1st lev para@<:#400,8486>DBstsCARR		Cannot access requested row

@1st lev para@<:#400,8486>DBstsNODA		No data

@1st lev para@<:#400,8486>DBstsEOFD		End of data

@1st lev para@<:#400,8486>DBstsINVC		Fieldid out of range

@1st lev para@<:#400,8486>DBstsNCOL		No columns available

@1st lev para@<:#400,8486>DBstsUNIM		Unimplemented

@1st lev para@<:#400,8486>DBstsBADP		Bad parameter

@1st lev para@<:#400,8486>DBstsODBC		ODBC missing

@1st lev para@<:#400,8486>DBstsLIBM		Lib missing

@1st lev para@<:#400,8486>DBstsBADS		Bad saved query

@1st lev para@<:#400,8486>DBstsSNFD		String not found

@1st lev para@<:#400,8486>DBstsINTR		Buffer too small

@1st lev para@<:#400,8486>DBstsACCS		Access error

@1st lev para@<:#400,8486>DBstsTYPE		Bad data source type

@1st lev para@<:#400,8486>DBstsENTR		Entry missing

@1st lev para@<:#400,8486>DBstsDSTY		Load data source type error

@1st lev para@<:#400,8486>DBstsDRVN		Load driver name error

@1st lev para@<:#400,8486>DBstsFITY		Load file type error

@1st lev para@<:#400,8486>DBstsFILT		Load filter error

@1st lev para@<:#400,8486>DBstsINST		Load install type error

@1st lev para@<:#400,8486>DBstsNODR		No driver entry

@1st lev para@<:#400,8486>DBstsNAUT		Cannot autoregister type

@1st lev para@<:#400,8486>DBstsNOSV		No server entry

@1st lev para@<:#400,8486>DBstsNAPE		Notes API error

@1st lev para@<:#400,8486>DBstsSVRQ		Server required

@1st lev para@<:#400,8486>DBstsTMPL		Template error

@1st lev para@<:#400,8486>DBstsBROW		Browse error

@1st lev para@<:#400,8486>DBstsCANF		Cannot find data source

@1st lev para@<:#400,8486>DBstsCNVR		No conversion routine

@1st lev para@<:#400,8486>DBstsCNVD		Converson error in data

@1st lev para@<:#400,8486>DBstsODBC		ODBC error

@1st lev para@<:#400,8486>DBstsHSTMT		ODBC could not return an hStmt

@1st lev para@<:#400,8486>DBstsSQLP		SQL prepare failed

@1st lev para@<:#400,8486>DBstsINTE		String length exceeded

@1st lev para@<:#400,8486>DBstsUPDB		Bind failed - probably a conversion error

@1st lev para@<:#400,8486>DBstsNUNQ		More than one row

@1st lev para@<:#400,8486>DBstsRDON		Read only data

@1st lev para@<:#400,8486>DBstsRCHG		Row has changed - cannot be updated

@1st lev para@<:#400,8486>DBstsRUNC		Row unchanged

@1st lev para@<:#400,8486>DBstsCXIN		Could not execute an insert or update

@1st lev para@<:#400,8486>DBstsAHVR		Already have a valid addrow - must update first

@1st lev para@<:#400,8486>DBstsCPAR		Cannot position at addrow

@Chead@<:#200,8486>Return Values

<+">String. <-">

@Chead@Usage

<:#600,8486>Errors may be tested either immediately after a method or property is used, or by creating an error handler using ON ERROR, which has the advantage of allowing a central consistent manner of error handling, regardless of where the error occurs.

@Chead@<:#200,8486>Example

<:#200,8486>The following example shows how to use ON ERROR to trap errors:

@Mono@<:#200,8486>(??NEED TO GET A NEW EXAMPLE showing new model)

@Mono@SUB Initialize<**>	DIM dat AS NEW DataAccess<**>	DIM datasource AS String<**>	<**>	ON ERROR DBstsCCON Goto BadConnection<**>		<**>	datasource = "Zzzzzz"		'assume this doesn't exist<**>	dat.ConnectTo(datasource)<**><**>	IF dat.ConnectTo(datasource) THEN<**>	
	dat.SQL = "select * from students"<**>		dat.Execute<**>		Columns = dat.NumColumns<**><**>	ELSE<**>		PRINT "Could NOT connect to", datasource<**><**>	END IF<**><**>BadConnection:<**>	PRINT "Could NOT connect or lost connection to ", datasource<**><**>	dat.D
isconnect<**><**>END SUB

@Chead@<:#200,8486>See Also

@1st lev para@<:#200,8486>Get Error

@1st lev para@GetExtendedErrorMessage

@Bhead title@GetExtendedErrorMessage Method

<:#200,8486>Returns the long, descriptive error message text associated with any error code value.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection, Query, ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">error message text<-"> = <+"><+!>ConnectionObj.<-!><-"><+!> GetExtendedErrorMessage<-!>( 
<+">errorvalue )<-">

<:#200,8486><+">error message text<-"> = <+"><+!>QueryObj.<-!><-"><+!> GetExtendedErrorMessage<-!>( 
<+">errorvalue )<-">

<:#200,8486><+">error message text<-"> = <+"><+!>ResultSetObj.<-!><-"><+!> GetExtendedErrorMessage<-!>( 
<+">errorvalue )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">errorvalue<-"> or <+">error code keyword<-">

@1st lev para@<:#400,8486>Optional.<+"> <-">The error code value returned by GetError, or by DB_LASTERROR to refer to the last error code.

@Chead@<:#200,8486>Return Values

@1st lev para@<:#200,8486><+">String. <-">The error message text associated with the error value.

@Chead@<:#200,8486>See Also

@1st lev para@GetError

@1st lev para@GetErrorMessage

@Bhead title@<:#220,8486>GetParameter Method

<:#200,8486>Returns the last value set for the specified parameter.

@Chead@<:#200,8486>Defined In

ResultSet

@Chead@<:#200,8486>Syntax

<+">value<-"> = <+"><+!>ResultSetObj<-!><-"><+!><+">.<-!><-"><+!> GetParameter 
<-!>( <+">parameterName or parameter_index<-"><+"> )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">parameterName<-">

@1st lev para@<:#200,8486><+">String.<-">

<:#200,8486><+">parameter_index

@1st lev para@<:#200,8486><+">Integer.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">value<-">

@Chead@<:#200,8486>Usage

<:#400,8486>Parameters are used in SQL statements. Unlike ODBC and standard SQL, parameters may appear anywhere in the SQL statement. Use SetParameter to set the replacement value for the parameter.

@Chead@<:#200,8486>Examples

@Mono@<:#200,8486>dat.SQL = "SELECT * from STUDENTS WHERE ?field_sel? = ?value?"

@Mono@<:#200,8486>print dat.GetParameter ( parameter_index )

@Chead@<:#200,8486>Errors

<:#200,8486>This parameter not in SQL statement

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>SQL

@1st lev para@<:#200,8486>SetParameter

@1st lev para@GetParameterName

@Bhead title@<:#220,8486>GetParameterName Method

<:#200,8486>Retrieves a parameter name.

@Chead@<:#200,8486>Defined In

ResultSet

@Chead@<:#200,8486>Syntax

<+">Name = <+!>ResultSetObj.<-!><-"><+!> GetParameterName<-!>(  <+">parameter_index<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">parameter_index

@1st lev para@<:#200,8486><+">Integer.

@Chead@<:#200,8486><+">R<-">eturn Values

<:#200,8486><+">Name<-">

@Chead@<:#200,8486>Usage

<:#600,8486>Parameter names contained in SQL statements are retrieved using <+">parameter_index<-"> as an index. Each name is returned without its surrounding question marks. You can use the parameter names to prompt a user.

@Chead@<:#200,8486>Errors

<:#200,8486>Invalid parameter index

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>GetParameter

@1st lev para@SetParameter

@Bhead title@<:#220,8486>GetRegistrationInfo Method

Returns text in the registration file as text.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">text <-"> = <+"><+!>ConnectionObj<-!><-"><+!><+">.<-!><-"><+!> GetRegistrationInfo<-!>( 
<+">DataSourceName <-">)

@Chead@<:#200,8486>Parameters

<:#200,8486><+">DataSourceName<-">

@1st lev para@<:#200,8486><+">String.<-"> The name of the data source for which you want registration information.

@Chead@<:#200,8486>Return Values

<:#400,8486><+">Text. <-">The text in the registration file for the specified data source. Returns empty if there is no registration information for the data source. 

@Chead@<:#200,8486>Usage

<:#200,8486>Use to find registration information for the named data source.

@Chead@<:#200,8486>Errors

Data Source Not Found

@Chead@See also

@1st lev para@ListDataSources

@1st lev para@ConnectTo

@Bhead title@<:#220,8486>LastRow Method

<:#200,8486>Sets the current row position to the last row in the result set.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj.<-"><-!><+!> LastRow<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:t1>

@Chead@<:#200,8486>Usage

<:#400,8486>To reach the last record, records must be retrieved from the result set, therefore, locating the last row may take some time.

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>NumRows

@1st lev para@<:#200,8486>CurrentRow

@1st lev para@<:#200,8486>FirstRow

@1st lev para@<:#200,8486>NextRow

@1st lev para@<:#200,8486>PrevRow

@1st lev para@<:#200,8486>LocateRow

@1st lev para@<:#200,8486>Options

@1st lev para@GetError

@Bhead title@<:#220,8486>ListDataSources Method

<:#200,8486>Lists all registered data sources as an array, after the connection is established.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">Array<-"> = <+"><+!>ConnectionObj.<-!><-"><+!> ListDataSources<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Array<-">

@1st lev para@<:#200,8486>Returns an array whose entries are strings (all registered data sources).

@Chead@<:#200,8486>Errors

<:#200,8486>??

@Chead@<:#200,8486>See also

@1st lev para@DataSourceName

@1st lev para@GetRegistrationInfo

@1st lev para@ConnectTo

@Bhead title@<:#220,8486>ListFields Method

<:#200,8486>Lists a name that corresponds to the name of a field in the referenced table.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">Array <-">= <+"><+!>ConnectionObj.<-!><-"><+!> ListFields<-!>( 
<+">TableName <-">)

@Chead@<:#200,8486>Parameters

<:#200,8486><+">TableName<-">

@Chead@<:#200,8486>Return Values

<+">Array<-">

@1st lev para@<:#600,8486>Returns an array of names. Each name corresponds to the name of a field in the referenced table. If 
<+">TableName<-"> is blank, the names of the columns in the current project list, if any, are returned. The entries are in their project list order.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, Invalid Table Name

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>ListTable

@1st lev para@ListDataSources

@1st lev para@FieldName

@Bhead title@<:#220,8486>ListProcedures Method

<:#200,8486>Lists the executable procedures at the connected data source.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">Array<-"> = <+"><+!>ConnectionObj.<-!><-"><+!> ListProcedures<-!> ( 
<+">DataSourceName, UserID, Password )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">DataSourceName<-">

@1st lev para@<:#200,8486><+">String. <-">Optional.

<:#200,8486><+">UserID<-">

@1st lev para@<:#200,8486><+">String. <-">Optional.

<:#200,8486><+">Password<-">

@1st lev para@<:#200,8486><+">String. <-">Optional.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Array<-">

@1st lev para@<:#200,8486>Returns an array of names. Each name is an executable procedure at the connected data source.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

@Chead@<:#200,8486>See also

@1st lev para@ExecProcedure

@Bhead title@<:#220,8486>ListTables Method

<:#200,8486>Lists the available tables in a connected data source.

@Chead@<:#200,8486>Defined In

<:#200,8486>Connection

@Chead@<:#200,8486>Syntax

<:#200,8486><+">ArrayName<-"> = <+"><+!>ConnectionObj<-!><-"><+!><+">.<-!><-"><+!> ListTables<-!> ( 
<+">DataSourceName<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">ArrayName<-">

@1st lev para@<:#200,8486>Returns an array of names that are the available tables in a data source.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

@Chead@<:#200,8486>See also

@1st lev para@ListFields

@Bhead title@<:#220,8486>LocateRow Method

<:#200,8486>Indentifies records that match a specified field value.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<+">status<-"> = <+!><+">ResultSetObj<-">.<-!><+!> LocateRow<-!>( 
<+">column_id <-">or <+">column_Name, value, <-"> <+"><[>column_id2 
<-">or<+"> column_Name2, value2<-"><+">, <-"> <+"><[>column_id3 <-">or 
<+">column_Name3, value3] ]<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id

@1st lev para@<:#200,8486><+">Integer. <-">

<:#200,8486><+">column_Name

@1st lev para@<:#200,8486><+">String.

<:#200,8486><+">value<-">

@1st lev para@<:#200,8486>String.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:#200,8486>Returns true if matching records are found; otherwise returns false, indicating an error.

@Chead@<:#200,8486>Usage

<:#600,8486>Specify either the column ID or the column name, and the value you want to match, up to three pair of the two parameters. You can specify a match on up to three columns at once; however, the second and third columns are optional.

<:#600,8486>This method searches through the result set for a value in a column beginning at the current row. The search is case and accent independent. You cannot perform advanced conditional searches with expressions. Use GetError to examine errors.

@Chead@<:#200,8486>Errors

<:#200,8486>No valid query executed, Not connected, Invalid Row number

@Chead@<:#200,8486>See also

@1st lev para@NumRows

@1st lev para@CurrentRow

@1st lev para@FirstRow

@1st lev para@LastRow

@1st lev para@NextRow

@1st lev para@PrevRow

@1st lev para@Options

@1st lev para@GetError

@Bhead title@<:#220,8486>NextResultSet

<:#400,8486>If multiple result sets are retrieved, releases the current result set and makes the next result set available.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ResultSetObj.<-"> NextResultSet<-!>

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:#400,8486>Returns true if the next result set is now available, otherwise, returns false, as when there are no more result sets.

@Chead@<:#200,8486>Usage

<:#200,8486>Use NumResults to determine if additional result sets are available.

@Chead@<:#200,8486>Errors

<:#200,8486>No valid table or result set

@Chead@<:#200,8486>See Also

@1st lev para@NumResultSets

@Bhead title@<:#220,8486>NextRow Method

<:#200,8486>Sets the current row position to the next row in a result set.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj.<-"><-!><+!> NextRow<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:#400,8486>Returns true if the next row in the result set is successfully retrieved; otherwise returns false, indicating an error.

@Chead@<:#200,8486>Usage

<:#400,8486>Use to read through a result set.An error is generated if there is no result set, or the last record in a result set is reached. Use GetError to examine errors.

@Chead@<:#200,8486>Example

@Mono@<:#600,8486>WHILE customers. NextRow<**>	FORALL columns% in customers<**>			customers. GetValue (columns%, ...)	'data must go somewhere

@Mono@<:#400,8486><**>												'yet to be defined by other

@Mono@<:#600,8486>												'objects<**>	END FORALL<**>WEND

@Chead@<:#200,8486>Errors

<:#200,8486>No valid query executed, Invalid Row number, Not connected

@Chead@<:#200,8486>See also

@1st lev para@NumRows

@1st lev para@CurrentRow

@1st lev para@FirstRow

@1st lev para@LastRow

@1st lev para@NextRow

@1st lev para@PrevRow

@1st lev para@LocateRow

@1st lev para@Options

@1st lev para@GetError

@1st lev para@IsEndOfData

@Bhead title@<:#220,8486>NumColumns Method

<:#200,8486>Returns the number of columns in a result set or in a created or selected table.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer<-"> = <+!><+">ResultSetObj.<-"><-!><+!> NumColumns<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">integer<-">

@1st lev para@<:#200,8486>Returns the number of columns, or zero if there is no valid table or result set.

@Chead@<:#200,8486>Errors

<:#200,8486>None

@Chead@<:#200,8486>See also

@1st lev para@IsResultSetAvailable

@1st lev para@FieldID

@Bhead title@<:#220,8486>NumParameters Method

<:#200,8486>Returns the number of parameters in a SQL statement.

@Chead@<:#200,8486>Defined In

ResultSet

@Chead@<:#200,8486>Syntax

<+">integer<-"> = <+"><+!>ResultSetObj.<-!><-"><+!> NumParameters<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">integer<-">

@1st lev para@<:#200,8486>Returns the number of columns, or zero if there are no parameters in the last SQL statement.

@Chead@<:#200,8486>Errors

<:#200,8486>None

@Chead@<:#200,8486>See also

IsResultSetAvailable

@Bhead title@<:#220,8486>NumResultSets

<:#200,8486>Returns the number of result sets if multiple result sets are retrieved.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer<-"> = <+"><+!>ResultSetObj.<-"> NumResultSets<-!>

@Chead@<:#200,8486>Return Values

<:#200,8486><+">integer<-">

@1st lev para@<:#200,8486>Returns the number of result sets, even if they contain zero rows.

@Chead@<:#200,8486>Errors

<:#200,8486>No valid table or result set

@Chead@<:#200,8486>See Also

@1st lev para@<:#200,8486>NextResultSet

@Bhead title@<:#220,8486>NumRows Method

Returns the number of rows in a result set.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">integer<-"> = <+!><+">ResultSetObj.<-"><-!><+!> NumRows<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">Integer<-">

@1st lev para@Returns one of these values:<:Zx><:Z~x><:t3>

@Chead@<:#200,8486>Usage

<:#1000,8486>You cannot determine the number of rows immediately after a query or while fetching records, only when the entire result set has been fetched. However, you can determine immediately whether the result contains any result rows at all, meaning a valid query c
an return zero rows. The actual row count may also have been artificially limited, causing the value of DB_ROWSLIMITED to be returned. (??you mean by setting the CacheLimit property?)

@Chead@<:#200,8486>Errors

<:#200,8486>No valid query executed, Not connected

@Chead@<:#200,8486>See also

@1st lev para@<:#200,8486>(??CacheLimit?)

@1st lev para@<:#200,8486>CurrentRow

@1st lev para@<:#200,8486>FirstRow

@1st lev para@<:#200,8486>LastRow

@1st lev para@<:#200,8486>NextRow

@1st lev para@<:#200,8486>PrevRow

@1st lev para@<:#200,8486>LocateRow

@Bhead title@<:#220,8486>Options Method

<:#200,8486>Selects or modifies the behavior of the object. (??check the format of this method)

@Note@<:#200,8486>Options marked with an asterisk are the object's default behavior.

@Chead@Defined In

ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj.<-"><-!> <+!>Options<-!>( <+">option<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">options<-">

@1st lev para@<:#200,8486>DB_ASYNCHRONOUS

@1st lev para@<:#600,8486>Places the object in asynchronous mode. When ODBC performs a query or update, the operation is performed asynchronously at the back-end. This releases the object to perform other functions and speeds performance. Not all databases or drivers support this ca
pability.

@1st lev para@<:#400,8486>In NT, Windows95, OS/2 and some Unix platforms, a query may be executed as a separate thread when in asynchronous mode.

@1st lev para@<:#200,8486>*DB_SYNCHRONOUS

@1st lev para@<:#200,8486>Restores the object's mode to synchronous.

@1st lev para@<:#200,8486>DB_CACHEENTIRE

@1st lev para@<:#400,8486>Caches the entire result set in memory. A record is cached when it is first retrieved from the database. 

@1st lev para@<:#600,8486>This option allows bi-directional scrolling through the result set even for drivers that do not support this capability. Performance is enhanced when records are cached because it is faster to retrieve records from memory than from the database. Also, cache
d records may be retrieved in any order.

@1st lev para@<:#800,8486>Cacheing records may require substantial memory allocation, especially when a cached record is very large. If there are too many cached records in memory, the least referenced records are stored in a temporary swap file, adding to the overhead of cacheing. 
In many cases, retrieving records from memory may still be faster than retrieving them from a database.

@1st lev para@<:#200,8486>DB_CACHELIMIT

@1st lev para@<:#600,8486>Caches a limited number of records. Only the number of records specified by the limit are available from the cache. The rest, if available, can be accessed from the database. Full bi-directional retrieval is supported if the dabase supports a bi-directional
 cursor.

@1st lev para@<:#200,8486>*DB_CACHENONE

@1st lev para@<:#400,8486>No records are cached. Use when a result set will only be forward-processed, a record at a time, as when a record is copied to a display object or searched.

@1st lev para@<:#200,8486>DB_AUTOCOMMIT

@1st lev para@<:#200,8486>Sets the database update and delete transactions to autocommit mode.

@1st lev para@<:#200,8486>DB_ OVERRIDE

@1st lev para@<:#600,8486>Used only in response to an Update to force the updated changes. You can issue a subsequent update for the same row once the override option has been set. Override requires cursor support from the database.

@Chead@<:#200,8486>Errors

Asynch mode not supported (for the DB_ASYNCHRONOUS Option).

@Chead@See also

@1st lev para@CacheLimit

@1st lev para@IsAutoCommit

@1st lev para@IsSupported

@1st lev para@AddRow

@1st lev para@Close

@1st lev para@DeleteRow

@1st lev para@Disconnect

@1st lev para@Execute

@Bhead title@<:#220,8486>PrevRow Method

<:#200,8486>Positions the current row pointer at the previous row.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+"><+!>ResultSetObj.<-!><-"><+!> PrevRow<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:#400,8486>Returns true if the pointer is successfully set to the previous row; otherwise returns false, indicating an error (e.g., previous row is not accessible).

@Chead@<:#200,8486>Usage

<:#600,8486>The previous row is not accessible when the pointer is already at the first row, there is no valid table to scroll through, a result set is not cached, or the cache is limited and the ODBC driver does not support cursor or result navigation.

@Chead@<:#200,8486>Errors

<:#200,8486>No valid table or result set, Cannot locate previous row

@Chead@<:#200,8486>See also

HasRowChanged

IsBeginOfData

CurrentRow

Options

@Bhead title@<:#220,8486>RefreshRow Method

<:#200,8486>Refresh the data cached at the row pointed to by the current row pointer.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj.<-"><-!><+!> RefreshRow<-!>

@Chead@<:#200,8486>Parameters

<:#200,8486><+">None<-">

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:#200,8486>Returns true if the row data was changed during refresh; otherwise returns false.

@Chead@<:#200,8486>Usage

<:#600,8486>Use HasRowChanged before RefreshRow to determine whether any changes have occurred, and if so, to copy them from memory to the current row. RefreshRow must not be executed more than ten seconds later than HasRowChanged. (??or what?)

@Chead@<:#200,8486>Errors

<:#200,8486>No valid table or result set

@Chead@<:#200,8486>See also

@1st lev para@HasRowChanged

@Bhead title@SetValue Method

<:#200,8486>Sets a new value to a column

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status<-"> = <+!><+">ResultSetObj.<-"><-!><+!> SetValue<-!>( <+">column_id 
<-">or<+"> column_Name, value<-"> )

@Chead@<:#200,8486>Parameters

<:#200,8486><+">column_id<-">

@1st lev para@<:#200,8486><+">Integer.

<:#200,8486><+">column_Name

@1st lev para@<:#200,8486><+">String.

<:#200,8486><+">value

@1st lev para@<:#200,8486><+">String.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:t11>

@Chead@<:#200,8486>Usage

<:#200,8486>The data is automatically converted to the required native data type.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected

@Chead@<:#200,8486>See also

@1st lev para@GetValue

@1st lev para@UpdateRow

@1st lev para@IsReadOnly

@1st lev para@FieldID

@1st lev para@FieldName

@Bhead title@<:#220,8486>SetParameter Method

<:#200,8486>Sets the replacement value for the specified parameter.

@Chead@<:#200,8486>Defined In

ResultSet

@Chead@<:#200,8486>Syntax

<+">status<-"> = <+"><+!>ResultSetObj<-!><-"><+!><+">.<-!><-"><+!> SetParameter 
<-!>( <+">parameter_name or Ordinal, Value<-"><+"> )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">parameter_name<-">

@1st lev para@<:#200,8486><+">String.<-">

<:#200,8486><+">Ordinal

@1st lev para@<:#200,8486><+">Integer.

<:#200,8486><+">Value

@1st lev para@<:#200,8486><+">String.

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:t10>

@Chead@<:#200,8486>Usage

<:#600,8486>Parameters are set in SQL statements. Unlike ODBC and standard SQL, parameters may appear anywhere in the SQL statement. In SQL, a parameter reference is a name surrounded by question marks.

@Chead@<:#200,8486>Examples

<:#200,8486>This example shows that the parameter's name is ?break? or break:

@Mono@<:#200,8486>SELECT * from table name where amount <;> ?break?

<:#200,8486>??getting a better example

@Chead@<:#200,8486>Errors

This parameter not in SQL statement

@Chead@<:#200,8486>See also

@1st lev para@SQL, GetParameter, GetParameterName

@Bhead title@<:#220,8486>Transactions Method

<:#200,8486>Commits or rolls back changes in a transaction model.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status <-">=<+!> <-!><+!><+">ResultSetObj.<-"><-!><+!> Transactions<-!>( 
<+">Options )<-">

@Chead@<:#200,8486>Parameters

<:#200,8486><+">Options<-">

<:t9>

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

<:t25>

@Chead@<:#200,8486>Usage

<:#600,8486>The result set is not affected by the transaction method. Some data sources are auto-commit, which means that any change will automatically be made to the database. These databases cannot be rolled back. Use IsAutoCommit to determine if a database is in aut
o-commit mode.

<:#400,8486>Use Close to clear a result set. As a convenience, use DB_COMMIT or DB_ROLLBACK as parameters in Close.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, No Result Set

@Chead@<:#200,8486>See also

<:#200,8486>IsAutoCommit

Close

@Bhead title@<:#220,8486>UpdateRow Method

<:#200,8486>Updates the current row, if changed, to the database.

@Chead@<:#200,8486>Defined In

<:#200,8486>ResultSet

@Chead@<:#200,8486>Syntax

<:#200,8486><+">status <-">=<+!> <-!><+!><+">ResultSetObj.<-"><-!><+!> UpdateRow<-!>

@Chead@<:#200,8486>Return Values

<:#200,8486><+">boolean<-">

@1st lev para@<:t8>

@Chead@<:#200,8486>Usage

<:#800,8486>A row may be logged to a transaction file when updated. The row may not be updated to the database until committed (that is, it is not autocommit). Use IsAutoCommit to retrieve the current commit status of the database. Use IsReadOnly to determine if the da
tabase is read-only, in which case it cannot be updated.

@Chead@<:#200,8486>Errors

<:#200,8486>Not connected, No current row

@Chead@<:#200,8486>See also

<:#200,8486>Close

<:#200,8486>IsAutoCommit

<:#200,8486>IsReadOnly

<:#200,8486>Options( DB_AutoCommit )

IsSupported( DB_ReadOnly )

<:#200,8486>

@Bhead title@<:#220,8486>

>

[Embedded]
00109742
