|
SQLMagic™ |
This software is under development. If you would like to be kept informed of progress on this product, please send an email using the form on the Contact page
If you develop Livecode applications using SQL databases, SQLMagic™ is for you! It eliminates a high percentage of the Livecode scripts and SQL Data Manipulation statements normally required to implement an SQL database application, freeing up your time to concentrate on the design and coding of the more complex aspects of your application.
SQLMagic™ takes care of:
If you develop Livecode applications using SQL databases, SQLMagic™ is for you! It eliminates a high percentage of the Livecode scripts and SQL Data Manipulation statements normally required to implement an SQL database application, freeing up your time to concentrate on the design and coding of the more complex aspects of your application.
SQLMagic™ takes care of:
- selecting data from your database, filtering it on any column under either your or the user's control, converting it from internal storage format to display format (including dates, times, and currencies);
- populating Livecode controls, including fields, datagrids, option menus, comboboxes, checkboxes, radio buttons, sliders and scrolling lists;
- customizing datagrid columns to contain menus, checkboxes, etc.;
- updating, deleting, and inserting single or multiple rows with one click of a button;
- accessing multiple tables in any combination of SELECT/INSERT/UPDATE/DELETE modes on one card;
- locking strategies to protect the integrity of your database;
- navigating between tables based on primary and foreign key definitions.