MacSQL 3.0.1 Read Me This software is ©2004 Runtime Labs and may not be redistributed except as a disk image in the same format as downloaded from the Runtime Labs website. The latest version is always available from . This software may not be distributed on CD-ROM or other physical media without permission from Runtime Labs, LLC. What is MacSQL? MacSQL provides an easy way to view, manipulate, and manage SQL databases from a Macintosh computer. Features include: Ą Connects to FrontBase, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, and Sybase database servers. Ą Graphical query editor including support for joins. Ą Query Drawer to store and organize frequently used queries. ĄĘFlexible data views including text, spreadsheet, and record-based form. Ą Schema Viewer that shows databases, tables, columns, indexes, foreign keys, and constraints. Ą Syntax highlighting of keywords, literals, operators, and comments. ĄĘManager users, groups, and their access to the server (MySQL and Oracle only). Ą Synchronization between SQL databases and FileMaker Pro. Ą Create Table Tool to help visually design tables. Ą Ability to export data as SQL commands, tab-delimited text, comma separated text, XML, HTML, or in Microsoft Excel format. Ą Import of SQL, CSV or Tab-delimited text files. Ą Web Script Assistant that will generate PHP or Embedded Perl to interact with a database. Ą Comprehensive AppleScript support including recordability. Ą Comprehensive user manual and tutorial. Ą Free upgrades for one year. Ą Telephone and email support. Ą Extensive support for MacOS technologies such as Aqua, AppleScript, Navigation Services, Contextual Menus, Keychain, Drag & Drop, and more. Features new to MacSQL 3.0 include: Interface completely rewritten from the ground up. Flexible data views: view query results as text, in a spreadsheet, or in a single record form view. Query folders: save and organize frequently used queries in the query drawer. Query editor: visual editor for building SELECT queries (including table JOINs). Syntax highlighting: keywords, quotes, operators, and comments are colored as you type queries. Relationships: define relationships between tables for JOIN support throughout MacSQL (ideal for MySQL which does not support foreign keys). Enhanced Schema Viewer: now uses a column format to display columns, indexes, foreign keys, constraints, and relationships. User management: add/edit users and their privileges (Oracle and MySQL only). Support for table options: Create Table Tool offers support for MySQL options such as table type and for Oracle options such as tablespace and pctfree. Rendezvous support: automatically finds Sybase and PosgtreSQL severs on the local network. Expanded export options: save exports directly to Microsoft Excel¨, text, SQL, XML, or HTML files. Remembers open documents: optionally opens all documents that were open the last time the application quit. WebScript Assistant enhanced: new templates added and fully supports HTML 4.0. Significant performance improvements. MacSQL requires a computer running MacOS 10.3 or greater installed. Access to a supported database is also required to use the program. Oracle support requires installing native drivers (instructions are included in MacSQL's Help). FrontBase support on Mac OS X requires that the Frontbase drivers be installed. OpenBase support on Mac OS X requires that the OpenBase drivers be installed. MacSQL is commercial software, distributed as a time- and feature-limited application that can be fully-enabled by purchasing a registration code from our website . The demo mode is fully functional except for saving documents and can be launched 20 times in a 60-day period. The software can be purchased via our website . Release Notes ------------- 3.0.3 Fixed bug where saved documents would no longer connect to the database if they were saved multiple times. Added document setting to size columns based on data returned (to remove extra spaces at the expense of pre-fetching all the results.) Export: fixed bug when exporting as tab-delimited when null values exist. Export: all textual export formats allow saving file with ".txt" extension. Export: sql export has option to save sql for each table in a different file. FM Synch: converts curly quotes to straight quotes to prevent updates from failing to MySQL and sending the actual curly quotes to other databases. FM Synch: removed ability to select FM RecordID as the key value when synching from SQL to FM. This option was not a valid choice and would result in a crash during the synch. Form View: fixed bug where values were not editable with Oracle and SQL Server. Import: text imports 5-6x faster. (A 4MB CSV file with 30,000 records took 4:28 in 3.0.2, 0:41 in 3.0.3) Oracle: reverted to 3.0.1 handling of numbers (NUMBER is once again treated as an integer, not a float. The float change in 3.0.2 had made MacSQL unusable for a number of customers due to rounding problems). Oracle: lengths of varchar2 columns are restored (regression in 3.0.2). Prefs: size of recent documents menu can now be adjusted. Query Editor: when switching from text to visual mode, "select *" is no longer expanded to a list of all columns. Save Results & Export: column names can be included in an Excel export. Save Results: remembers last selected format. Save Results: new option to create new mail message with results attached (works with Mail, Eudora, Entourage). Schema Viewer: documents now remember size/number of browser columns. Schema Viewer: select print while a schema/database is selected now prints schema info for all child tables. Scripts menu now uses black icon ala Mail/Xcode. SQL Server: Query parser supports escaping the schema/user name so the Query Editor and Edit Table Data work when the user name contains non-standard characters and must be [quoted]. SQL Server: stored procedure row results now displayed/returned. Spreadsheet: fixed bug when copying rows with null values. Spreadsheet: fixed bug when updating oracle rows with a FLOAT primary key value. Spreadsheet: fixed intermittent display glitch when resizing first column. Spreadsheet: Save Results As.. in the Query menu is now enabled. 3.0.2 Fixed bug introduced in 3.0.1 when saving password to keychain for the first time. Create Table Tool: fixed crashing bug when adding a column with servers that don't require database selection. FileMaker Synch: fixed bug with FM 7.0v2 when synching via AppleScript. FileMaker Synch: fixed bug where some SQL column names might not be offered when mapping fields to columns. FrontBase: fixed bug that would ocassionally stop row fetches after 10 rows. MySQL: fixed display problem with decimal data type definition. Oracle: numeric data is designated as FLOAT or DECIMAL if appropriate, otherwise NUMBER. Schema Viewer: correct column edited when columns have been re-sorted. Schema Viewer: column details now has an Unsigned column when working with MySQL. Schema Viewer: document remembers order/width of table showing column, index, relationship details. WebScript: fixed simple search bug on line 50 of generated page. 3.0.1 Fixed spreadsheet reload error. User warned that not possible when trying to view unparsed query in form view. Cancel button displayed while opening a new document actually works for Oracle and OpenBase. Scripts menu properly loads scripts in /Library/Scripts/MacSQL3 and ~/Library/Scripts/MacSQL3 Documents now remember the size of the query drawer. Items can be renamed in the query drawer. Trailing and leading whitespace is removed from the name of queries added to the Query History. Fixed bug where passwords were sometimes stored in document instead of keychain. Keychain items are updated to match MacSQL3 instead of MacSQL 2.6. Fixed bug where clicking on a column name would scroll that column to the bottom of the browser. Fixed Query Editor bug when loading a query after an unparsable query was loaded. Fixed query parser bug related to functions that could cause a crash in Query Editor if asked to edit complex query with function calls. Fixed bug where spreadsheet got confused if multiple columns had the same name. Fixed display glitch when resizing last column of spreadsheet. Fixed bug that could cause a crash while quitting with a for view open. Fixed crashing bug when MySQL User Manager opened by user with no permission to read grant tables. Fixed bug where moving a query between two folders would fail and display alert. Data menu contains "Resize Columns" item that resizes spreadsheet columns to the size needed for the loaded data. Added preference to set minimum size for a column when Resize Columns is performed. Save Results As... now allows you to give the file any filename extension. OpenBase relationships now show the proper value fortoMany/toOne as defined in the database. WebScript Assistant now supports generating PHP for OpenBase. WebScript Assistant properly disables languages not supported for the current database type. WebScript Assistant Form Input template had a number of bugs fixed. WebScript Assistant now automatically matches form fields and columns that have the same names. Query Editor and parser now support "is null" and "is not null" where conditions. Query Editor text mode updates syntax coloring and button state as changes are made. Contacting Us ------------- For more information about MacSQL, please visit our website at or email info@rtlabs.com. Registered users are entitled to free email technical support via the email address and phone number emailed to you when you purchased the software.