For most database drivers, we use unicode APIs directly, so we skip conversion steps. like this sample implementation, which uses a TraceEnabled boolean property in SQLDatabaseMBS subclass to toggle whether we log SQL for debugging: Sub Trace(traceInfo As Integer, SQL As String, Command As SQLCommandMBS) The trace event provides all SQL run by the plugin and is at a low level, so it catches also the insert statements made by AddRow or InsertRecord methods.Į.g. Or you use addHandler to connect the event to your method to log SQL requests. You may decide to either subclass these classes and implement the event.
Our plugin has a Trace event in SQLDatabaseMBS and SQLConnectionMBS classes. By encapsulating a vendor’s API, the plugin acts as middleware and delivers database portability. The product also provides a low-level interface that allows developers to access database-specific features. It uses native APIs of target DBMS so applications developed with this plugin run swiftly and efficiently. The MBS Xojo SQL Plugin is a Xojo plugin for accessing multiple SQL databases (CubeSQL, Centura SQLBase, DB2, DuckDB, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase).
Let us show you how we do a few things with our plugin, which you may not do like this with the official database plugins in Xojo. As you may know we have our own MBS Xojo SQL Plugin for Xojo, which is an alternative to the built-in database classes in Xojo.
0 kommentar(er)
