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 = ?" ; "" ; "" ; "firstname.lastname@example.org )
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 "==" & email@example.com in the search field.