SQL Yoga Flexible database library for Revolution desktop and web applications
Download

SQL Yoga Ranking & Summary

SQL Yoga Tags

SQL library database database library SQL development Revolution library

SQL Yoga Description

Flexible database library for Revolution desktop and web applications SQL Yoga extends the simplicity of Revolution to databases by allowing you to treat your database like an object. Stop wrestling with SQL and see how easy database integration can be:. Set properties rather than writing SQL. Define searches using english words rather than arcane wildcard symbols. Manipulate arrays, not cursors. Easily generate searches from complex search UIs. Tap into database table relationships to simplify codeSQL Yoga has currently been tested with MySQL, SQLite, SQL Server (over ODBC), PostgreSQL and Valentina (both local and client). Limitations: · The demo version returns a maximum of 10 records from the database and displays a dialog every 10 minutes. What's New in This Release: · Added sqlyoga_getDatabases(). · A Database object's "connections" property now returns a return delimited list of the names of Connection objects. · dbobject_createObject now throws an error if you try to create a Database object with no name or a name that already exists. · tableobj_createObject now throws an error if pName is empty. · Fixed a bug in dbconn_exists(). · dbconn_createObject now throws an error if name is already taken or if name is empty. · When calling tableobjects_reload the default Database object is set to the Database tableobjects_reload is acting on. This way any table, relationship and scope objects are created in the proper Database object if it is no the default one. · tableobjects_reload now targets the behavior button directly when messages are dispatched. · sqlquery_retrieveAsArray now behaves as documented in that it aggregates results in the array you pass in. · When setting the "select clause" of a SQL Query object you can using TABLE.to include all columns in a table. All columns of the table will be added to the query and respect the "column names length" property. When generating hierarchal results of Records column names length = "long" is required and this syntax provides a nice shortcut for times when you need to add some SQL functions to the query. · Fixed an issue with converting multiple many-to-many relationships in a cursor to hierarchal arrays of Records. · IS NULL was being translated to = NULL when setting the "condition" property of a SQL Query or Scope object. · sqlrecord_find now accepts any non-array variable when performing the find. · Updating a record now throws an error if no primary key is defined for the table and no where clause is supplied. · Added sqlquery_create and sqlquery_update. These commands allow you to create/update specific fields in database tables without creating Record objects. · Added 'sql conditions' property to Scopes so you can see the SQL that will be generated. · Importing a database schema for a Database object that was not the default would replace the default Database object. · Added tableobjects_tableExists(). · Added "column names length" (short, full, default). Allows you to explicitly select just column name (short), the table and column name (full) or the default behavior. Supersedes "full column names". · When throwing the "sqlyoga_executesql_err" and "sqlyoga_connection_err" errors SQL Yoga now includes the context information so you can track down who generated the bad SQL call. · Trying to add a non-existent scope to a SQL Query object now throws an error. · dbconn_createObject now throws an error if you pass in the name of a Database object that doesn't exist.

SQL Yoga Related Software