AnsweredAssumed Answered

ExecuteSQL only returning numbers for a SELECT on field with UUID

Question asked by AJEzk on Aug 2, 2016
Latest reply on Aug 4, 2016 by 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 ------------

Outcomes