4 Replies Latest reply on Aug 4, 2016 10:06 AM by AJEzk

    ExecuteSQL only returning numbers for a SELECT on field with UUID

    AJEzk

      The following executesql statement is only returning the numbers from the UUID field instead of the full hexadecimal text .  What am I missing?

       

      The UUID field has storage set to text.

       

       

      // ------------  DEFINE LET VARIABLES------------
      Let (

       

      AccountName = Lower ( Get ( AccountName ) );

       

      // ------------  BEGIN EXECUTESQL BLOCK ------------

       

      Let ( [

       

      ReturnSub = "\n" ;
      SQLResult = ExecuteSQL (

       

      // ------------  BEGIN QUERY ------------

       

      "SELECT a.\"__kP_UserID\"
      FROM \"User\" a
      WHERE LOWER( a.\"FilemakerUserName\") = ?" ;

       

      // ------------  END QUERY ------ ------

       

      // ------------  BEGIN FIELD AND ROW SEPARATORS ------------

       

      "    " ; "|*|" ;

       

      // ------------  END FIELD AND ROW SEPARATORS ------------

       

      // ------------  BEGIN ARGUMENTS ------------

       

      AccountName

       

      // ------------  END ARGUMENTS ------------

       

      ) ] ;

       

      // ------------  BEGIN CARRIAGE RETURN SUBSTITUTIONS ------------

       

      Substitute ( SQLResult ; [ ¶ ; ReturnSub ] ; [ "|*|" ; ¶ ]  )

       

      // ------------  END CARRIAGE RETURN SUBSTITUTIONS ------------

       

      )

       

      // ------------  END EXECUTESQL BLOCK ------------

       

      )

       

      // ------------  END LET FUNCTION ------------