AnsweredAssumed Answered

Use SQL to insert empty record into FileMaker?

Question asked by jbarnum on Aug 30, 2018
Latest reply on Aug 30, 2018 by jbarnum

Using xDBC or the plug-in API, does anybody know how to insert a record into FileMaker without specifying any fields?

 

This query is valid in MySQL:

INSERT INTO Sandbox_TO() VALUES()

 

But it fails in FileMaker with this error: [FileMaker][FileMaker JDBC] FQL0001/(1:24): There is an error in the syntax of the query.

 

Any ideas on how to phrase this?

Outcomes