I am trying to insert the result of an SQL query into a field in FMP 9.

Here is my SQL statement (which produces the correct result):

SELECT count(*) FROM smart_cd.USAGE_SAS WHERE FTR_SERVICE_TYPE = 'C'

I can run the SQL query in a script using "Execute SQL", but I can't figure out how to send the results to a field in FMP.

I don't want to hard code the value of the field to equal the SQL statement (as in a calculation), as I want to be able to retrieve this information at will.

Any assistance is appreciated.

Thanks,

Tony

I have the same question.

Is it possible to create a script that will run a SQL query and then store the result in a FilMaker9 field.

My SQL database is a lot more complicated than my Filemaker Database, and they are not always connected. This could be done making all of the connections using relationships in FM, but this seems tedious for a little bit of information.

most of the time I just query to excel and then import my data.

Thanks

Why dont you just use an import using ODBC? You can specify your SQL statement there.

So are you saying this is impossible in version 9?

Set it up as a view in SQL and you should be able to access it via ESS... But if you read what mr_vodka said he's telling you a way to get it working...

In FileMaker, you can use the import step but instead of another file, there is an option for ODBC.