![]() ![]() 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)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |