aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableContent.m
Commit message (Collapse)AuthorAgeFilesLines
...
* • some progress on the filter table approachBibiko2010-09-271-17/+57
|
* • initial sketch approach to allow to write complex WHERE clauses by ↵Bibiko2010-09-271-212/+359
| | | | | | using a table approach - not yet activated
* Update Localizable.strings and resolve the use of multiple comments for the ↵stuconnolly2010-09-211-1/+1
| | | | same string.
* • avoid exceptions etc. if content filter clause is emptyBibiko2010-09-201-10/+22
| | | | - in addition alert the user that this clause was empty to avoid confusion of filtered result set
* • SPTableContentBibiko2010-09-201-2/+11
| | | | | | | | | | | - added at the end of [self loadTableValues] an alert if loading failed • SPContentFilterManager - removed any key bindings for hopefully getting rid of some "mutating method sent to immutable object" exceptions/crashes [1479, 1372, 1310, 295, 1227, 692, 149] - better handling of ESC to cancel the name in-cell editing in table - improved validations - some general code improvements - added/changed comments
* • SPTableContentBibiko2010-09-201-20/+32
| | | | | - avoid replacing of % by %% for user-defined content filters if no argument is required • minor commenting stuff and code cleaning
* - Prevent the table content from being filtered or pages through if a row ↵rowanbeentje2010-09-181-0/+2
| | | | is currently being edited and can't been saved cleanly. Addresses at least http://spbug.com/l/735 .
* - Remove a number of invalid [NSTableView makeFirstResponder] calls that ↵rowanbeentje2010-09-181-2/+2
| | | | | | | had crept into the source, replacing with the correct [NSWindow makeFirstResponder:NSTableView]. This fixes a number of exceptions. - Update localisable strings.
* • BIT Field Sheet Editor now can handle NULL valuesBibiko2010-09-161-0/+5
| | | | • Field Editor Sheet field name label also displays NOT NULL if set
* - Consolidate structure and content row editing cancellation code into a ↵rowanbeentje2010-09-161-55/+35
| | | | | | | | | | 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
* • some further bit field editing preparationsBibiko2010-09-151-11/+32
| | | | | | • re-enabled length checking while editing in FieldEditorSheet • FieldEditorSheet now shows field type declaration • some preparations for BINARY editing in FieldEditorSheet
* - Fix row count tracking when deleting table rows; this fixes Issue #819rowanbeentje2010-09-141-5/+5
|
* • (re?)enabled BIT field editing esp. for field types like BIT(9) or ↵Bibiko2010-09-141-1/+4
| | | | | | | BIT(63) since the old _int2bin routine didn't work because we're dealing with a char* containing bytes if BIT(>8) - also for views and CustomQuery editing • started to clean up (VAR)BINARY editing (work in progress)
* - When refreshing table content view, refresh the status information for ↵rowanbeentje2010-09-051-1/+2
| | | | | | | tables as well; this fixes caching of table row count in certain combinations of table sizes and preference values, and should fix Issue #673. - Add a missing Errors.strings localisable strings table
* - Fix incomplete argument logic when deleting multiple rows without indexes ↵rowanbeentje2010-09-051-21/+25
| | | | | | | | (now rolled into argumentForRow: for centralised logic), addressing Issue #791 - Update table row count at bottom of window when deleting rows in the content view - Update localisable strings
* - Ensure previous outstanding performSelector: requests are cancelled to ↵rowanbeentje2010-09-011-0/+4
| | | | avoid calls on released objects; this addresses http://spbug.com/l/1408, http://spbug.com/l/254 and http://spbug.com/l/781
* • fixed in field editing mode the editing of BINARY fieldsBibiko2010-08-311-3/+9
|
* - When a table content page reload loads no data, and so triggers a reload ↵rowanbeentje2010-08-301-0/+1
| | | | of the first page, the previous row count was not correctly reset, thus sometimes triggering an exception. This correctly resets the count, addressing http://spbug.com/l/558
* • further improvements for in cell editing of view data in TableContent tablesBibiko2010-08-271-133/+136
| | | | | | | - simplified code - reduced number of queries for edit status - WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well
* • further improvements for in cell editing in CustomQuery tablesBibiko2010-08-271-18/+15
| | | | | | | | - simplified code - reduced number of queries for edit status - WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well • for TableContent fixed tooltip display - note: improvements as for CustomQuery follow soon
* • fixed issue that data in views weren't editable (copy&paste typo problem)Bibiko2010-08-261-0/+1
|
* • removed onMainThread for [Content/CustomTable makeFirstResponder] to ↵Bibiko2010-08-261-9/+16
| | | | | | | | | avoid the trampoline exceptions • unified error message while cell editing • in Custom Query table cell editing errors are displayed as tooltips and added these message if edit event comes from the keyboard • fixed: check edit status in Content Tables only for views to avoid unnecessary queries • used [SPCustomQuery fieldEditStatusForRow:andColumn:] consequently to simplify code
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-251-22/+5
| | | | | | | | | | | with extended characters in MySQL identifiers (names of dbs/tables/cols): - Move encoding queries and control into MCPKit, with newly cleaned-up methods, and switch a number of locations to using the new code. - Use UTF8 connections for many identifier-based queries (selecting and listing databases, tables, stored procs, table information). This fixes selection and creation of table and database names containing extended characters, also fixing exceptions and errors. - Improve UTF8 over Latin1 to correctly set the client character set encoding as well, fixing custom queries and edits; remove custom code in SPTableContent achieving the same thing in a single location. - Fix database encoding detection routines - Update localisable strings
* • added tooltip about non-editable while keyboard navigation and trying to ↵Bibiko2010-08-251-2/+30
| | | | | | modify a cell • in Custom Query table after field editor sheet dismissing preserve the the edited field selection
* • fixed several issues for in cell editing of Custom Query tables and view ↵Bibiko2010-08-251-2/+5
| | | | | | | | data in Content tables - now each cell can be selected via keyboard navigation regardless whether it's editable or not; only if the user tries to modify it then it will be checked if it's editable or not - for speed while navigation - fixed issue for view data editing to show blobs in editor sheet if user wants to modify it - Note: still work on progress
* • outsourced control:textView:doCommandBySelector: stuff to SPCopyTable ↵Bibiko2010-08-241-148/+9
| | | | | | | | | | since we need that for Content and Custom Query table; only class specific stuff like ESC trapping will handled in the actual class • enabled in cell editing for Custom Query tables - also added spreadsheet button to Custom Query status bar • fixed ESC trapping: F5 can be used for completion • simplified [SPCopyTable keyDown:] for trapping ENTER/RETURN key • some code cosmetics
* • introduced tri-state sort order for Content and Custom Query tablesBibiko2010-08-241-9/+24
| | | | | | | - by clicking a the same table header the sort will changed to desc, asc, no sort order, desc, asc, etc. • fixed sorting issue for Custom Query table - reset sort order status before executing a new custom query • code cosmetics: reduced file size for SPCustomQuery.m
* • Content Window cell editingBibiko2010-08-241-0/+6
| | | | - If enum field is edited RETURN selects the new value instead of saving the entire row
* • fixed memory leak in [SPDataAdditions ↵Bibiko2010-08-241-205/+205
| | | | | | | | | | shortStringRepresentationUsingEncoding] after simplifying the code • fixed NSAutoreleaseNoPool(): SPMainThreadTrampoline autoreleased with no pool in place - leak while canceling a print job - call [self endTask] BEFORE [pool drain] • in SPTableContent set the focus to table after editing a cell by the field editor sheet on main thread - this could fix exception 1481 • some code cosmetics: reduced file sizes
* • Table Content editing via keyboardBibiko2010-08-231-0/+12
| | | | | - disable ↑ and ↓ for jumping the next table cell if current cell is a enum field to allow to use the arrow keys for selecting an item from the list - Note: ?\018↩ handling has to be improved here! (coming soon)
* • changed TAB and SHIFT-TAB behaviour of Content Window tableBibiko2010-08-231-29/+98
| | | | | | | - now it selects any field (if it's editable for views) regardless whether the field is a blob - if user tries to edit a blob field the field editor sheet will occur for editing • after cancellation of cell editing in the Content Window table preserve the focus on the table • minor code cosmetics for editing of data coming from a view in Content Window
* • first preparations to allow in cell editing in Custom Query (not yet ↵Bibiko2010-08-221-137/+215
| | | | | | | | | | active) • view data editing - disable add/duplicate/remove row for views - first improvements for editing navigation via keyboard - after editing avoid relaodTable instead use loadTableValues - outsourced: (NSInteger)fieldEditStatusForRow:andColumn: since it will be used for keyboard editing navigation
* • view editingBibiko2010-08-221-11/+19
| | | | - if multipleLineEditingButton is set to on or field is a blob field allow to show the field data as non-editable fieldEditorSheet if field is not editable
* • view editingBibiko2010-08-221-3/+16
| | | | | - fixed: call endTask for the current progress spinner if while editing a field the data were changed meanwhile - fixed line breaking of some long tooltips
* • implemented the editing of views in Content WindowBibiko2010-08-211-2/+272
| | | | | | - the editing is field based as for Custom Query editing - shouldEditRow checks if the clicked field can be identified unambiguously - CAUTION: This must be tested heavily before releasing!! Esp. any kind of threading issues and progress spinner stuff for slower connections
* • overall replacement of:Bibiko2010-08-201-8/+8
| | | | | | | | | [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!
* Rename CMCopyTable to SPCopyTable.stuconnolly2010-08-191-3/+3
|
* - Apply column autosizing improvements to custom query loadingrowanbeentje2010-08-161-15/+18
| | | | | | | | - Move Table Content progress tracking onto the main thread's load timer - Improve thread safety when autosizing - Improve autosize to not contrain wide columns as much in tables where all columns can be shown, or if the column is double-clicked to size. (This completes work on Issue #271 and Issue #272)
* Implement column autosizing for the Content View:rowanbeentje2010-08-121-27/+156
| | | | | | | | - Add automatic column sizing (for columns without saved widths) as part of the value loading process - Rework table updates to be timer based, for time-based and more regular updates. This improves speed and allows tables to update more consistently. This results in overall smoother table loads, faster table loads, and autosizing columns. This partially implements Issues #271 and #272. Column autosizing will likely be tweaked, and this will all also be extended to Custom Query views in a future patch.
* • remember user's last setting for "Resetting AUTO_INC" while deletion of ↵Bibiko2010-08-101-4/+8
| | | | all rows in a table
* Improve handling of BIT fields, including:stuconnolly2010-07-151-14/+19
| | | | | | | | | - Exporting BIT fields properly in SQL dumps using b'x' notation. - Properly handling editing of BIT fields in both the content and custom query results views. - Correctly display BIT fields in the content view, where binary values are zero-padded to the specified length of the field. (Note, that the new BIT handling logic has only been added to MCPKit's MCPStreamingResult and MCPResult as the latter does not keep a record of the field's length which the new functionality depends on. Needs to be discussed).
* • forgot to remove debug logsBibiko2010-06-291-2/+0
|
* • save window's vertical divider position in spf files in order to be able ↵Bibiko2010-06-291-0/+10
| | | | | | | | | to restore it • do not save tabs or a single window if connectionController is shown • added comments • added to SPTableContent method "tablesListWidth" to retrieve tablesList's view width
* Exporter enhancements, including:stuconnolly2010-06-091-0/+1
| | | | | | | | - Move the custom filename options view to a drop down view on the main exporter dialog. - Change the export data source matrix to a popup button. - Fix the export button being enabled when no tables are selected to be exported. - Various interface validation fixes.
* - Ensure SPTableInfo reloads occur on the main thread, fixing a number of ↵rowanbeentje2010-06-051-5/+5
| | | | logged exceptions for beyond-bound index accesses
* - Ensure start/end query notifications are sent on the main thread to avoid ↵rowanbeentje2010-06-011-7/+7
| | | | | | | 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-3/+3
|
* Rename TableContent to SPTableContent.stuconnolly2010-05-281-0/+3413