The following code creates a SQLite database and uses SQLExecute to create a table. Contact the vendor for more information on how to use them.Īdds support for cubeSQL Server, a database server built on SQLite.Īdds support for the Valentina stand-alone and server databases.Īdds support for the various server databases including Oracle, SQL Server, DB2, Sybase, Informix, InterBase/Firebird, SQLBase, MySQL, PostgreSQL, ODBC, SQLite and SQL Anywhere. The good news is that adding the dylib copy to the OSX build apparently was added to the My Computer build. The following database plugins are also available. The Insert/Copy Files for the dylib placing it into the Frameworks folder worked as expected for the OSX build, however, Xojo rejected my attempts to add it to the My Computer build. Supports the built-in SQLite data source. Use ODBCPlugin.xojo_plugin.Ĭonnects to Oracle 8i and above. Supports the MySQL Community edition server. Use MSSQLServerPlugin.xojo_plugin (Windows-only). and the link you provided is JSQuery not ANSI SQL. Everything other than SQLiteDatabase requires that you copy the appropriate plugin to your Plugins folder.Ĭonnects to Microsoft SQL Server. Use Xojo to create a PREPARED STATEMENT using the database table schema data this way you can have access to all the field names and build the PREPARED STATEMENT dynamically even if the table name or table schema changes. The following subclasses of Database are included. Use one of the subclasses to connect to your database. The Database class is the base class for the database subclasses that communicate with a variety of databases.
