Create a custom theme
Posted by 
[Note: Some of the material in this article, and in today's demo file ExecuteSQL Sandbox, previously appeared in my March 2011 article, Custom Functions for Internal SQL.] The other day a colleague remarked, “You know, it’s going to be interesting to see if you SQL guys are still so excited about ExecuteSQL when something gets...
0
FileMaker Hacks
This is a quick follow-up to part 1, with a couple more observations about dynamic parameters. a) I can’t believe I forgot to mention this the other day: A major ExecuteSQL headache that dynamic parameters can alleviate is the dreaded “embedded apostrophe” problem. In case you aren’t familiar with it, if your text string...
I have a confession: when I first read about dynamic parameters in the Help entry for ExecuteSQL, my initial reaction was, “Why do they have to make it so darn complicated?” I have another confession: I am now singing a very different tune indeed. I’ll get to the reason for this in a minute, but [...]
Source
Source
It’s been a fun week experimenting with the ExecuteSQL function, and also seeing what others are doing with it. In some cases the experience has been eye opening, and I strongly recommend that anyone interested in ExecuteSQL grab the SQL Builder file from Eden Morris, available at http://fmforums.com/...25-sql-builder/ This attractive and...
One of the fun things about a new FileMaker release is figuring out how new features work, including subtle behavioral nuances. Today’s demo file, FM12 ExecuteSQL Help Example from CW, is based on Corn Walker’s re-working of one of the demos from part 1, and helps demonstrate how ExecuteSQL fits in with the FileMaker security...
FileMaker 12 offers many intriguing new features, including new windowing capabilities, significant charting and container field improvements, and a brand new design surface. But to my way of thinking, all of these pale in comparison to the exciting possibilities offered by the new ExecuteSQL function. What’s so great about ExecuteSQL? In a...
Well, we’ve reached what may well be the final posting in this extended series of articles. We’ve covered a lot of ground, and this article assumes familiarity with what has come before (in parts 1, 1.1, 2, 3 and 4). Today we’re going to look at a couple “Virtual List” implementations of the User-Friendly Excel [...]
Source
Source
Colleagues and family members are starting to express concern at my obsessive refusal to bring this series to a close. But we’re getting close. Really. In fact, today, we’re going to look at two cool tricks (and one work around) which are utilized in this article’s demo file, excel exports, part 4, but that could [...]
Source
Source
So far in this series we’ve been looking at exporting data to Excel from a single table (Contacts). Today we’re going to extend the technique to encompass a second, related table, Donations, and without too much trouble we can leverage existing work from earlier entries in this series (part 1, part 1.1 and part 2). [...]
Source
Source
[Note: To avoid a huge amount of redundant repetition, this article assumes that you are familiar with part 1 and part 1.1 in this series.] Today we’re going to take a look at streamlining the approach introduced in part 1 by reducing clutter on the Relationships Graph, going from this… …to this, with no loss [...]
Source
Source
Recent Entries
-
FM 12 ExecuteSQL: Robust Coding, part 113 May 2012 -
FM 12 ExecuteSQL: Dynamic Parameters, part 208 May 2012
-
FM 12 ExecuteSQL: Dynamic Parameters02 May 2012
-
FM 12 ExecuteSQL: A Cool Tool28 April 2012
-
FM 12 ExecuteSQL, part 222 April 2012
Latest Visitors
-
usermac14 May 2012 - 10:23 -
Scott Shackelford14 May 2012 - 09:30 -
mr_vodka14 May 2012 - 06:51 -
Gary Sprung14 May 2012 - 03:27
-
RalphL13 May 2012 - 10:53
MyBlogLog
FMForum Advertisers
