9 Replies Latest reply on Jul 6, 2017 5:48 PM by mattel

    How do I get FMPro 16 Advanced to perform an INSERT SQL command on a locally hosted database?


      I've recently started using FMPRO 16 advanced.

      I've got the ODBC data source set up - I think.

      ODBC/JDBC is enabled. Filesharing is on.

      My calculated SQL script is:-


      ExecuteSQL ( "


      INSERT into filename (Forename, Surname)

      VALUES ('David', 'Lewis') ;




      I'm getting back the ? error message.


      Any thoughts?