AnsweredAssumed Answered

FQL0001/(2:10) Error meaning?

Question asked by dlewis@taylor.n-lanark.sch.uk on Aug 17, 2017
Latest reply on Aug 17, 2017 by planteg

Hello,

 

I'm using FMPro 16 on a Mac.

Mac OS 10.12.5

 

I've written the following simple INSERT script which worked previously and is now giving the above error message.

 

INSERT into basictest (Forename, Surname)

VALUES (‘David’, ‘Lewis’)

 

I'm using the ODBC Manager.app plugin

 

It's a locally hosted file.

 

ODBC/JDBC sharing is on for all users

 

I'm doing this in the SQL text, not the Calculated SQL text using Execute SQL.

 

Screen Shot 2017-08-17 at 12.24.06.png

 

Any advice on how to get this error corrected or am I going about the INSERT all wrong?

 

Cheers

 

David

Outcomes