6 Replies Latest reply on Oct 4, 2016 7:12 AM by geo63

    Execsql not reading parameter with dash

    geo63

      I have an ExecuteSQL statement to read the account table by the email address and pickup a field value.  I use the email address as the account username.

       

      ExecuteSQL ( "select f_CheckFieldStatus from account where UserAccountName = ?" ; "" ; "" ; "john.smith@my-domain.com )

       

      This statement seems to have a problem with the '-' character in the domain name.  Has anyone ever encountered this problem and can offer a solution?

       

      The Find method works fine as long as I put "==" & john.smith@my-domain.com in the search field.