aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPCustomQuery.m
Commit message (Collapse)AuthorAgeFilesLines
* Rework editable row checks in views and custom query results:rowanbeentje2011-08-241-31/+21
| | | | | | | | - 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
* merged latest SP_REFACTOR changessqlprodev2011-08-021-12/+0
|
* Tidy up.stuconnolly2011-07-251-5/+13
|
* - Fix exceptions editing non-unique-keyed views or custom query results ↵rowanbeentje2011-07-101-15/+23
| | | | | | | with some kinds of binary data, fixing http://spbug.com/l/1412 . - Clean up logic and code
* - Fix exceptions seen in 0.9.9RC related to query favorites with nil query ↵rowanbeentje2011-06-201-2/+6
| | | | | | | texts (L2239) - Update localisable strings
* • changed the MySQL web search pathBibiko2011-05-201-4/+5
| | | | | - since Oracle provides the search engine we lost the chance to search for a given language and MySQL version; due to that fact we assume that the search term by itself is the name of a valid HTML file within the dev.mysql.com domain, if not it falls back to Oracle's search engine but unfortunately with the extension ".html" which leads sometimes to no hits - it's needed to find a better way
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-1/+13
|
* - When importing CSVs, or editing custom query results, set numeric fields ↵rowanbeentje2011-05-091-4/+9
| | | | to NULL instead of 0 if an empty string is entered. This matches TableContent behaviour and addresses Issue #1034.
* • send current event after displaying field editor sheet for editing table ↵Bibiko2011-05-081-0/+4
| | | | | | cells - fixes i1022
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-1/+1
|
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-15/+15
|
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-33/+29
| | | | 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-16/+16
| | | | | | - 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-18/+146
| | | | UI code from functional code
* • fixed i995 : affected rows returned -1Bibiko2011-03-071-1/+1
| | | | - due to http://dev.mysql.com/doc/refman/5.1/en/mysql-affected-rows.html mysql_affected_rows() normally returns a my_ulonglong BUT it can return -1; thus we have to check whether it is >= 0 via [mySQLConnection affectedRows] != (my_ulonglong)~0
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-071-24/+28
|
* - Fix more compiler warningsrowanbeentje2011-03-041-9/+9
|
* Fix more compiler warnings.stuconnolly2011-03-031-2/+2
|
* Fix compiler warnings.stuconnolly2011-03-011-3/+5
|
* fixed compiler warningssqlprodev2011-03-011-2/+0
|
* - 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
* • fixed issue to highlight the correct current query after undoing, i.e. ↵Bibiko2011-01-141-1/+5
| | | | | | | do not using the cache • added SP_SELECTED_TEXT_RANGE shell variable for Bundle support of scope Input Text • added 'insertText', 'setText', 'setSelectedTextRange' JavaScript functions to window.system bridge
* • fixed several issues for validation and other stuff while editing of ↵Bibiko2011-01-111-4/+5
| | | | MySQL data tables if user re-ordered columns
* • Bundle commandsBibiko2010-12-091-0/+7
| | | | - added the shell vars for edited field info as well if Field Editor sheet is used
* • Bundle CommandsBibiko2010-12-091-0/+48
| | | | | | - added shell vars SP_CURRENT_EDITED_COLUMN_NAME, SP_CURRENT_EDITED_TABLE for Input Field scoped commands if invoked from a table cell field editor - added shell var SP_TABLE_DATA_SOURCE (content or query) - fixed table row change trigger for custom query tableView
* • 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
* - Add the ability to stop animation of the task indicator, and use it to ↵rowanbeentje2010-12-051-0/+2
| | | | pause the task indicator animation when custom queries are paused and waiting for user interaction after an error
* - Show and hide the custom query info area based on whether custom query ↵rowanbeentje2010-12-041-37/+57
| | | | | | | | | | errors occurred, starting off hidden - Add "errors"/"no errors" prefix to the custom query status area - Add an import cancelled line to the import error list when stopping imports after errors - Fix custom query error highlighting by scrolling to the error - Update localisable strings
* - Rework insertCommonPrefix to insertAutocompletePlaceholder, implementing ↵rowanbeentje2010-11-301-0/+16
| | | | | | | | | a more Mac-like behaviour: insert a faded placeholder for the currently selected autocomplete item. - Update the autocomplete placeholder when the autocomplete dropdown selection is changed - Clean up methods for removing placeholders, and ensure the placeholder is always removed (fixes issues with pasting with a placeholder visible, etc) - When the Help window is closed, switch off AutoHelp - this will aid in supporting those users who accidentally switch on AutoHelp and then can't figure out how to switch it off, resulting in returning windows.
* - Right-align numeric columns in table content views and custom query resultsrowanbeentje2010-11-271-0/+7
| | | | | - Fix exceptions caused by nil SSL locations when re-saving old session files
* • Bundle EditorBibiko2010-11-191-0/+8
| | | | | | | | | | | | - fixed saving and duplicating Bundles if Bundle contains other files/folder - fixed adding a new Bundle - added gui tooltips • SPTooltip - if no location was passed and first responder isn't a textView show the tooltip at the mouse location • CopyTable - show tooltip invoked by a Bundle command always at mouse location • Content / Custom Query Table - suppress tooltip of cell content if another tooltip (mainly displayed by a Bundle) is visible [shoudl be improved since iterating through the window list isn't so good]
* • started to implement auto-completion for aliasesBibiko2010-11-041-0/+8
| | | | | - first sketch should work for 90% of all cases - fine-tuning will follow soon - this follows issue 880
* • after editing the Custom Query table remain the focus on that tableBibiko2010-11-011-1/+3
|
* • Custom and Content table in-cell editingBibiko2010-10-301-0/+16
| | | | - a possible given selection done inside the edited cell will be passed to the field editor sheet for convenience since one often forgets that the field editor sheet mode is active
* • fixed tiny issues for field editing in Content and Custom tableBibiko2010-10-301-3/+0
| | | | - note: for Custom table the re-entering into the edit mode was removed since for a slow reload it doesn't work, ie we've to look for a better way
* • after the field editor sheet was closed enter into the edit mode of the ↵Bibiko2010-10-301-2/+11
| | | | current table cell; this makes it rather convenient to navigate and edit cells via keyboard or mouse for each mode (field editor or incell); the sheet will be ordered out if user tries to modify the current cell if set or blob
* • Custom Query and Content table editingBibiko2010-10-291-3/+0
| | | | | - fixed issue for tab navigating if the table is already in the edit mode - !! FOR SAFETY reasons disabled enter/return/tab enters the edit mode !! to avoid crashes until we found a better solution due to the non-waiting field editor sheets
* • enabled Find Panel inside Field Editor Sheet's textViewBibiko2010-10-291-12/+5
| | | | | | | | - to enable Find Panel in such a NSTextView which will be displayed in a sheet one has to do the following: * [main problem is that Find Panel validates its buttons against [[NSApp mainWindow] firstResponder] == NSTextView] * subclass the NSTextView and add the methods becomeFirstResponder and resignFirstResponder which has to return YES * since the last first responder remains the first mainWindow responder status one has to set [[NSApp mainWindow] makeFirstResponder:theTextView] directly after displaying the sheet • corrected SPUserManager message in (IBAction)removeHost:
* • convert the Field Editor Sheet into a document-modal sheet, i.e. now the ↵Bibiko2010-10-291-14/+43
| | | | | | | | sheet doesn't block the entire app - fixed various layout issues - fixed some tiny memory leaks • fixed tiny memory leak in MCPStreamingResult
* Add SPDefaultPasteboardDragType constant.stuconnolly2010-10-281-3/+3
|
* • added tooltip for header cell of Content and Custom Query table ↵Bibiko2010-10-271-0/+1
| | | | | | displaying the column name and field type - fixes issue 875
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-5/+0
| | | | | | | | - Prepare for the implementation of PDF and HTML export by hiding the export options box for export types that don't need it. - Fix some spacing issues on the export dialog. - Create a new SPCategoryAdditions header that is included in the apps precompiled header, making all additions available to all classes. - Update strings files.
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|
* • fixed issue of unnecessary string escaping for importing spatial data ↵Bibiko2010-10-101-1/+1
| | | | | | via GeomFromText() • minor code cosmetics
* • enabled SRID editing of spatial fields via WKT stringBibiko2010-10-091-1/+1
| | | | | - the SRID value will be appended at the WKT string like POINT(1 1),101 which will be transformed to GeomFromText('POINT(1 1)',101) on the fly - otherwise the SRID information will be deleted after editing a geometry field
* • improved field editor sheet to support geometry fieldsBibiko2010-10-091-2/+0
| | | | | - additionally it shows the image - image can be saved as pdf if image is displayed via Save button; if text is selected the wkt string will be saved
* • enabled thumbnail images of spatial geometry fields as tooltipsBibiko2010-10-091-1/+9
| | | | - note: geometrycollection support will follow soon
* • improved issues for tooltip in Content and Custom tablesBibiko2010-10-081-8/+20
| | | | | | | - added not yet supported MCPGeometryData view - removed @try clauses, instead make usage of pthread_mutex_lock etc. approach • adjusted autodetectWidthForColumnDefinition: for SPCopyTable to calculate the width by taking the WKT string of MCPGeometryData • added SPGeometryDataView class which will be used for displaying GEOMETRY data as image (for tooltips, inside field editor sheet) [not yet implemented]
* • fixed issue for editing spatial wkt data in field editor sheetBibiko2010-10-081-1/+4
|
* • enhanced spatial supportBibiko2010-10-071-1/+6
| | | | | - 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()
generated by cgit v1.2.3 (git 2.25.1) at 2024-12-30 16:08:09 +0000