New in this prerelease of the 2.9 plugins:
- Added String.LevenshteinDistanceMBS and String.JaroWinklerDistanceMBS.
- Added ProgressDialog.SetFont.
- Added NSEventFilter.DisableEvents, NSEventFilter.EnableAllEvents and NSEventFilter.EnableEvents.
- Added Process.IsFrontMost and Process.SetFrontMost.
- Fixed a bug with the plugin not reading containers correct with external stored file data.
Download at
monkeybreadsoftware.de/filemaker/files/Prerelease/.
You can read though the impressive list about
how to get a corrupted SQLite database.
We never had problems so far here, but we use a lot of SQLite databases. So maybe the day comes where a database is running crazy and needs a fix.
You can read more on the website:
sqlabs.com/sqlitedoctor.php.
Sebastian just arrived. Mother and son are well and enjoy their time together.
Whenever you open a SQLite database in your application, please remember to first send this command via SQL Execute:
PRAGMA cache_size = 10000
this will increase the cache. Default is 2000 pages and with a page size of 1024 bytes that's only 2 MB of cache. You can easily set it to 10000 or 20000 pages on modern computers. This way you increase SQLite performance a lot!
This works for
REALSQLDatabase,
SQLDatabaseMBS and
SQLConnectionMBS in Real Studio as well as with our
MBS Filemaker Plugin when used with SQLite.
New in this prerelease of the 2.9 plugins:
- The plugin shows now the version number if you click configure button in Filemaker Preferences after selecting our plugin there.
- Added more libxl functions.
- Moved plugin to FM12 SDK and already preparing to support 64 bit in a future release.
Download at
monkeybreadsoftware.de/filemaker/files/Prerelease/.
Over the years our plugin got bigger and bigger. This is typically no problem with modern hard discs and automatic installation through databases or auto update.
But for some people size matters. For example with our
Filemaker Runtime Shrinker we got a couple of responses. People doing runtimes love this tool.
But when they use our MBS Filemaker Plugin, the plugin itself can be a problem in size. We are now close to 10 MB which is for some people a problem. So we offer now a new service for slimmed down plugins. When you are ready to deliver your runtime solution, you inform us with a list of the MBS functions you use and we compile you a special copy of the current plugin version with all other functions disabled. This way the size of the plugin can easily fall from 10 MB down to 2 MB.
It's hard to predict the size of the plugin you get for your function set as some functions need more code than others. And we have to charge for this as this takes time to build. We are going to charge 49 Euro for each customized plugin copy. if you are interested, please contact us.
New in this prerelease of the 2.9 plugins:
- Added WebView.SetCustomUserAgent and WebView.GetCustomUserAgent functions.
- Added functions for container value encryption: Encryption.EncryptContainerBlowfish, Encryption.DecryptContainerBlowfish, Encryption.EncryptContainerAES and Encryption.DecryptContainerAES.
- Added more LibXL functions.
- Fixed CURL to reset input file pointer when uploading same file data to multiple locations.
- Fixed crash when disabling the MBS Filemaker Plugin in Filemaker Preferences.
- Fixed FileDialogWatcher.Install so you can't install it several times.
- Added parameter to WebView.Reload to force reload.
- Fixed Windows clipboard functions. Sometimes they had extra characters at the end of the text.
Download at
monkeybreadsoftware.de/filemaker/files/Prerelease/.
New in this prerelease of the 2.9 plugins:
- Recompiled php library for Mac with support for older Mac OS X versions.
- Added SQL.MySQL.InsertID and SQL.SQLite3.LastInsertRowID functions.
Download at
monkeybreadsoftware.de/filemaker/files/Prerelease/.
As you have probably seen today, we added PHP functions to both the
Real Studio and the
Filemaker plugin. The new plugin is based on the current stable PHP release, version 5.4.6. It allows you to load the php library and execute code there. Also you can set and get global variables. This allows you to easily pass in and out text data.
If you like you can compile your own copy of the PHP library. This way you can enable or disable extensions. The libraries we include on Mac has for example this extensions: Core, date, ereg, libxml, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, SPL, json, session, PDO, pdo_sqlite, standard, posix, Reflection, Phar, SimpleXML, soap, sockets, exif, tokenizer, xml, xmlreader, xmlwriter and zip.
We had a couple of years ago a PHP plugin which we dropped. It was linked to PHP 5.3 and not compatible with newer versions. Well, with the new plugin we rewrote big parts. Still it heavily depends on the PHP source code and if there is a change on some global data structures, we'll have to update the plugin again. If you need the plugin to be updated to a newer PHP version, please contact us.
New in this prerelease of the 2.9 plugins:
- Added Window.DisableScrollbars and Window.EnableScrollbars.
- Added PHP plugin functions.
Download at
monkeybreadsoftware.de/filemaker/files/Prerelease/.
Update: The examples for OCR and PHP use a line to replace ".fp7" with the library extensions. This needs to be changed to ".fmp12". We'll fix the examples with next prerelease.
