SQL queries within FM to create reports

[Trisherson]

Hi there.

I've recently done a course in SQL query language and wonder how I can use it to advantage with internal querying of a database. I don't want to link externally with other databases but it seems a powerfull language and I can't seem to get any joy when I request it for a script or scripted button. Surely ODBC is only necessary when linking with an external data source.

there's very little info out there and the FM Users guide says next to nothing.'

[mr_vodka]

Well have you tried the FileMaker ODBC/JDBC Developer's Guide located on their site?

Also if you dont mind paying a small subscriptions fee, FileMakerMagazine.com is a wonderful source and Matthew has an article / video regarding this subject as well.

Preview Video Link