aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableContent.m
Commit message (Collapse)AuthorAgeFilesLines
* - Require there to be at least 50 rows to be in the table before using the ↵rowanbeentje2011-09-071-1/+1
| | | | "DELETE FROM foo" remove all rows code path. This improves the chance that the user actually intends to delete all the rows in the table, addressing Issue #1166.
* Tidy up console/query controller.stuconnolly2011-09-031-0/+1
|
* Tidy up.stuconnolly2011-08-271-0/+8
|
* * Fixes some strings that were not really localizable the way they were ↵dmoagx2011-08-261-11/+21
| | | | constructed.
* Rework editable row checks in views and custom query results:rowanbeentje2011-08-241-28/+23
| | | | | | | | - Only include columns from the same database, even if they share the same table name - If a primary key was found that can be checked, use all the columns specified in the primary key - Correctly escape and format values in primary key columns - Clean up logic and string generation
* Tidy up.stuconnolly2011-08-131-20/+22
|
* Re-add default new table's id field to AUTO_INCREMENT added in r3331, but ↵stuconnolly2011-08-121-36/+43
| | | | knocked out in r3376.
* merged latest SP_REFACTOR changessqlprodev2011-08-021-0/+2
|
* Fix for NULL values in CSV export (same as last commit, but this one ↵stuconnolly2011-07-241-14/+36
| | | | actually works).
* - Fix exceptions editing non-unique-keyed views or custom query results ↵rowanbeentje2011-07-101-14/+18
| | | | | | | with some kinds of binary data, fixing http://spbug.com/l/1412 . - Clean up logic and code
* • re-fixed ignoring first character event for editing sheetBibiko2011-06-191-0/+4
| | | | - it was accidentally deleted in r3309
* - Add support for use of table relation "link" arrows on binary/blob data, ↵rowanbeentje2011-06-121-2/+7
| | | | fixing exceptions (eg log 3321)
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-42/+178
|
* Fix bug introduced in the previous commit.stuconnolly2011-05-101-1/+0
|
* During a table data refresh within SPTableContent's loadTable: remember to ↵stuconnolly2011-05-101-2/+4
| | | | ensure that endTask is called before bailing in the event of error occurring (e.g. corrupt table) in order to re-enable various interface controls. Fixes issue #1046.
* • send current event after displaying field editor sheet for editing table ↵Bibiko2011-05-081-0/+4
| | | | | | cells - fixes i1022
* Add an 'Add New Row' menu item to the table content context menu. Completes ↵stuconnolly2011-05-071-4/+11
| | | | the implementation of issue #939.
* Small tidy up, mainly the addition of constants.stuconnolly2011-05-051-1/+3
|
* • improve BIT field type supportBibiko2011-05-051-1/+5
| | | | | | | | - caught some more exceptional cases - re-factored byte to bit conversion (really do not know why the old code wasn't working anymore); this should fix i1042 - disabled unisgned/zerofill check boxes in Structure for BIT - insert correct default BIT field default value if any after adding a new row -- this works for 5.5 but for MySQL 5.0.x it seems that providing a default value is a MySQL bug (further checks are needed)
* * Allow table names to be sorted in lists via "AlphabeticalTableSorting" ↵dmoagx2011-04-291-8/+6
| | | | | | hidden pref key * Change some [[NSPopupButton selectedItem] title] to [NSPopupButton titleOfSelectedItem]
* - Add the ability to double-click in empty areas of the main tableviews to ↵rowanbeentje2011-04-251-0/+6
| | | | add new rows/records
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-3/+3
|
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-18/+18
|
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-182/+61
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* Make some minor changes after reviewing r3271:rowanbeentje2011-04-141-40/+40
| | | | | | - Fix a few encoding issues - Recode a few [NSApp keyWindow] uses back to [SPDatabaseDocument parentWindow] following discussion; possibly for later refactoring into use of an error method
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-108/+376
| | | | UI code from functional code
* - Fix more warningsrowanbeentje2011-03-141-1/+1
|
* • fixed bug if user invokes undo on a NSSearchField in the ContentViewBibiko2011-03-081-2/+5
| | | | | - fixes i996 - discussion: why do we need [NSWindow endEditingFor:] ??
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-071-56/+64
|
* Fix more compiler warnings.stuconnolly2011-03-041-16/+20
|
* fixed compiler warningssqlprodev2011-03-011-1/+8
|
* fixed compiler warningssqlprodev2011-03-011-4/+0
|
* - Improve filter dropdown comparison memory to no longer override filters ↵rowanbeentje2011-02-231-3/+6
| | | | to restore for foreighn keys/history navigation, improving on r3193
* - When loading tables, ensure that the column count is updated before table ↵rowanbeentje2011-02-151-3/+4
| | | | timers are set up. This prevents accesses of SPTableStorages while column change realloc/dealloc processes are still running, fixing exceptions on large tables
* - When changing column selections in the filter dropdowns, preserve the ↵rowanbeentje2011-02-141-0/+7
| | | | filter comparison type if possible
* • show in Content tables' header comments and ENUM/SET valuesBibiko2011-02-111-17/+25
| | | | | | - addresses i977 • suppress editing of ENUM/SET fields in Field Editor sheet since it doesn't make sense yet • corrected method tableView:toolTipForCell: since aCell can be a NSComboCell
* - Improve thread safety when loading content views, improving Issue #953rowanbeentje2011-01-291-4/+5
|
* • fixed exception for printing Content table if it contains GEOMETRY dataBibiko2011-01-281-2/+23
|
* • fixed minor issue for filterTable approach in ContentBibiko2011-01-241-2/+24
| | | | - prepared some stuff for table state history
* - Fix problems correctly resetting state when a query affects no rows on ↵rowanbeentje2011-01-141-2/+11
| | | | | | | creating new tables; this could be responsible for -release errors in SPDataStorage, as well as out-of-bounds errors in SPDataStorage or SPTableContent. - Fix incorrect reporting of affected rows in MCPKit due to the use of meta/status queries; only track affected rows for framework-usage queries (already largely implemented in previous revisions)
* • fixed several issues for validation and other stuff while editing of ↵Bibiko2011-01-111-3/+12
| | | | MySQL data tables if user re-ordered columns
* - Fix default population for NOT NULL numeric fields when adding rowsrowanbeentje2011-01-111-3/+11
| | | | | - When saving rows, convert empty strings for NOT NULL numeric fields to 0 rather than NULL to prevent errors
* - Fix split view overlap on the custom query view cuasing lines on ↵rowanbeentje2010-12-211-0/+29
| | | | | | | | | | scrolling/resize; this addresses Issue #929 - Fix split view overlap on the tables list/info pane causing lines on scrolling/resize; this addresses Issue #740 - Add custom resize behaviour for the table content splitview, addressing Issue #543 - Make button bars at the bottom of the window a consistent height - Fix bug with new splitview setup causing tables pane to become narrower with each launch
* - Remove the CURRENT_TIMESTAMP workaround when saving rows as r3013 removes ↵rowanbeentje2010-12-131-17/+8
| | | | the need for it; this also improves speed slightly as non-changed rows can be skipped much earlier
* - When saving rows in the table content view, only include those fields ↵rowanbeentje2010-12-131-73/+82
| | | | | | | | which have altered values in the UPDATE query, improving speed and reducing the chance of issues when copying queries or altering rapidly changing tables. This addresses Issue #527; thanks to Tobias Mollstam for contributing a patch which prompted this update. - Rename SPTableContent's "addRowToDB" to "saveRowToTable" for clarity, and clean up the code for speed and clarity - Correctly save numeric fields as NULL if the value is blanked
* • Bundle commandsBibiko2010-12-091-1/+5
| | | | - added the shell vars for edited field info as well if Field Editor sheet is used
* • Bundle command supportBibiko2010-12-071-0/+8
| | | | | - fixed issue for commands without assigning a key equivalent - output table meta data about type, type grouping, length, auto_inc, PRI key etc. for Data Table scope commands and sequelpro url scheme command ExecuteQuery
* - Fix maximum table row resetting, which caused a bug when reloading a ↵rowanbeentje2010-12-021-0/+4
| | | | table with a saved page number when previously on a table with no rows. This addresses Issue #912.
* • Bundle CommandsBibiko2010-12-011-9/+27
| | | | | - make sure that each HTML output window will be released - if a triggered command will outputs its result in an HTML window invoke it only if the HTML output window is already open; this enables the user to "switch on/off" such a trigger
* • Bundle Editor / Bundle commandsBibiko2010-12-011-0/+20
| | | | | | | - enabled trigger support to run a command if db, table, or table row was changed - HTML output window will be ordered out without making it the key window to remain the first responder • SPTableTExtFieldCell - forgotten to remove expansionFrameWithFrame: method