2 Replies Latest reply on Dec 5, 2016 3:27 PM by rivet

    BaseElement plugin : insert escape single quote

    rivet

      I am trying to use the BaseElements function 'BE_FileMakerSQL' to insert a record but it doesn't seem to like an escaped single quote. Has anyone come across/solved this?

       

      pass:

      BE_FileMakerSQL ( "INSERT INTO thetable ( thefield ) VALUES ( 'Test' )" )

       

      fail:

      BE_FileMakerSQL ( "INSERT INTO thetable ( thefield ) VALUES ( 'Test\'s' )" )