preset the result from SQL Statement or BSL Statement
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) |
|
getrow() |
|
rowcount() |
|
next() |
|
previews() |
|
deleteRow(n) |
|
insertRow() |
|
isFirst() |
|
isLast() |
|
relative(n) |
go to pos relative from current row. Positive and negetive number allowed. |
copyTo(dw_x) |
|
copyFrom |
|
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) |
|
filter(s) |
|
reset() |
|
update() |
|
toJSONString() |
|
toXMLString() |
|
toObject |
|
rowsCopy |
Properties
Property |
R |
W |
Description |
---|---|---|---|
length |
x |
|
Return count of entries |
dataobject |
x |
x |