SQL Issues...

[Tori Mitchell]

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?

[Tim Anderson]

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,...)

[dansmith65]

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

[Tori Mitchell]

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.

[Tori Mitchell]

Nevermind. Finally got that one.