This was the last day of DevCon 2009, and it was a short one. Here's a final recap...My first session today was Geoff Coffey's "Practical Script Triggers." Geoff did a great job of showing us how we can very easily use script triggers to make big improvements to our solutions. His demonstrations included highlighting of the active record in list view, a technique for safely allowing a user from
Wow, what a great first day of DevCon sessions. Here's a recap of some of the events and sessions that I attended:First off, I skipped the "Continental Breakfast," and from what I hear that was a very wise decision. Instead, I hit the StarBucks in the lobby before a line had formed. I had a nice caffeine buzz going before the first session even started.The first session that I attended was
I've been using the ESS feature in FileMaker 9 for awhile now. I've used it to develop several FileMaker-based, mission critical solutions that integrate very well with SQL-based systems. I'm living proof that FileMaker can be integrated with SQL databases, and it can be done securely and efficiently.One of the most common complaints that I hear from SQL DBAs with regards to ESS is that they
I think I've found a bug in FileMaker Pro 9's ESS function, specifically with regards to how it deals with SQL views as datasources. Here's the story...I was working on a FileMaker / SQL Server integration project, and run into a problem. I was trying to include a view in the relationship graph. I selected the datasource, selected the view, and was prompted to select a column to use as the unique