Hello,
I have set up a database in Filemaker Pro 8 on my Mac, and I want to query the records. I have experience with PHP/MySQL and also a little with MS Access querying. I thought it would be simple, but so far it is not...
I am wondering how to query the database effectively. I want a sheet that displays several summaries of the database (NrOfThis, NrOfThat, etc) that are automatically updated as I enter new data. There is no need for user-defined variables in the query.
As far as I found, the Filemaker default options for this did not meet my needs (to detailed, not useful) and I have been looking around if I could do something with SQL. I do not have experience with ODBC on the Mac, neither is SQL mandatory.
But how can you create self-defined queries (just local in hard drive) using FM Pro 8?
Thanks!
Pieter
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks for the response.. I am querying an internal FMP database, so the first method should work (I am currently not at home, so cannot test right now).
If I understand you correctly, I can use SQL-syntax instead of the asterisk?
For example:
find mode
def field = * FROM table1 WHERE (field1 = "something")
execute find
??
And is there a particular type of script that I need to use for this purpose?
Thanks!
Pieter
no, you can't use sql syntax for fm queries, only fm syntax (much closer to humans!)
so, it is basically, what you can type in a regular Ctrl F.
the table you search from is determined by the layout's table you're in.
so you may have to "goto layout" before querying.
type of script?
??? a fm script done with scriptmaker, no choice, but easy to learn, it is more a macro language and all commands are dropped from a list, not typed.
As stated, question can be closed. I have chosen a different approach using Flex (e.g. http://www.experts-exchang
Reward lesouef 300 points for his efforts, then close and delete this question please.
you can use sql to query filemaker - see smart pill - http://www.scodigo.com/
Business Accounts
Answer for Membership
by: lesouefPosted on 2008-02-24 at 02:20:31ID: 20969435
simply by writing a script.
are you query a filemaker database or an external SQL source?
for internal databases; simply use
find mode
def field = *
execute find
that's the same as a basic sql select *
for an external one, you need to import the sql records into filemaker with a SQL query which can be stored as well.
=> import, from SQL source, you'll get a tiny wizard where you can build up a query for non sql people to type directly the query.
this means you need to create an internal table to store the data before you can do anything else with it.
Other queries can be used using the SQL query script step. requires a DSN source to be setup first.