MacSQL Framework Read Me The MacSQL Framework provides SQL database support to Cocoa and AppleScript Studio applications. The disk image includes an installer, Developer's Guide, examples, and Objective-C API documentation. The installer installs the MacSQL framework, IB palette, Xcode plugin & templates, and FreeTDS framework (for MS SQL Server support). If you have any questions or comments, email support@rtlabs.com. Release Notes ------------- 1.1.1 Fixed installer bug where wrong Xcode plugin was installed on Tiger. RTResultListSource exposes queryString binding in Interface Builder. New Connection Dialog widened, cleaned-up. 1.1 Universal release. The only plugins supported on Intel-based Macintoshes are MySQL 4.1+, PostgreSQL 8, FrontBase, and SQL Server. OpenBase, Oracle, and Sybase currently do not have Universal drivers available. Requires Mac OS X 10.3.9 or greater. Built with gcc 4. New plugin for PostgreSQL 8 or greater added. RTQueryDataSource and RTResultListSource are key-value observing compliant so they can be used with Cocoa bindings. RTResultListSource now has keys of resultDisplayTitles and resultValues that can be bound to the content and contentValues bindings of NSPopUpButton. However, you must still bind the popUp outlet if you plan to call valueOfSelectedItem, selectItemWithValue:, or displayedItemForValue:. The RTSQLDatabase protocol now includes a tableNames method to return an array of table names. This is useful with Cocoa bindings because key-value coding for "tables.names" could return strange results if a table had a column named "name". MySQL 4.1+ plugin now supports specifying the path to a unix socket as the host name. The path must begin with a slash ('/'). The port value is ignored. New examples added showing how to use Cocoa bindings with the MacSQL framework. 1.0.3 MySQL 4.1+ plugin looks for a unix socket at /var/mysql/mysql.sock in addition to the default location (this is where it is located on Mac OS X Server 10.4). Xcode templates now correctly compile in Deployment build configuration. MySQL plugin now sets charset to latin1 instead of using server default. To reverse this behavior, in your main.m add the statement setenv("MACSQL_MYSQL_NOSET_CHARSET", "1", 1); RTRowEditor supports connecting NSDatePicker to date, time, and datetime columns. 1.0.2 Fixed minor Tiger incompatibilities. New plugin for MySQL 4.1 or greater included. "sql data sources of application" now includes RTResultListSource and RTEditableDataSource instances. PostgreSQL timestamps on server version 7.3 or greater now work properly. Includes separate templates for Xcode 2.x that offer an .sdef file instead of an .asdictionary file to view the framework's AppleScript dictionary. RTQueryDataSource no longer causes a crash if no query string has been specified. No longer prevents double clicking a project file from working on Xcode 2.1. 1.0.1 IB palettes for RTQueryDataSource and RTResultListSource no longer revert the query string when user switches to another application. RTSQLResultSet now has method indexOfColumnNamed: RTSQLRow now has method insertedRow that returns YES if that row has not been inserted in the database yet. RTSQLRow now has method setValueForInsert:atIndex: to set values for rows that return YES for insertedRow. Raises exception otherwise. RTEditableDataSource no longer reports an error when deleting a row that was inserted but not saved. RTRowNavigator nows shows "0 of 0" instead of "1 of 0" when there are no rows in the current result set. RTRowEditor will log a warning if a column is associated with an NSMatrix that has multiple cells with the same tag. MacSQLFactory has methods to get/set the format string used when converting date and time values to strings. Escape for sql literal AppleScript command works properly Sql data source object now makes available the result set, rows used (which aren't necessarily in the same order as the result set), and associated table view. Do query command now has optional parameter to supply the database to query. Defaults to the one specified in connect parameters, then a plugin provided database (such as dbo for SQL Server), then to the first database. 1.0 Initial release Contacting Us ------------- For more information about the MacSQL Framework, please visit our website at or email info@rtlabs.com. Registered users are entitled to free email and telephone technical support.