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?