Title
Process results of ExecuteSQL
Post
For example, I have a query:
Let ([
$query = "SELECT Description, Price, EUQ
FROM PriceBook
WHERE CatalogNumber LIKE ?"
; $result = ExecuteSQL($query; ""; ""; fkCatalognumber)
];
.....
$result
)
So, how can I take out each value from the result of this query?
Please help me! Thanks
If a calculation field named cQuery is defined as:
Let ([
$query = "SELECT Description, Price, EUQ
FROM PriceBook
WHERE CatalogNumber LIKE ?"
; $result = ExecuteSQL($query; ¶ ; ""; fkCatalognumber)
];
.....
$result
)
Then Set Variable [$Description ; value: GetValue ( cQuery ; 1 ) ]
will assign the value of Description from your query to the variable named $Description.