SQL for the Common Man | The Philadelphia FileMaker User Group – serving the Pennsylvania, New Jersey and Delaware Region
The most important feature in FileMaker 12 is arguably the ExecuteSQL function. This is the first of an occasional series highlighting some real life uses of this new and exciting technique.
One reason I’m learning to embrace ExecuteSQL is because it lets you perform many tasks without accessing the Relationship Graph. Recently I started working on a large warehouse project. This system has more than 200 users spread across the country with at least 50 active connections any any time. Opening Manage Database to access the Relationship Graph on a hosted database with active users is problematic for a number of reasons that have been explored in detail elsewhere – you run the risk of file corruption if a connection drops, committing database changes can be difficult if users are modifying data, and so on.
More…SQL for the Common Man | The Philadelphia FileMaker User Group – serving the Pennsylvania, New Jersey and Delaware Region.