You need to specify field and record separators instead of using "" for each.
Can you explain exactly what you mean by "take out each value"? I can think of several different things that you might mean by that. It may help to explain what you want to do with the results of this query.
I mean: How can I query many field just by one query? And after that, how can I take each value of results to calculate?
In details, with above query, I need 3 value: Description, List Price and EUQ. After that, how can I take Description to assign to a variable, List Price to assign to another variable, ect...
Please help me PhilModJunk!
If a calculation field named cQuery is defined as:
$query = "SELECT Description, Price, EUQ
WHERE CatalogNumber LIKE ?"
; $result = ExecuteSQL($query; ¶ ; ""; fkCatalognumber)
Then Set Variable [$Description ; value: GetValue ( cQuery ; 1 ) ]
will assign the value of Description from your query to the variable named $Description.
You're great PhilModJunk!
Thank you very much