Folks, I'm happy to announce the release of Version 1.3.4 of SQLiteAdmin, available for download here <http://www.lcsql.com/sqliteadmin.html>. The release is free to all current users of SQLiteAdmin.
SQLiteAdmin provides powerful database administration and data manipulation tools for SQLite databases. All standard SQLite commands are supported plus extended Data Definition functions not available in standard SQLite which allow you to modify your schema in any way while preserving the integrity of your data. Powerful Data manipulation features provide you with the ability to carry out ad-hoc INSERT, UPDATE, and DELETE operations. Powerful data filtering functions allow to display subsets of your data. Various utilities are available to check the integrity of your database, suggest possible schema changes for performance improvement, and export and import data in several formats This release includes several minor bug fixes plus a couple of enhancements, both in the Browse View. After displaying rows, right clicking on any column will display the minimum, maximum, average total and count of unique values. When defining a new filter, you can include a runtime prompt instead of a fixed value for any column. This is particularly useful when creating a filter to be stored for later use allowing you provide a different value for a column each a filter is executed. Two types of runtime prompts are available. One will simply prompt for a text value (with a default), and the other will prompt for a selection from an option menu. You can specify the contents of the option menu in terms of an SQL expression, and foreign key situations are automatically identified and handled correctly. Full details of these enhancements can be found in the User Guide and the release notes<https://docs.google.com/document/d/1hqGISUPuuEHySsObs-taIds0a_pvQWoPNcUcOdeRWaY/edit#heading=h.g8scyjy1ag8c> . Pete lcSQL Software <http://www.lcsql.com> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
