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?

    dlewis@taylor.n-lanark.sch.uk

      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?