SQL Within FileMaker Pro

Expanding the Possibilities of Search

Last session was: October 20 2009

10 am to 2 pm Pacific Daylight Time (6 pm GMT)

Your desk! Online via WebEx

$99.00

Workshop Description

Use a SQL (Structured Query Language) framework to retrieve and manipulate data all within FileMaker. FileMaker can handle just about any level of complexity, so why bother using SQL if you’re not even dealing with external data sources? The answer is because SQL is a very powerful and versatile tool that lets you bypass some of FileMaker’s constraints in manipulating data.

Used effectively‚ partial data management via SQL can lead to fewer table occurrences, simplified relationships, reduced script management, all while providing more powerful and dynamic searching capability.

The framework demonstrates a modular approach. So, while I engage these SQL-oriented custom functions, scripts, triggers, etc., the way I engage them is on an abstract level. Information such as table name, id, field, field value are what’s passed to a script or custom function as parameters. In other words, I don’t have to know anything about SQL when it comes time to engage creating, deleting, selecting or updating data. I write and can modify the SQL-oriented bits once, and reuse those objects anywhere in the file.

Instructor: Rick Aguirre

Senior FileMaker Developer

Also, see Rick’s FileMaker Advisor article
Print edition #72

Rick Aguirre is a senior certified FileMaker developer at Beezwax. For over 15 years he has developed and maintained large-scale custom FileMaker solutions for a wide variety of clients including small businesses and large-scale enterprises. Companies seek his expertise when their FileMaker projects are mission critical and require a deep understanding of FileMaker’s nuances and capabilities.

Rick was one of two Beezwax developers on the 18-person international team that FileMaker, Inc. assembled to establish naming conventions for the Industry.

Have questions? Call 1-510-291-4982 or E-mail us at
training@beezwax.net