4 Replies Latest reply on Oct 1, 2014 10:51 AM by gregdc

    Returning and using multiple fields from an ExecuteSQL statement

    gregdc

      Title

      Returning and using multiple fields from an ExecuteSQL statement

      Post

      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.

      thanks

      Greg