FileMaker and SQL SELECT Statement

[Cyont]

Hi,

I know FileMaker can run SQL UPDATE/DELETE/INSERT statements with "Execute SQL", but can it run SELECT statement? If yes, in what form or name does the query result appear? In other words, how can I use the query result in the script?

Cyont

[Ted S]

You come at it from an import point of view. You import data from your external datasource into FileMaker.

Choose: File | Import Records | Import ODBC Data Source. I'm guessing you will choose ODBC rather than XML.

I bet your next question will be: 'Yeah, but I don't want the data in FileMaker I just want to view it from FileMaker.' The answer to this is you can't. You have to import it.

When I first heard about the ODBC connectivity of FileMaker (new to v6?) I anticipated something along the lines of a SQL calculated field. You would create a new field in FM, deem it to be a SQL calculation, and it would query an external DB and return results based on the calculation. No data would actually be housed in FileMaker. But this was just a dream of mine, and maybe a stupid one at that.

[pmconaway]

When I first heard about the ODBC connectivity of FileMaker (new to v6?) I anticipated something along the lines of a SQL calculated field. You would create a new field in FM, deem it to be a SQL calculation, and it would query an external DB and return results based on the calculation. No data would actually be housed in FileMaker. But this was just a dream of mine, and maybe a stupid one at that.

Ted, I was hoping for something simular. It would be great to be able to grab results without having to import records.