![]() ![]() It has the ability to load an object from a RecordSet which SQLdeLite can also do automatically (see the Advanced Features topic below). ActiveRecord can only load a record via it's primary key which is forced to be an integer.These methods replace the default SQLSelect() and SQLExecute() methods for your database of choice. The module extends the built-in Xojo databases classes and provides you with two additional methods. The library does not expose any new database classes nor requires the usage of custom database adapters (as in "Active Record" from BKeeney Software). This converts your SQL query into a Valentina compatible query with bound parameters. Valentina database is also supported by virtue of the SQLdeLite.ParameterizeSQL() method.Make sure to enable support by changing the PLUGIN_CUBESQL_ENABLED constant to True. Enable databases that require plugins by setting the appropriate constant to True (example: PLUGIN_MSSQL_ENABLED). Full support for all Xojo supported databases.Full support for iOSSQLiteDatabase on iOS! You can use the same business logic between projects despite using different database backends.Built on top of the new Xojo framework.Now it's much faster to handle your query parameters and results. Dynamic objects that allow for any number of properties without having to define each one in the IDE.No more string concatenation for your SQL!.These variables are converted to the bounded parameters in prepared statements. ![]() Quickly and easily create SQL queries by using variables representing the properties of your objects.Automatically uses SQL prepared statements mitigating SQL injection attacks and speeding up database performance.Single drop in module that speeds up your development.SQLdeLite is an open source library that allows you to speed up your database development with Xojo. ![]()
0 Comments
Leave a Reply. |