I would take a look at the entry in FileMaker help titled:Automating ODBC import using the Import Records script step
thanks, i actually missed that and it was very helpful.
However, I'm still not able to get the query to behave the way i want it to.
I tried storing the variable in the calc and I still get an SQL error.
Where I was setting the variable in the script now I set it in the calculation.
::ODBC_Import ="SELECT AgeFROM StudentsWHERE Age > \"\"::MinAge\"\""
In the sql query builder I select the option "calculated sql text" and enter ::ODBC_Import
Thanks for the help
You are trying to specify a 'variable' SQL. Something like: