![xojo database example xojo database example](https://i.ytimg.com/vi/_ZC650DLjxw/maxresdefault.jpg)
Registers a callback function with the database connection be invoked whenever a row is updated, inserted or deleted in a rowid table. Provides encryption key for encrypted database. This functions is to be used for when needing only single value result.Įxecutes SQL statement, returning the result as EinhugurSQLite.Recordset or nil. This variation lets you take ExecuteCallback as parameter where you can get live feed as the execution of the SQL is done.Įxecutes SQL and returns the value from the first column of the first row. Sets first encryption key or changes encryption key on the open SQLite database.Ĭancels an open transaction restoring the database to the state it was in before the transaction began.Įxecutes SQL statement without returning result.Įxecutes SQL statement without returning result. Prepared statements also mitigate the risk of SQL injection in web apps. A prepared statement is an SQL statement with parameters that has been pre-processed by the database so that it can be executed more quickly if it is re-used with different parameters. Opens a BLOB column for the specified table and column at the specified row (rowID).Ĭreates a EinhugurSQL.PreparedStatement instance using the SQL statement for use with the various database prepared statement classes. Opens or creates a database at location specified by a FolderItem. Returns an Int64 containing the value of the last RowID added to any table in the database. This function can be called right after Open to check if the database is encrypted. This permanently saves changes to the database.ĭetaches the passed database that was previously attached with AttachDatabase. Executing any other type of SQL statement does not modify the value returned by this function.Ĭommits an open transaction.
Xojo database example update#
This function returns the number of rows modified, inserted or deleted by the most recently completed INSERT, UPDATE or DELETE statement on the database connection specified by the only parameter. You must be connected to the destination database and its original contents (if any) will be overwritten by the backup. It gives the newly attached database the name from the alias passed in.īacks up the database asynchronously or synchronously. Splits a string by separator, returning the requested field.Īttaches the SQLite database referred to by file to the database.
![xojo database example xojo database example](https://www.dragon1.com/images/uml-lifeline.png)
NthField (add-on function to the normal SQLite which you can use in your SQL code) When using the database in encrypted mode then the encryption scheme uses:Įncrypted Databases made with the Xojo default implementation are not compatible to the scheme of this plugin. All sorts of callback delegates so you can have control on different level.Bonus functions in your SQL code, such as NthField and CountFields.Case insensitive collation can be enabled that can handle non US ASCII letters for collation related things, such as sorting.Ability to handle Upper and Lower with non US ACSII letters, no need for huge plugin linking to ICU and no need to link to external library for it.Different encryption scheme for encrypted databases.*.The database can be normal Sqlite database that is not encrypted, or can be Sqlite database encrypted with strong encryption. The EinhugurSqlite.Database class provides access to the SQLite data source.