Advertisement

02.23.2008 at 05:14AM PST, ID: 23186951
[x]
Attachment Details

Filemaker SQL scripting? (how to query)

Asked by pieter78 in FileMaker Pro Database, Databases Miscellaneous

Tags: Filemaker, Filemaker Pro, 8.0 v1, Mac OS 10.4.11 on G4

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!

PieterStart Free Trial
[+][-]02.24.2008 at 02:20AM PST, ID: 20969435

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.24.2008 at 03:31AM PST, ID: 20969559

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.24.2008 at 04:14AM PST, ID: 20969612

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]03.09.2008 at 04:03PM PDT, ID: 21083066

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.25.2008 at 12:43PM PDT, ID: 21205348

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: FileMaker Pro Database, Databases Miscellaneous
Tags: Filemaker, Filemaker Pro, 8.0 v1, Mac OS 10.4.11 on G4
Sign Up Now!
Solution Provided By: pieter78
Participating Experts: 1
Solution Grade: A
 
 
[+][-]05.11.2008 at 12:06AM PDT, ID: 21541674

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628