#Xojo using classes license#
#Xojo using classes free#

When you call Field() you always get last row, but to read from cached result set, please use Value() function. After this you can walk over the recordset and use FetchPos, FetchFirst, FetchLast, FetchPrev and FetchNext to locate the rows you need. The plugin will than fetch all records and store them in memory. To enable you can call SQLCommandMBS.Cache or use the Option('AutoCache') = 'true' on either command or connection or database objects. The plugin can cache the recordset locally. If you close a database connection while you have RecordSets and SQLCommand in use, things may go wrong. The plugin keeps references from RecordSets and SQLCommand to prevent automatic destruction of the database connection.

#Xojo using classes free#

Please free all RecordSets and SQLCommand objects before you close the SQLConnection or the SQLDatabase.

#Xojo using classes license#

But some features like getting a recordset do need the license as they refer to the SQLDatabaseMBS class.

The SQLConnectionMBS class does not require this license. With Xojo 2013r1, you only need a database server license from Xojo, Inc. For that you need to make a extra SELECT count(*) query. The plugin does not provide RecordCount on RecordSet class. Supported databases: CubeSQL, Centura SQLBase, DB2, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase.Д¬onnect to Microsoft Access, FileMaker Server (or Pro), Microsoft Visual FoxPro and others via ODBC.ДЄs field and table schema functions are not implemented, you can't use this database with the database browser features in the Xojo IDE. All the other methods like deleting a record or updating a value are not implemented and you need to use SQL commands to do this. For the RecordSet, you can get the column count, the column names and values and move to the next row. Errors can be queries with the lasterror properties. You can use Execute and Select to run SQL statements. You prefix this URL with the database type you are using. You can connect with passing the database URL in the DatabaseName property of the SQLDatabaseMBS class. The current implementation is not complete. Or you use the SQLDatabaseMBS class which is a subclass of the database class and can be used with Xojo's RecordSet class. You can use the SQL plugin without using Xojo built in database classes if you use the SQLConnectionMBS and SQLCommandMBS classes. autodisconnect will ocur in destructor if needed Path = 'test.db' // for Windows and Linux in the current folder the application is inside. Path = '/tmp/test.db' // put the database in the temporary folder

but can also be Sybase, Oracle, Informix, DB2, SQLServer, InterBase, MySQL, SQLBase and ODBC Db.SetFileOption SQLConnectionMBS.kOptionLibrarySQLite, getfolderitem( '/usr/lib/libsqlite3.0.dylib', folderitem.PathTypeShell)