aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableStructure.m
Commit message (Collapse)AuthorAgeFilesLines
* New add index sheet, which includes:stuconnolly2010-09-171-0/+3
| | | | | | | | | - The ability to easily index multiple columns - The ability to specify the storage type (HASH or BTREE) that should be used when available and permitted - The ability to specify a length prefix when indexing a specific column (required on TEXT columns) Requires lots of testing.
* - Consolidate structure and content row editing cancellation code into a ↵rowanbeentje2010-09-161-24/+23
| | | | | | | | | | single function in each class - Tweak NSTableView subclasses to catch presses of the Escape key and ask the class to abort row editing. This makes Esc key behaviour much more consistent, and allows cancelling/reverting edits made via the mouse (eg checkboxes, dropdowns, enums), or after the cell editing has finished but the row is still selected. - Remove debug - Update localisable strings
* • fixed issue for showing the optimized field type; it can return NULL; if ↵Bibiko2010-09-131-2/+2
| | | | so display nothing found message
* • added to Structure source table's context menu item: "Show optimized ↵Bibiko2010-09-121-0/+49
| | | | field type" which will come up with a suggested field type calculated by PROCEDURE ANALYSE(0,8192)
* • SPTableStructureBibiko2010-09-101-1/+1
| | | | - fixed bug for renaming a field name (issue 808)
* • TableStructureBibiko2010-09-101-4/+4
| | | | - fixed monoSpacedFont for index table refresh and setting
* • TableStructureBibiko2010-09-101-160/+113
| | | | | | | | - added basic field type and argument validations like unsigned should not be used for string types, etc. - added field types DEC, FIXED, NUMERIC for validation - simplified addRowToDb code to avoid double-coding - after removing a field preserve the focus on the source table for keyboard navigation - minor code improvements
* • TableStructureBibiko2010-09-101-85/+189
| | | | | | | - added support for field types SERIAL and BOOL(EAN) - added extra setting and support for SERIAL DEFAULT VALUE - fixed several string comparisons based on user input, ie trim it and compare it upper or lower cased resp. - if adding or changing of a field fails display the SQL statement which caused the error in the error sheet for better debugging
* • TableStructureBibiko2010-09-101-17/+89
| | | | | | - moved field type suggestions for combobox as data source to SPTableStructure - applied type combobox lowercased completion while typing - improved DEFAULT handling for any numeric, date, time fields if DEFAULT was set to an empty string '' - if so skip it to avoid unnecessary error messages
* • for Structure editing: try to save a row being edited _before_ the row ↵Bibiko2010-09-091-0/+7
| | | | selection will change - mainly if user changes something via mouse event on comboboxes or popupbuttons; if saving fails suppress the new row selection
* • Structure editingBibiko2010-09-091-46/+73
| | | | | | | - fixed issue while drag&drop an auto_inc field > ignore DEFAULT - fixed several keyboard navigation issues - further code improvements - fixed encoding editing
* • StructureBibiko2010-09-091-0/+8
| | | | - reset collation if encoding was changed
* • [SPDatabase getDatabaseCollationsForEncoding:] now uses a cache to ↵Bibiko2010-09-091-2/+19
| | | | | | | | reduce the querying of info_schema - this fixes the querying of each reloadData in [SPTableStructure objectValueFor:] • autoreleased mutableCopy in [SPTableStructure loadTable] • fixed drag&drop query in SPTableStructure to copy charset and collation as well
* • TableStructureBibiko2010-09-091-342/+377
| | | | | | | - changed: field information are retrieved via [SPTableData columns]; mainly to get all infos like comment, encoding, and collation - added the chance to edit encoding, collation, and comment for each field Note: This is work is progress - not yet optimized but fully workable. Due to GUI I simply added these three columns - improvements will follow
* • overall replacement of:Bibiko2010-08-201-12/+12
| | | | | | | | | [aString appendString:[NSString stringWithFormat:]] by [aString appendFormat:] since it's much more faster • first look at loop where several [aStr appendString:] occur to try to combine them into one appendString or appendFormat since the allocation of memory takes really time Note: I tested all my changes but we should test it further to be sure that I didn't a mistake!
* Tweak structure view index collapsing:rowanbeentje2010-07-171-2/+19
| | | | | | | - Make the minimum index view size a little smaller - Add a button to reveal the indexes subview when it is collapsed. This button is hidden when te index view is not collapsed. This addresses Issue #746
* When reordering a timestamp field ensure the query is correctly constructed ↵stuconnolly2010-07-021-5/+10
| | | | when it allows NULL values. Fixes issue #753. Also, improve the error message displayed when a field cannot be moved.
* • several fixes for index table in Structure viewBibiko2010-06-151-6/+4
| | | | | | | - fixed binding for removeIndexButton - moved indexTable's tableViewSelectionDidChange: delegate to SPIndexController to fix enabling/disabling of the removeIndexButton - fixed issue to blank the index table for multiple selected tables
* Split the management of a table's indexes (adding and removing) to its own ↵stuconnolly2010-06-141-429/+137
| | | | controller and XIB in preparation for the UI redesign.
* - Alter the behaviour of the return key in structure view, making it ↵rowanbeentje2010-06-121-6/+16
| | | | consistent with the Content view and triggering a row save
* - Fix incorrect non-reset after structure editing which results in an ↵rowanbeentje2010-06-091-2/+10
| | | | unchanged row, resulting in subsequent editing errors and exceptions in addRowToDb
* - Ensure start/end query notifications are sent on the main thread to avoid ↵rowanbeentje2010-06-011-4/+4
| | | | | | | the interface being updated from the wrong thread on listeners - Add a "Support Files" folder to MCPKit, containing NSNotificationAdditions to support main thread notifications from within MCPKit
* Rename TableDocument to SPDatabaseDocument.stuconnolly2010-05-281-2/+2
|
* Rename TableSource to SPTableStructure.stuconnolly2010-05-271-0/+1921
generated by cgit v1.2.3 (git 2.25.1) at 2024-12-15 09:06:07 +0000