AnsweredAssumed Answered

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

Question asked by dlewis@taylor.n-lanark.sch.uk on Jul 4, 2017
Latest reply on Jul 6, 2017 by mattel

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?

Outcomes