MBS Plugins 18.3 pre-releases

Add-Ons
1

Hello,

in this thread I want to post to you what’s new in 18.3 prerelease plugins.

download here:
https://www.monkeybreadsoftware.de/xojo/download/plugin/Prerelease/

or ask (in private message or email) to be added to the shared dropbox folder.

If you like our plugin, bookmark, like or forward this thread.
If not, well you can ignore it.

Thanks for supporting our plugin.

If you have questions, please post your question as a new discussion.

Greetings
Christian

2

18.3pr1:

  • Updated DynaPDF to version 4.0.20.51.
  • Added NetFSMountMBS class.
  • Added SetLicenseKeyGlobal private method to DynaPDFMBS class to cause compiler error if you call SetLicenseKeyGlobal with an object. Please call only in app.open with shared method.
  • Added SetKeyGlobal private method to XLBookMBS class to cause compiler error if you call SetKeyGlobal with an object. Please call only in app.open with shared method.
  • Changed DynaPDFMBS.SetLicenseKeyGlobal and XLBookMBS.SetKeyGlobal to raise exception if debugging, if called twice to notify developer about misuse.
  • Added more methods for GZipFileMBS and improved error handling.
  • Fixed GZipFileMBS.Read bug for 64bit.
  • Reworked NSMenuItemMBS to make all properties visible in debugger.
  • Added Menuitem function to NSMenuItemMBS class.
  • Added database class for documentation.
  • Added SSH2SessionMBS.OpenDirectTCPIPChannel function to tunnel request through server.
  • Fixed a problem with DynaPDFMBS.RotateTemplate function.
  • Added InternalCubeSQLLibraryMBS module to use built in cubesql client library.
  • Added more properties for TiffPictureMBS class.
  • Added convenience shared methods for GMColorMBS class.
  • Updated EdsFocusInfoMBS for newer Canon EOS SDK.
  • Added MountMBS/UnmountMBS global functions for Mac/Win/Linux.
  • Added CURLSMBS.SetupOAuth function.
  • Upgraded OpenDialogMBS class to use newer API on Windows, if possible.
  • Updated Rockey4NDMBS to work on Windows for 32 and 64-bit.
  • Added WinUserNotificationCenterMBS.Setting function.
3

18.3pr2:

  • Added InitMessageFilterMBS function to block COM retry dialogs.
  • Added JSONMBS.NewUInt64Node function.
  • Changed NSImageMBS.CopyPictureWithMask to return mask, even if image representation is not marked to have alpha.
  • Improved SQLPreparedStatementMBS.SQLSelect to not return invalid RecordSet when SQL is invalid.
  • Improved SQLDatabaseMBS.InsertRecord to better handle float and integer number types.
  • Changed SA_ODBC_SQL_WCHART_CONVERT setting for building SQLAPI on Linux, so we can connect to Microsoft SQL Server here.
  • Updated DynaPDF library to version 4.0.20.53
  • Updated Rockey4NDMBS to use newer drivers including 64-bit for Mac, Windows and Linux.
  • Fixed bug in DynaPDFEditTextMBS.ReplacePattern when new text was added behind existing text instead before.
  • Added conversion code for String to DateTime in case we get dates as text.
  • Fixed bug where SQL Plugin would return date with year 1899 instead of nil for empty SQLDateTime value.
  • Updated SQLAPI to version 4.3.3 beta with fixed for CubeSQL.
  • Changed SSHChannelMBS.Write to no longer convert text to UTF-8 before sending. We now send/read without encoding to transfer the bytes unmodified.
  • Added AVCaptureViewControlMBS and AVPlayerViewControlMBS controls (64bit only).
  • Added MemoryUsed, MemoryHighwater, Keywords and isKeyword to InternalSQLiteLibraryMBS module.
  • Updated SQLite to version 3.24.0.
4

18.3pr3:

  • Fixed a problem with ODBC crashing on Linux with using freetds to connect to Microsoft SQL Server.
  • Added RAWSocketMBS.Connect method to take IPv4/IPv6/hostname to connect.
  • Added Protocol and SocketType properties to RAWSocketMBS and UDPSocketMBS class.
  • Updated SSH2SessionMBS.Constructor to work with IPv4 and IPv6 as well as domain names.
  • Added SSH2TunnelMBS class.
  • Improved Socket handlign to better get IPv4 and IPv6 handled in various socket functions.
  • Updated optipng to version 0.77.
  • Added Debug, Fix, Overwrite, Quiet, Snip, StripAll and Verbose properties to PNGOptimizerMBS class.
  • Updated DisableScreenUpdatesMBS, EnableScreenUpdatesMBS and Window.UpdateNowMBS for 32/64-bit.
5

18.3pr4:

6

MBS Xojo Complete Plugin Set, MBS Xojo ChartDirector Plugin and MBS Xojo DynaPDF Plugin (Starter) is currently available as part of OmegaBundle.

7

18.3pr5:

  • Updated internal graphics functions for Xojo 2018r2.
  • Fixed Cocoa target for OverlayMBS to not use NSWindowStyleMaskNonactivatingPanel which causes a warning from AppKit.
  • Added InsertRecord and UpdateRecord methods to SQLDatabaseMBS class.
  • Added UpdateRecord method to SQLConnectionMBS class.
  • Added shared memory methods to FileMappingMBS class.
  • Added new WindowsGraphicsInfoMBS constructors which uses main screen, window or control.
  • Changed DynaPDFMBS.ImportPDFFile to close open page before importing to avoid error.
8

Can’t see the new Files on your Server :slight_smile:

9

Upload running now. Please come back in 5 minutes.

10

Got em Thx! :slight_smile:

11

18.3pr6:

  • Fixed auto commit issue for CubeSQL.
  • Fixed RegistryValueMBS.asLong32 setter for 64-bit.
  • Fixed CURLSMBS.SetupOAuth to pass parameter names in given case, no longer does lowercase.
  • Added Name property for AVAudioPlayerMBS class.
  • Fixed issue with AVFoundationMBS where the plugin would return the right Xojo object for a AV* object.
  • Added kAUTH_Bearer, OptionDisableUserNameInURL, OptionProxyTLS13Ciphers and OptionTLS13Ciphers to CURLSMBS class.
  • Updated CURL to version 7.61.0.
  • Added MountPathMBS function.
12

is this for the SQL Plugin??

13

Their SQL plugin supports CubeSQL as of March 2018:
https://www.mbsplugins.de/archive/2018-05-28/CubeSQL_support_for_MBS_Xojo_S

14

Of course it’s for the MBS Xojo SQL Plugin.

15

ok what improvements do I get from MBS SQL Plugin from using the plugin supplied by SQLABS?
Honest question because if there was a benefit I might purchase

16

Well, it is one plugin for 14 database types, so very flexible.

Also supports

  • Proper text encoding using Unicode interfaces to database
  • named parameters
  • threaded execution and connect
  • cached recordsets
  • internal or external client libraries
  • Trace event to log all sql commands
  • dictionary based insert and update
  • two Interface via database class or our own interface
  • streaming of blob fields

And probably a few more benefits…

17

Thanks for replying Christian

threaded execution and connect sounds interesting

I should demo on my application

Anything special to get threaded execution or is it handled by the plugin?

18

Call MT methods do that.

19

ok will try doing a demo on the plugin with my application that uses CubeSQL

20

18.3pr7:

  • Updated DynaPDF to version 4.0.21.54.
  • Updated plugin SDK for 2018r2.