Ansgar Becker
6809e85854
Fix two errors due to changed function declarations in recent VirtualTree update.
2015-08-08 14:50:16 +00:00
Ansgar Becker
89988119d4
PostgreSQL: Fix wrong ALTER TABLE query for modifying table comment. See http://www.heidisql.com/forum.php?t=18937
2015-08-08 14:25:27 +00:00
Ansgar Becker
b905c82c6c
Session manager: Add support for SSL cipher, and add various texthints. See http://www.heidisql.com/forum.php?t=18908
2015-07-14 14:38:50 +00:00
Ansgar Becker
f8e84b5871
Text import: Use very last value from last row, even if it's not followed by a field or line terminator. See http://www.heidisql.com/forum.php?t=18899#p18911
2015-07-14 09:48:14 +00:00
Ansgar Becker
2c75fa294e
PostgreSQL: Always keep public schema in search path, so one can use procedures from it without prefixing. See http://www.heidisql.com/forum.php?t=18581#p18905
2015-07-14 09:16:22 +00:00
Ansgar Becker
a60264b600
CSV import: Disable features supported in MySQL only, if active connection is not MySQL. See http://www.heidisql.com/forum.php?t=18899
2015-07-13 17:56:32 +00:00
Ansgar Becker
7d661df417
Fix SQL error in "Copy table" dialog, in PostgreSQL mode. Use lowercase table and column names in IS.TABLES, so PG can find them. See http://www.heidisql.com/forum.php?t=18847
2015-07-08 16:02:44 +00:00
Ansgar Becker
082368e947
Fix various selection bugs in column selection panel
2015-06-28 13:39:08 +00:00
Ansgar Becker
d02f9822b3
User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+. See http://www.heidisql.com/forum.php?t=18650
2015-06-28 10:25:29 +00:00
Ansgar Becker
ef9dffd055
Use updated URL for MariaDB Explain analyzer, and encode semicolon in URL parameter. See http://www.heidisql.com/forum.php?t=18677
2015-06-24 17:30:39 +00:00
Ansgar Becker
ba63e1477e
Show line breaks other than Windows style as normal line breaks in text editor. See http://www.heidisql.com/forum.php?t=18769
2015-06-21 14:05:21 +00:00
Ansgar Becker
5b990def8f
Prepend 'E' to escaped PostgreSQL strings. See http://www.heidisql.com/forum.php?t=18657
2015-06-18 18:21:50 +00:00
Ansgar Becker
7d3b727042
Use server time for data grid > "Insert value" menu items. See http://www.heidisql.com/forum.php?t=18717
2015-06-18 17:55:51 +00:00
Ansgar Becker
d10abe029f
Use "SET search_path TO db" instead of "SET SCHEMA db" for changing a database in PostgreSQL. See http://www.heidisql.com/forum.php?t=18581
2015-06-18 17:37:47 +00:00
Ansgar Becker
e2455e8ecc
Ensure question icon is not the first one in the application, so the exe does not use the question icon any more. See http://stackoverflow.com/questions/15564755/adding-a-res-file-to-project-replaces-the-default-icon-how-to-prevent-it
2015-06-14 13:23:49 +00:00
Ansgar Becker
fe411be351
* Display session name in caption of all message dialogs. See http://www.heidisql.com/forum.php?t=18606
...
* Add a custom icon for confirmation dialogs, with a question mark on it, so we don't have to use the "i" icon.
2015-06-14 13:13:45 +00:00
Ansgar Becker
8292e41518
Try higher ports, up to the 20 next ones, as SSH local port, when the configured one is in use. Fixes connection problems for multiple connected sessions.
...
Note: PortOpen() needs ~1 second to finish, so we cannot check thousands of other ports.
See http://www.heidisql.com/forum.php?t=18601#p18601
2015-06-14 06:53:51 +00:00
Ansgar Becker
59159c7afd
Introduce option for setting the line break style in text cells without breaks. See http://www.heidisql.com/forum.php?t=18682
2015-06-13 11:09:59 +00:00
Ansgar Becker
9368f3147c
Log debug message in helpers.ShellExec(), so we can check the url which Heidi sends to MariaDB's explain analyzer. See http://www.heidisql.com/forum.php?t=18677
2015-06-13 10:21:28 +00:00
Ansgar Becker
4e65ed8d5b
Fix wrong detection of BIT default values. See http://www.heidisql.com/forum.php?t=17862
2015-05-31 08:53:53 +00:00
Ansgar Becker
a2018b421f
MSSQL: Again, try to use some universal date/time format, by injecting a "T" between the date and the time portion. This time with a TRegExpr instead of a TDateTime object. See http://www.heidisql.com/forum.php?t=18441
2015-05-30 14:11:22 +00:00
Ansgar Becker
d7415144c1
MSSQL: Do not pass "Database=xyz" to connection string if database(s) setting contains more than one database. See http://www.heidisql.com/forum.php?t=18559
2015-05-30 08:26:31 +00:00
Ansgar Becker
57ec1bc53e
Fix column type converted to locale string format by String.ToUpper in TDBConnection.GetCreateCode - prefer String.ToUpperInvariant instead, to avoid funny characters in data types. See http://www.heidisql.com/forum.php?t=18466
2015-05-28 19:10:26 +00:00
Ansgar Becker
1c8704aab0
Strip folder path from various file settings, including plink.exe location, if it's the application directory. See http://www.heidisql.com/forum.php?t=18494
2015-05-26 11:03:23 +00:00
Ansgar Becker
0bdfa4ed18
Revert r4954 - "schema.table" does not work in data grid, but require when renaming a table. See http://www.heidisql.com/forum.php?t=18498
2015-05-25 09:54:12 +00:00
Ansgar Becker
bec7b8657b
MSSQL: Prefer "schema.table" quoting over "schema"."table". See http://www.heidisql.com/forum.php?t=18476
2015-05-22 16:37:57 +00:00
Ansgar Becker
32de8d1494
Support PostgreSQL data types cidr, inet and macaddr. Grouped in dtcText category, so the grids show the normal text editor, but without applying SUBSTR(). See http://www.heidisql.com/forum.php?t=18442
2015-05-19 05:41:07 +00:00
Ansgar Becker
3701872a3e
Introduce new data type property "LoadPart" (boolean), which says whether such columns can be loaded per SUBSTR or LEFT into the data grid. Set it to false for UUID and JSON. See http://www.heidisql.com/forum.php?t=18442
2015-05-18 19:41:47 +00:00
Ansgar Becker
92f502dc72
Add support for PostgreSQL's UUID data type. See http://www.heidisql.com/forum.php?t=18442
2015-05-16 09:17:26 +00:00
Ansgar Becker
8e5ffc8ab2
Change data type of connection thread id from int to int64, to support killing processes on long running servers. See http://www.heidisql.com/forum.php?t=18426
2015-05-14 13:31:45 +00:00
Ansgar Becker
e206d95c42
Raise connection error when local SSH port for plink is already in use. See http://www.heidisql.com/forum.php?t=18395
2015-05-11 17:51:12 +00:00
Ansgar Becker
9228488032
Finally fix the weird EAccessViolation in TCustomComboBox.KeyDown. Fixes issue #3461 . See also various forum threads, and the latest one of them: http://www.heidisql.com/forum.php?t=18325
2015-05-05 18:32:03 +00:00
Ansgar Becker
d4f6576019
Redirect links from old code hosting urls to SourceForge. Fixes issue #3689
2015-04-30 16:03:44 +00:00
Ansgar Becker
a8f6c8b023
Add support for JSON grid export format. See http://www.heidisql.com/forum.php?t=15307
2015-04-30 15:56:01 +00:00
Ansgar Becker
7ab04b5254
Periodically store portable settings file, each 60 seconds. In case of a crash, the user does not loose dialog settings and whatever was customized. See http://www.heidisql.com/forum.php?t=18144#p18243
2015-04-26 13:31:08 +00:00
Ansgar Becker
1bc2c32be3
Support dropping functions and procedures on PostgreSQL, which requires the parameters list in parentheses. See http://www.heidisql.com/forum.php?t=18198
2015-04-22 18:40:50 +00:00
Ansgar Becker
b73043f057
Use table schema only when not empty, otherwise use database name, in TAdoDBConnection.GetRowCount(). See http://www.heidisql.com/forum.php?t=15438#p18200
2015-04-22 06:01:03 +00:00
Ansgar Becker
db76b2f867
Outsource RowCount into TDBObject which calls TDBConnection.GetRowCount with a server and version specific query. Introduce SELECT COUNT(*) for MSSQL 2000.
...
See
* http://www.heidisql.com/forum.php?t=18158
* http://www.heidisql.com/forum.php?t=15438
2015-04-18 08:12:29 +00:00
Ansgar Becker
34f70eaf08
Azure support:
...
* Add text from @@VERSION value into FServerVersionUntouched so TConnectionParameters.IsAzure can see "Azure" in it.
* Do not bypass required (!) USE query when IsAzure was detected
* Display a special MS Azure icon in the tree and in the status bar
2015-04-07 16:37:31 +00:00
Ansgar Becker
f8e75b5d2e
Basic implementation of Markdown Here grid export option. See http://www.heidisql.com/forum.php?t=16483
2015-04-06 20:00:53 +00:00
Ansgar Becker
50f66662ab
Attempt to add support for MS SQL Azure, by a) passing the database name(s) into the ADO connection string, and b) bypassing the USE <dbname> query in TDBConnection.SetDatabase(). See http://www.heidisql.com/forum.php?t=17999
2015-04-04 16:56:32 +00:00
Ansgar Becker
610a9fbd10
Fix glitch in variable value editor dialog
2015-04-04 13:20:06 +00:00
Ansgar Becker
49f205693e
Phrasing enhancement: "Enable completion proposal" => "Enable autocompletion"
2015-04-03 20:00:46 +00:00
Ansgar Becker
37fdb3b224
Phrasing enhancement:
...
* "Data editing" => "Editor configuration"
* "Remember filters, sorting and column selection across sessions" => "Reuse previous configuration settings on restart"
* "Drop down values from foreign table in InnoDB rows" => "Show values in foreign key columns"
2015-04-02 17:24:34 +00:00
Ansgar Becker
819c8bdd7e
Phrasing enhancement:
...
* "Data appearance" => "Text formatting"
* "Maximum column-width..." => "Maximum column width..."
2015-04-02 17:09:09 +00:00
Ansgar Becker
104f7c84bc
Phrasing enhancement: "User fired SQL queries" => "User-generated SQL queries"
2015-04-02 17:00:05 +00:00
Ansgar Becker
a17fee70a3
Log plink.exe command line as information on SSH tunnel initialization
2015-04-02 10:17:26 +00:00
Ansgar Becker
413643f1a0
Check whether column can be null, for composing a CREATE TABLE statement. Otherwise, leave away DEFAULT clause. See http://www.heidisql.com/forum.php?t=18055
2015-04-02 10:10:26 +00:00
Ansgar Becker
4d694a511b
Translate all remaining menu items in Data > "Insert value" submenu
2015-04-02 09:54:44 +00:00
Ansgar Becker
d3f19b66f8
Add menu item to insert a GUID without braces. See http://www.heidisql.com/forum.php?t=18058
2015-04-02 09:45:28 +00:00