Returning and using multiple fields from an ExecuteSQL statement
I want to use an ExecuteSQL statement like:
Set Variable[ $Return; GetAsText ( Let ( [$query = "Select FirstName, LastName, CountryOfOrigin from People where Person_Id = ?"; $result = ExecuteSQL($query;",";"";$PersonID)] ; $result))]
But how do I separate the values returned in $Return? Is it worth the execution time to do one query and then the steps to separate the results as opposed to three queries? BTW PersonID is indexed.