# \#executesql **URL:** https://the.fmsoup.org/tag/executesql/657.md [Latest](https://the.fmsoup.org/latest.md) · [Categories](https://the.fmsoup.org/categories.md) · [Tags](https://the.fmsoup.org/tags.md) --- ## [SQL error checking improved](https://the.fmsoup.org/t/sql-error-checking-improved/5406)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 0\ **Last updated:** [May 2, 2026, 5:50am UTC](https://the.fmsoup.org/t/sql-error-checking-improved/5406 "2026-05-02T05:50:28Z")
SQL error checking improved We have various FMSQL functions in MBS FileMaker Plugin for years. You can execute some SQL command and pass parameters with FM.ExecuteFileSQL function. The function does the job and either re… --- ## [MBS FileMaker Advent calendar](https://the.fmsoup.org/t/mbs-filemaker-advent-calendar/5156)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 23\ **Last updated:** [December 24, 2025, 2:44pm UTC](https://the.fmsoup.org/t/mbs-filemaker-advent-calendar/5156 "2025-12-24T14:44:30Z")
Today we start with the first door of this year's MBS Advent calendar. This year, we have come up with a themed Advent calendar for you. Over the next 24 doors, you will learn how to work with SQL within a FileMaker d… --- ## [Skinny Tables, Attributes as Fields, Attribute Tables, Dwindling Value Lists, eSQL and Scale](https://the.fmsoup.org/t/skinny-tables-attributes-as-fields-attribute-tables-dwindling-value-lists-esql-and-scale/4661)
**Author:** [@Dutchman](https://the.fmsoup.org/u/Dutchman)\ **Replies:** 4\ **Last updated:** [February 25, 2025, 7:50pm UTC](https://the.fmsoup.org/t/skinny-tables-attributes-as-fields-attribute-tables-dwindling-value-lists-esql-and-scale/4661 "2025-02-25T19:50:28Z")
I have a few Zen principles I try and adhere to when building FM solutions, including keeping my tables as skinny as possible and avoiding data tables that look like Swiss cheese when shown in table view. Accordingly, I… --- ## [Building a Mobile Responsive Grid Layout in FileMaker Pro](https://the.fmsoup.org/t/building-a-mobile-responsive-grid-layout-in-filemaker-pro/4239)
**Author:** [@greenflux](https://the.fmsoup.org/u/greenflux)\ **Replies:** 8\ **Last updated:** [August 28, 2024, 10:49am UTC](https://the.fmsoup.org/t/building-a-mobile-responsive-grid-layout-in-filemaker-pro/4239 "2024-08-28T10:49:06Z")
Hello FileMaker Devs! I just wanted to share a tutorial I wrote on how to build a mobile responsive grid with click events. The code should be pretty easy to edit and add your table data to the grid. You can copy t… --- ## [Help getting a list of Tables and record count formated in JSON](https://the.fmsoup.org/t/help-getting-a-list-of-tables-and-record-count-formated-in-json/3618)
**Author:** [@Susurrus](https://the.fmsoup.org/u/Susurrus)\ **Replies:** 8\ **Last updated:** [January 5, 2024, 7:35pm UTC](https://the.fmsoup.org/t/help-getting-a-list-of-tables-and-record-count-formated-in-json/3618 "2024-01-05T19:35:36Z")
I am working on making a script that will set a variable that stores all the table names of the current file and there record count in JSON. I am close but I am having issues getting the count to work. How dose one make … --- ## [Best Practices for hardening field names in ExecuteSQL](https://the.fmsoup.org/t/best-practices-for-hardening-field-names-in-executesql/3147)
**Author:** [@JasonMark](https://the.fmsoup.org/u/JasonMark)\ **Replies:** 12\ **Last updated:** [October 14, 2022, 3:41pm UTC](https://the.fmsoup.org/t/best-practices-for-hardening-field-names-in-executesql/3147 "2022-10-14T15:41:49Z")
I've seen many different ways to write SQL statements in Filemaker. I tend to just write it by hand and if I have to change a fieldName use FMPerception to find all instances of the field and manually change the script. …