080e0c7c9a
MariaDB separated from MySQL for easier handling of both DBMS with regard to upcoming differences as of MySQL 8.0
2018-02-23 12:02:35 +01:00
bc1e356e26
Moved TNetType and TNetTypeGroup from dbconnection.pas to types_helpers.pas to avoid circular references in interface-uses
2018-02-23 10:57:40 +01:00
ee27ccdec7
Increase number of collations shown in drop down. Closes #90 .
2018-01-17 21:36:17 +01:00
a50c21a383
* unify context menu of various sql editors, by supporting all contained editors instead of searching for one with the name "SynMemoBody"
...
* disable actions which need to modify the contents on readonly editors
* add "save to textfile" and "un/comment" actions to the unified context menu
2017-05-18 13:10:59 +00:00
f56c34abec
Reasonably increase and unify design time dimensions of object editors to 700x500 pixels
2016-12-11 10:45:20 +00:00
8c3775fe0f
Add "Save as textfile" action, and include that in routine editor > "CREATE code" tab > context menu. Fixes issue #3486 .
2014-05-08 04:50:59 +00:00
0f7534e8a0
Move new partitions tab to the left of "Create code"
2014-03-13 18:32:43 +00:00
1366ace11c
Add a read-only tab for a potentially existing PARTITION clause of the table. Fixes issue #1692 .
2014-03-13 04:58:45 +00:00
17e4db7829
* Automatic additions by new SynEdit properties.
...
* Overtake renamed SynEdit properties
2013-10-16 18:24:01 +00:00
8ce2505f52
Set minimum height of listColumns in table editor. Works around AV mentioned in issue #3189 .
2013-06-08 05:13:07 +00:00
bd077ce413
Adjust width of various controls so they fit to the translated captions (at least in German). Related to issue #557 .
2012-12-02 09:33:41 +00:00
b93106a6fe
Update VirtualTree component to r320
2011-11-01 09:32:34 +00:00
98c872909c
Support virtual columns in MariaDB 5.2. Fixes issue #2451 .
2011-06-10 23:36:38 +00:00
98a028c4cf
Show vertical scrollbar in comment editbox
2011-04-02 06:03:15 +00:00
65148c596d
Redo r3571 - seems that was not the cause of slowness.
2011-01-11 07:01:58 +00:00
d2fdeef0fb
Revert r3571, to test if that caused slowness described in issue #2266 - of which I am unsure.
2011-01-10 22:57:49 +00:00
e2cc3482c0
Paint one icon per index in a column editor row, not only for the first key. Fixes issue #2211 .
2010-10-25 23:29:17 +00:00
6c2a100945
Implement combo box for definer in routine + view + trigger editor. Fixes issue #2189 . Some related changes here:
...
- Remove ensureValidIdentifier() and its partly uncatched exceptions. Instead, disable "OK" buttons for empty table/view/proc name.
- QuoteIdent and DeQuoteIdent now take the glue char instead of a "HasMultiSegments" boolean param, so they're more exact when "user@host" or "db.name" come in.
2010-10-12 22:13:08 +00:00
961f7f0f3f
Implement copy + paste menu items for duplicating columns across tables via SQL code. Fixes issue #1848 .
2010-08-24 20:33:01 +00:00
9c3488b457
Add context popup menu on column list which allows hiding/displaying single columns. Also fixes hidden collation column after having introduced the new zerofill column in r3441.
2010-07-17 15:10:11 +00:00
7cd1c7b0ab
Add support for ZEROFILL flag in table editor. Introduces a new checkbox column in the columns list. Fixes issue #570 .
2010-07-04 13:35:54 +00:00
e045cb3d76
Delphi 2010 has PNG + alpha channel support in TImageList, so we don't need PNGcomponents any longer.
2010-02-08 00:36:17 +00:00
fc6d4c2a48
Try to fix most DPI related glitches. Especially TFrames need a ScaleBy() call, which is done automatically on TForms. Fixes issue #1656 .
2010-02-04 23:50:47 +00:00
91d53bbbcc
Replace default value in object editors by ghosted hint text
2010-02-03 22:18:28 +00:00
97ce23ee1f
Add support for indexes using BTREE/RTREE/HASH algorithm. Make that visible in a new, 3rd column in the index tree. Fixes issue #1576 .
2010-01-22 10:21:27 +00:00
a0a1ed24c2
If the first column with the number of the column has too less width, sometimes it's not clear that the user can resize it to show its whole text. This change adds an auto-resize mechanism, which is fired after any node structure was changed. Fixes issue #1609 .
2010-01-18 08:22:18 +00:00
0d8653db6a
Override VirtualTree's incremental search event, make it case insensitive, and apply that event in FixVT to various lists and grids, which have IncrementalSearch enabled. Fixes issue #1605 .
2010-01-17 10:50:47 +00:00
8ba9fb7b77
Allow space bar to modify checkbox columns "Allow NULL" and "Unsigned". Fixes issue #1605
2010-01-17 10:20:08 +00:00
7d401ffde8
Upgrade to Delphi 2010:
...
* Removes TNT Unicode controls, which are no longer required. All VCL controls now have native Unicode support.
* Remove Delphi 11 packages, otherwise we would either need to keep TNT or break Unicode
* PngComponents update from Uwe Raabe on http://cc.embarcadero.com/Item/26127
* Adjust auto build process
* Since Delphi 2009, Strings are now UnicodeStrings, not AnsiStrings any longer. Fix a bunch of compiler errors which came along with this change.
TODO: Project should compile but give tons of compiler warnings.
2010-01-05 23:14:33 +00:00
d100a9f029
Add <Select All> and <Copy> menu items to SQL code memos. Fixes issue #1530 .
2009-12-15 00:37:54 +00:00
c75df83cfc
Work around internal Delphi problem, complaining about a "unsupported 16bit resource file" when loading this file.
2009-12-04 21:27:43 +00:00
43fe695bc1
Make SHOW KEYS FROM <selected-table> and SHOW COLUMNS FROM <selected-table> superfluous. To achieve that, move parser for SHOW CREATE TABLE string from table editor to helpers unit, where it can be called by everyone. For consistency reasons the index list in table editor is converted from a TWideStringList to a TObjectList, like both table and foreign key list. However, that results in a large diff here.
2009-12-04 21:20:06 +00:00
92bd620309
Introduce caching of collation table and table engines list in connection layer. Remove that stuff from main unit and automatically clear cached stuff on disconnection.
2009-11-22 23:42:39 +00:00
dd6759d680
Bugfix: Dragged nodes were deleted in table editor's column list and index tree.
2009-10-20 11:26:03 +00:00
6d7935ce63
Same as r2621 - remove relevant height constraints from object editors. Finally fixes issue #1348 .
2009-09-09 20:23:45 +00:00
9642425441
Add "Copy" menu item to table editor's column list.
2009-09-05 09:33:38 +00:00
be2ec499f8
Refactor internal handling of columns in table editor. Replaces the multi TStringList workaround with a more readable, object oriented approach. One minor visible effect is lightning fast initializing on very huge tables with several 100 columns. Apart from that this change should not affect any visible stuff.
2009-09-03 22:18:29 +00:00
b1aaeaaaf4
Disable foreign key editor for table engines which don't support that. Display a red hint label so the user knows what to do to enable foreign keys.
2009-08-23 21:59:57 +00:00
8e57faf265
Start editing in columns list only on exact label click. Should avoid annoyance described in issue #1305
2009-08-19 05:57:29 +00:00
6517a04eff
Implement creation and editing of foreign key constraints in a separate new tab on the table editor. Fixes issue #400 .
2009-08-16 20:32:37 +00:00
2e7022a945
Bold font for primary key columns in table editor. Icons for all key columns, similar to earlier versions of ListColumns on mainform. Feels very useful for a quick look when the index editor is mostly not active.
2009-07-29 20:50:41 +00:00
4d9d5a1ff7
Enable multi row selection in table editor's column list. Relevant functions adjusted:
...
* Add to index
* Create index
* Remove Column(s) (=> makes the "Clear columns" button superfluous)
2009-07-26 19:45:02 +00:00
e0761cedd9
Extend context menu of columns list in table editor with auto index creation/addition. Fixes issue #1269 .
2009-07-25 19:35:09 +00:00
30f84c93a6
Use mainform's status panel and progressbar to display messages instead of a separate label on the table editor.
2009-06-18 19:33:51 +00:00
8b37a0bbaa
Fix issue #1213 : table editor columns misaligned
2009-06-13 06:58:54 +00:00
c6743e087b
Fix issue #1211 : Table editor, length/set should be ignored or suppressed for datatypes which don't support that. Also, make relevant code for cell editing allowance and cell background painting more easy and less redundant.
2009-06-09 20:13:35 +00:00
3bc31db014
Split "SQL code" tab into two "ALTER code" and "CREATE code", and display both in ALTER mode for copy+paste purposes. Fixes issue #1195 .
2009-06-07 19:09:40 +00:00
20faa923bd
Revert accidental GUI changes from r2449
2009-06-07 05:39:19 +00:00
d5ff16f86e
Table editor: Enable horizontal and vertical grid lines for readability
2009-06-07 05:35:23 +00:00
63ca742b6d
Table editor: center align column captions with centered checkboxes
2009-06-07 05:31:09 +00:00
