Can the Import Records(ODBC) script use filemaker $Variables in the where clause of the Select statement?
You can't use $variable in SQL, but can $variable value.
"SELECT * FROM table WHERE column=" & $variable
need additional literal syntax in each column type.
The example gives invalid syntax error.
"example" should be changed for matching your table/column.
How did you do it?
I think I have to put it in in the calculated SQL checkbox not the SQL query box. I haven’t tried that yet. It did not work in the SQL Query checkbox.
Yes, it is calculation. It is not query itself, calculated result is the query.
Retrieving data ...