resultSet

Contents

preset the result from SQL Statement or BSL Statement

jbsqlconstruct

let resultObject=SQLStatement.execute(
{select "FrgnName","ItemName" from "OITM" where "ItemCode"=:a;}
);
alert(resultObject.FrgnName[1]+" "+resultObject.ItemName[1]);

Properties

Property	R	W	Description
length	x		Return count of result rows

Methods

Property	Description
setrow(n)	set the current default row
getrow()	return current row as number
rowcount()	return count of result rows
next()	New Linkgo to next row . return true=ok, false=not ok
previews()	go to previews row. return true=ok, false=not ok
deleteRow(n)	delete row x
insertRow()	insert new row at end
isFirst()	return true, if current row is first row
isLast()	return true, if current row is last row
relative(n)	go to pos relative from current row. Positive and negetive number allowed.
copyTo(dw_x)	copy data from resultSet to datawindow object
copyFrom	copy (replace) data from datawindow object to result set
save()	Save resultSet to file with same name as you loaded it with dataObject
find(s[,n,n]	search for the string argument. Optional with start and end row
sort(s)	sort by string argument
filter(s)	filter by string argument
reset()	Reset the result, but not the structure
update()	Write result back to database, if update table defined
toJSONString()	Convert to JSON formatted string
toXMLString()	Convert to XML formatted string
toObject	Convert to Array/Object
rowsCopy	Copy one resultSet to another resultSet

Properties

Property

Description

length

Return count of entries

dataobject