Welcome to door 23. We have already seen that we can turn an SQL result into JSON, XML, a matrix, CSV, or text. Now I would like to introduce you to another data structure: dictionaries.
www.mbsplugins.de/archive/2025...
Welcome to door 23. We have already seen that we can turn an SQL result into JSON, XML, a matrix, CSV, or text. Now I would like to introduce you to another data structure: dictionaries.
www.mbsplugins.de/archive/2025...
Today I would like to talk to you about the FM.TableStatistics function. This function provides you with table statistics for your table.
www.mbsplugins.de/archive/2025...
Today I would like to talk to you about the FM.TableStatistics function. This function provides you with table statistics for your table.
www.mbsplugins.de/archive/2025...
Updated LibXL to version 5.0.1.
Improved Translation classes to work mostly on macOS 15 and iOS 18, too.
Added Saxon example for to visualize electronic Invoices (ZUGFeRD, Facture-X, XRechnung or EN16931-1:2017.).
www.mbsplugins.de/archive/2025...
Updated LibXL to version 5.0.1.
Improved Translation classes to work mostly on macOS 15 and iOS 18, too.
Added Saxon example for to visualize electronic Invoices (ZUGFeRD, Facture-X, XRechnung or EN16931-1:2017.).
www.mbsplugins.de/archive/2025...
Added Linux and iOS support for Files.GetNodeID function.
Changed minimum iOS version for deployment to iOS 13.2.
Updated DynaPDF to version 4.0.102.302.
Updated to LibXL 5.0.1.
www.mbsplugins.de/archive/2025...
Added Linux and iOS support for Files.GetNodeID function.
Changed minimum iOS version for deployment to iOS 13.2.
Updated DynaPDF to version 4.0.102.302.
Updated to LibXL 5.0.1.
www.mbsplugins.de/archive/2025...
Our 21st article about SQL in #FileMaker:
We have already output the results of SQL queries as text, as a matrix or as JSON. Today, I would like to introduce you to another return format: XML.
www.mbsplugins.de/archive/2025...
Our 21st article about SQL in #FileMaker:
We have already output the results of SQL queries as text, as a matrix or as JSON. Today, I would like to introduce you to another return format: XML.
www.mbsplugins.de/archive/2025...
Welcome to door 20 of this advent calendar.
With the FM.InsertRecordQuery function we can transfer certain entries from one table to another.
www.mbsplugins.de/archive/2025...
Welcome to door 20 of this advent calendar.
With the FM.InsertRecordQuery function we can transfer certain entries from one table to another.
www.mbsplugins.de/archive/2025...
The FM.SQL.CSV function helps to export records as CSV or TSV as comma or tab separated text.
www.mbsplugins.de/archive/2025...
The FM.SQL.CSV function helps to export records as CSV or TSV as comma or tab separated text.
www.mbsplugins.de/archive/2025...
Do you have a FileMaker Server with multiple databases?
Do you like to keep track who makes changes?
With FileMaker Server 21.1 the Plugin SDK got a new entry point for requesting schema changes.
mbsplugins.de/archive/2025...
Do you have a FileMaker Server with multiple databases?
Do you like to keep track who makes changes?
With FileMaker Server 21.1 the Plugin SDK got a new entry point for requesting schema changes.
mbsplugins.de/archive/2025...
Today, I would like to show you how to update data records using our FM.UpdateRecord function.
www.mbsplugins.de/archive/2025...
Today, I would like to show you how to update data records using our FM.UpdateRecord function.
www.mbsplugins.de/archive/2025...
Four months to go and we got a few more registrations from 10 countries: 🇩🇪, 🇳🇱, 🇵🇱, 🇬🇧, 🇨🇭, 🇺🇸, 🇪🇸, 🇬🇷, 🇨🇦, and 🇫🇷.
If you signed up and you didn't receive an email from us, please contact us.
www.mbsplugins.de/archive/2025...
Four months to go and we got a few more registrations from 10 countries: 🇩🇪, 🇳🇱, 🇵🇱, 🇬🇧, 🇨🇭, 🇺🇸, 🇪🇸, 🇬🇷, 🇨🇦, and 🇫🇷.
If you signed up and you didn't receive an email from us, please contact us.
www.mbsplugins.de/archive/2025...
The FM.CompareTables function can compare changes in tables.
It compares two tables for their fields and records and checks whether data has been changed, added, or deleted.
www.mbsplugins.de/archive/2025...
The FM.CompareTables function can compare changes in tables.
It compares two tables for their fields and records and checks whether data has been changed, added, or deleted.
www.mbsplugins.de/archive/2025...
Enhanced OData capabilities, macOS 26 compatible, Security Fixes and bug fixes.
help.claris.com/en/server-re...
Enhanced OData capabilities, macOS 26 compatible, Security Fixes and bug fixes.
help.claris.com/en/server-re...
Today we want to take a look at how to delete records. As already mentioned in door 3, we can also delete records using the MBS SQL functions.
www.mbsplugins.de/archive/2025...
Today we want to take a look at how to delete records. As already mentioned in door 3, we can also delete records using the MBS SQL functions.
www.mbsplugins.de/archive/2025...
Since macOS 26 (and iOS 26) you can use the Translate framework to perform on-device translation services. You can use this with the upcoming MBS Xojo Plugins, currently in beta test.
www.mbsplugins.de/archive/2025...
Since macOS 26 (and iOS 26) you can use the Translate framework to perform on-device translation services. You can use this with the upcoming MBS Xojo Plugins, currently in beta test.
www.mbsplugins.de/archive/2025...
In order to perform SQL queries, we need to know the database structure. Which tables do we have and what are the names of the fields in the corresponding tables?
www.mbsplugins.de/archive/2025...
In order to perform SQL queries, we need to know the database structure. Which tables do we have and what are the names of the fields in the corresponding tables?
www.mbsplugins.de/archive/2025...
Merged a couple of plugin parts
Fixed a problem with DASessionMBS class' constructor
Updated Scintilla to version 5.5.8.
Changed minimum deployment to macOS 10.13 and iOS 12.0.
Added IndentSize property to JSONMBS class.
www.mbsplugins.de/archive/2025...
Merged a couple of plugin parts
Fixed a problem with DASessionMBS class' constructor
Updated Scintilla to version 5.5.8.
Changed minimum deployment to macOS 10.13 and iOS 12.0.
Added IndentSize property to JSONMBS class.
www.mbsplugins.de/archive/2025...
Fixed an issue with FM.InsertOrUpdateRecord and field names containing double colon.
Changed Text.HTMLtoStyledText to add return after DIV element.
Added JSON.SetFormatOptions function.
www.mbsplugins.de/archive/2025...
Fixed an issue with FM.InsertOrUpdateRecord and field names containing double colon.
Changed Text.HTMLtoStyledText to add return after DIV element.
Added JSON.SetFormatOptions function.
www.mbsplugins.de/archive/2025...
We have already established that we can output the results of our SQL query not only as text, but also as a matrix, for example.
Today, we want to receive our results as a JSON return.
www.mbsplugins.de/archive/2025...
We have already established that we can output the results of our SQL query not only as text, but also as a matrix, for example.
Today, we want to receive our results as a JSON return.
www.mbsplugins.de/archive/2025...
Today, I would like to explain the term UNION in SQL in detail. With UNION, we can combine results from multiple tables.
Enjoy the 12th article from Stefanie in this series.
www.mbsplugins.de/archive/2025...
Today, I would like to explain the term UNION in SQL in detail. With UNION, we can combine results from multiple tables.
Enjoy the 12th article from Stefanie in this series.
www.mbsplugins.de/archive/2025...
As you may know the FileMaker Soup is a community organized forum for English speaking Claris #FileMaker developers to support each other.
The forum is run by a non-profit organization.
the.fmsoup.org/t/fm-soup-fu...
As you may know the FileMaker Soup is a community organized forum for English speaking Claris #FileMaker developers to support each other.
The forum is run by a non-profit organization.
the.fmsoup.org/t/fm-soup-fu...
Today, we want to take a look at how we can use SQL to insert new records into our table with FM.SQL.Execute or FM.InsertRecord.
www.mbsplugins.de/archive/2025...
Today, we want to take a look at how we can use SQL to insert new records into our table with FM.SQL.Execute or FM.InsertRecord.
www.mbsplugins.de/archive/2025...
Welcome to Door 10. Today, I would like to talk to you about the FM.SQL.Max and FM.SQL.Min functions.
www.mbsplugins.de/archive/2025...
Welcome to Door 10. Today, I would like to talk to you about the FM.SQL.Max and FM.SQL.Min functions.
www.mbsplugins.de/archive/2025...
Let's check the new library feature in #Xojo and look a bit into how to use it and what benefits and limits it has.
www.mbsplugins.de/archive/2025...
Let's check the new library feature in #Xojo and look a bit into how to use it and what benefits and limits it has.
www.mbsplugins.de/archive/2025...
You can order licenses already for 2026 and beyond and get invoice in 2025. New license and multi year renewal for MBS #FileMaker and #Xojo Plugin licenses.
www.mbsplugins.de/archive/2025...
You can order licenses already for 2026 and beyond and get invoice in 2025. New license and multi year renewal for MBS #FileMaker and #Xojo Plugin licenses.
www.mbsplugins.de/archive/2025...
Today, I would like to introduce two functions that you can use to evaluate the data in your results even further: FM.SQL.Sum and FM.SQL.Avg.
www.mbsplugins.de/archive/2025...
Today, I would like to introduce two functions that you can use to evaluate the data in your results even further: FM.SQL.Sum and FM.SQL.Avg.
www.mbsplugins.de/archive/2025...