What is Datapool Commands

Interview Questions

Rational Robot FAQ

What is Datapool Commands

In order to use the datapool functionality you must add the sqautil.sbh header file to all your scripts that will utilize the datapool.
SQADatapoolFetch - is used to retrieve an entire row (record) of values from the datapool. Call SQADatapoolFetch(dp)
SQADatapoolValue - is used to retrieve an individual value from the fetched datapool row and assign it to a script value.
Call SQADatapoolValue(dp, 4, ccNum)
dp = datapool name
4 = the column in datapool
ccNum = the column name in the datapool
SQADatapoolOpen - is used to open a specific datapool.
dp=SQADatapoolOpen("name of datapool")
SQADatapoolClose - is used to close a specific datapool.
Call SQADatapoolClose(dp)

Example of a GUI Script that used datapools:
‘$Include "sqautil.sbh"

Sub Main
	Dim Results as Integer
	Dim x as Integer	
	‘reference the datapool
	Dim dp as Long	
	‘variable to be assigned data from the datapool
Dim ccNum as String
	
	‘Open the datapool
	dp=SQADatapoolOpen("name of datapool")

	‘now this code will populate a full record from the datapool 10 times.
	For x = 0 to 9
	Call SQADatapoolFetch(dp)
	‘Begin
	Window SetContext, "Caption=Main Window; Class=Window", ""
	PushButton Click, "Text=Order"
	Window SetContext, "Caption=Order Window; Class=Window’, ""

	‘add the value to the order window
	Window SetContext, "Caption=Order Window; Class=Window’, ""
	EditBox Click, "ObjectIndex=3", "Coords=13,14"
	Call SQADatapoolValue(dp, 4, ccNum)
	InputKeys ccNum

	Window SetContext, "Caption=Order Window; Class=Window’, ""
	PushButton Click, "Text=OK"

Next x
	Call SQADatapoolClose(dp)
End Sub

(Continued on next question...)