aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableContent.m
Commit message (Collapse)AuthorAgeFilesLines
* • spatial field supportBibiko2010-10-071-1/+1
| | | | | - fixed issue while editing geometry data in Content View; once a geometry field was edited it will be stored as NSString, if not it keeps a MCPGeometryData - some code cosmetics and commenting
* • enhanced spatial supportBibiko2010-10-071-5/+10
| | | | | - implemented native routine to immediate AsText() [MULTIPOLYGON and GEOMETRYCOLLECTION are not yet ready] - enabled editing of spatial data in Content View for tables and views and in Custom Query via wkt strings which will be saved automatically as wkb by using GeomFromText()
* • removed approach to query spatial data by using AsText() since it breaks ↵Bibiko2010-10-071-29/+16
| | | | | | | some column definition approaches - instead introduced a new MCPKit class MCPGeometryData - up to now the spatial data will be displayed as hex bytes - work on it will come soon
* • added basic support for spatial dataBibiko2010-10-011-8/+30
| | | | | | - while querying and writing back make usage of AsText() and GeomFromText() to allow to edit each GEOMETRY field as text simple string - works only in Content Tab so far - the spatial data are not yet editable inside views
* • some further work on Filter TableBibiko2010-10-011-4/+31
|
* • some very minor code, commenting, and tiny speed improvement stuffBibiko2010-09-301-23/+51
|
* • Filter TableBibiko2010-09-291-3/+8
| | | | | - minor GUI improvements - try to fix issue 1654
* • Filter TableBibiko2010-09-291-1/+4
| | | | - improved operator parsing for >= <= <> ≠ ≤ ≥
* • Filter Table - Set Default OperatorBibiko2010-09-291-11/+86
| | | | - added the chance to define the unmarked default operator
* • Filter TableBibiko2010-09-291-0/+10
| | | | | - fixed thread issue while loading a new table - fixed DBView.xib warnings
* • Filter TableBibiko2010-09-291-20/+83
| | | | | | | - added "Search while Typing" - added some keyboard short-cuts - fixed some minor issues - Filter Table is now a normal NSWindow
* • enabled Filter Table approach (Content View > ⌘F) for testingBibiko2010-09-281-11/+47
|
* • some progress on the filter table approachBibiko2010-09-281-5/+63
|
* - Fix missing tableContentView references, which are required following the ↵rowanbeentje2010-09-271-26/+18
| | | | | | | content filter changes. This addresses http://spbug.com/l/1648 . - Clean up code a little
* • 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!