Okay, so, we bought the Advanced version of the plugin for a number of reasons but not least was the SQL feature. Problem is, the thing isn't really working all that well.

I tried messing with the demo file and then, when that didn't work, I made a one table, one field test file with a table called 'test' and a field called 'field'.

When I tried to execute the following statement, I got Error 8310:

INSERT INTO test field VALUES ("test")

So, I pared it down to 

INSERT INTO test

That still didn't work. What am I missing here?

You need to specify the table occurrence to insert into, such as

INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)

I should add I keep this site bookmarked for refence

http://www.w3schools.com/sql/default.asp

Tim

You need to specify the table occurrence to insert into, such as

INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)

The exact syntax of SQL can vary depending on the program executing it. For example MySQL might accept an SQL statement formated as you did, but apparently FileMaker does not. I did some tests and found that this format worked for me in FileMaker, try it out and tell me if it works...

INSERT INTO test (field) VALUES ('text value')

I also found this documentation, which seems to give specific information on the SQL syntax that FileMaker supports: http://www.filemaker.com/support/product/docs/fms/fm11_odbc_jdbc_guide_en.pdf

Well, yes those are fine and dandy for the general SQL-98+ engines out there but I'm currently struggling against the SQL Engine in FileMaker as accessed via ScriptMaster.

Nevermind. Finally got that one.