Database programming question

Posted on 2003-03-14
Medium Priority
Last Modified: 2010-04-27
I have done some development using Access and am now switching to the Mac and learning Objective-C. I am also new to programming with databases, so I don't have all the lingo and knowledge to fully express my question. I have primarilly programmed in C on a UNIX machine and Visual Basic for applications in Excel and Access to do data storage, retrieval, and processing.

Question: Can a developer use FileMaker Pro as an underlying database to develop a stand-alone application for data management, query, analysis, and alteration? For instance, though I haven't done this, can a stand alone application get a query from a user via a form window, send a query command (in SQL or other language) to the FileMaker Pro database and receive the desired data back for proprietary use in the stand-alone application? And vice-versa, can the stand-alone application receive new data via a form window and send it to the FileMaker Pro database to update or add records? A real world application of this would be, in a health study, we send out questionaires and receive them back. We want to put the data in and run a
statistical analysis. My application would bring up a form for data analysis, then the user would issue a command to do a statistical analysis. The program would go to the database file, retrieve (for this example) age and weight information, run the statistical analysis, and then display the summary statistics. Is FileMaker Pro able to do this? And if so, is there a book describing how this process can be done in the Mac environment? If not, is there a better option?

Thank you for any help and insight you can provide.
Question by:PhilipRiggs
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 8187733
Where is the data that you will do stat analysis on? Local drive, floppy, website, another db? What format is it in?

Example: Your Filemaker Pro application takes the user to the form. The user fills-in the appropriate information. The program imports certain fields from the data file(TXT/XLS/XML/dBase/SQL query). Runs the stat analysis and takes the user to a summary results layout for printing or savisg.

If the above is correct, Filemaker can do the job just fine.

Do you plan to distribute the app or have the minterface through a web page?

Author Comment

ID: 8196541
The program and data would be on a local network drive for in-house lab access. Format is undefined at this point.

If I understand correctly:
1. Develop a form in Filemaker Pro
2. User inputs data via that form
3. Filemaker exports the desired data in, say, text format
4. My program imports the text file
5. My program runs the analysis
6. My program displays results for saving or printing

Can my program run a script in Filemaker Pro to automate tasks 1-3?

Thanks for the reply!

Accepted Solution

KungFoolio earned 225 total points
ID: 8295203
Yes, FileMaker can take care of tasks 1-3.

Step 3 can occur as a script step that exports records to a file (file format of your choice), or via ODBC.

FileMaker is ODBC level 1 compliant, basically meaning that it doesn't keep live communication with the ODBC source - you have to prompt it. You can do this with or without a plug-in. Your ODBC source sould be an SQL server, MS Access db, etc.

(As a statistican that uses FileMaker - I enter data in FileMaker, use a scripted export, and import and work with the data inside of whatever statistics program I'm using. Sure, for summary stats I have FileMaker reports, but there's no reason to teach FileMaker to do regressions, and no one would believe your results anyway :) )

Featured Post

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month14 days, 20 hours left to enroll

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question