198 Commits

Author SHA1 Message Date
Ansgar Becker
6d34e1de35 Add a help button to the quite non-intuitive controls on the export dialog. 2015-02-23 19:59:19 +00:00
Ansgar Becker
c4b44aec18 Fix memory leak in TfrmTableTools.SaveSettings 2015-01-09 10:25:15 +00:00
Ansgar Becker
d569e23639 Add edit box + updown buttons for limiting the size of INSERT queries in bytes. See http://www.heidisql.com/forum.php?t=17345 2015-01-05 19:32:58 +00:00
Ansgar Becker
7bdcf0c414 Remove duplicates from recent file list pulldown. See http://www.heidisql.com/forum.php?t=17331 2015-01-02 17:25:30 +00:00
Ansgar Becker
3b09b79d12 Support PostgreSQL in "Find text on server" dialog 2014-04-18 18:55:23 +00:00
Ansgar Becker
78b807670d Fix forced lowercase in case sensitive search on MSSQL 2014-03-28 09:18:10 +00:00
Ansgar Becker
435b555581 Make search on server more compatible to MSSQL: Remove LOWER() call, which fails on TEXT fields and is not even required. And add an equivalent to MySQL's BINARY search. See http://www.heidisql.com/forum.php?t=14950 2014-03-28 06:02:06 +00:00
Ansgar Becker
a9708fd03f Support "Find text on server" dialog on MSSQL. See http://www.heidisql.com/forum.php?t=14950 2014-03-27 04:41:13 +00:00
Ansgar Becker
57ff806a74 Do not *store* asExportSQLOutput setting when it was a server, so the next time we have the previously selected target again. Fixes issue #3435. 2013-12-17 20:08:25 +00:00
Ansgar Becker
0d3f65f68b Use the right connection when processing tree node object. Fixes issue #3447. 2013-11-28 18:57:09 +00:00
Ansgar Becker
246c2f895a TStringList.Duplicates=dupIgnore does not seem to work as intended. Instead. check existence of item in list manually before adding a new one. Fixes multiple calls to GetDBObjects for the same database, after bulk editing. 2013-11-21 05:41:35 +00:00
Ansgar Becker
35b0c28fb3 Avoid server preselection to avoid unwanted connects. Fixes issue #3411. 2013-11-04 05:08:52 +00:00
Ansgar Becker
6e608f157e Replace out-dated code which does not compile in 64bit mode in helpers.SetWindowSizeGrip. Use a TForm descendant in the new unit "extra_controls". Code parts taken from http://www.delphigroups.info/2/4/326787.html 2013-11-01 14:54:13 +00:00
Ansgar Becker
821c6cb4db Fix various compiler warnings and notices 2013-11-01 06:17:52 +00:00
Ansgar Becker
0f2590c917 Prefer Delphi's new TZipFile class over mORMot's TZipWrite for creating zipped exports (issue #3354) 2013-10-31 20:19:22 +00:00
Ansgar Becker
5dddfd1768 ExportStream is not assigned in all types of export targets, for example "clipboard". Do not determine filename in such cases. Fixes issue #3372. 2013-10-09 04:54:34 +00:00
Ansgar Becker
5e4fdfe803 Issue #3354: Give the temporary .sql file a more unique filename, and delete it after compressing. 2013-10-07 17:07:40 +00:00
Ansgar Becker
5c1a0a6e4c Introduce compressed .sql file export. Using SynZip unit from mORMot framework. Fixes issue #3354. 2013-10-07 04:32:20 +00:00
Ansgar Becker
f3106d1dce Auto-resize 2nd/"size" column of object tree on table tools dialog early. Fixes issue #3358. 2013-10-03 15:28:16 +00:00
Ansgar Becker
3d2f56fe1a Add CHECK option "FOR UPGRADE" to maintenance dialog. Fixes issue #3279. 2013-08-21 04:22:20 +00:00
Ansgar Becker
58b2a66800 Get column names from VIEW per IS.COLUMNS, not per SHOW COLUMNS, to support MSSQL here. Fixes empty grid results for MSSQL VIEWs. See comment #46 of issue #3212. 2013-08-05 04:15:01 +00:00
Ansgar Becker
99f62c4324 Process placeholders in filename also in grid export dialog. Provide a list of valid placeholders below the recent files pulldown menu. See http://www.heidisql.com/forum.php?t=12506 2013-06-01 05:45:17 +00:00
Ansgar Becker
3569ee8d94 Do not restore previous state of checkbox options "Drop database" and "Drop tables", leave them off when calling the export sql dialog. Fixes issue #3197. 2013-05-25 05:45:25 +00:00
Ansgar Becker
6333920637 SQL export dialog: Arrange controls so translated items fit. 2013-02-18 07:04:15 +00:00
Ansgar Becker
cd75b0899d Quote db and table name in new function TDBObject.QuotedDbAndTableName, which also adds "dbo" for MS SQL inbetween. Plus, run SELECT in SQL export through ApplyLimitClause, to fix an SQL error on MS SQL. See http://www.heidisql.com/forum.php?t=11956 2013-01-19 12:43:41 +00:00
Ansgar Becker
7ddfa83ace Fix minor memory leak 2013-01-14 20:34:43 +00:00
Ansgar Becker
0d6945ebcc Remove "Created" date/time from SQL export header. Fixes issue #3083. 2013-01-14 20:33:31 +00:00
Ansgar Becker
4662ebf31e Support filename and dirname patterns in export target combobox. Fixes issue #2622. 2012-12-13 20:37:01 +00:00
Ansgar Becker
645a9f3c7f Make message strings from const.inc translatable 2012-11-29 06:15:44 +00:00
Ansgar Becker
9d8b4cd83a Make more inline strings translatable. 2012-11-28 23:27:31 +00:00
Ansgar Becker
024a1a4d5e Straighten some more translation strings 2012-11-28 05:55:05 +00:00
Ansgar Becker
80d41dcc9e Fix typos and optimize a bunch of translations. Technical stuff such as variable names and version numbers should not be subject of translations. 2012-11-27 21:26:59 +00:00
Ansgar Becker
f96288fce9 Translate string variables and literals in .pas files. TODO: translate constants. 2012-11-26 05:44:01 +00:00
Ansgar Becker
a6170ad769 Prefer SysUtils.IncludeTrailingPathDelimiter over home brown code 2012-11-10 14:43:35 +00:00
Ansgar Becker
ca1d94c87b Issue #557: Include gnugettext.pas from https://dxgettext.svn.sourceforge.net/svnroot/dxgettext/trunk/dxgettext/sample/ . And add basic code to all FormCreate events to translate their components in the future. 2012-11-10 14:28:44 +00:00
Ansgar Becker
90ab0b6cf1 Refactor logic for reading and writing application and session settings:
* Introduce TAppSettings, created in dpr file
* Implement read and write methods, and replace callers of GetRegValue and MainReg.WriteInt/... with these
* Optimize read and write methods for avoiding redundant accesses to registry
* Auto-remove stored default settings from registry to avoid registry spam
* Replace synced MainForm.pref* variables with TAppSettings.Read* calls
* Move SetLocales call to dpr file
* Move MainForm.FDirname* variables to appropriate methods in helpers.pas
* Implement TQueryHistory.Create(SessionPath), reading its items within constructor
2012-08-19 10:55:08 +00:00
Ansgar Becker
56e0d8b445 Implement session folders. Fixes issue #1228. 2012-07-27 06:54:56 +00:00
Ansgar Becker
98028e8344 Issue #1031: Fix non processed table nodes in table tools dialog, due to activated grouping in tree. See http://www.heidisql.com/forum.php?t=10883 2012-07-20 08:52:53 +00:00
Ansgar Becker
87ce4d99c7 Turn off any SQL_MODE locally, before running "SHOW CREATE db/table" queries, so there results do not use ansi quotes. Fixes issue #2619, finally. 2012-06-17 11:34:18 +00:00
Ansgar Becker
59e6e7710d Fix memory leak: ExportStream was recreated for each table in export loop 2012-06-17 11:31:33 +00:00
Ansgar Becker
f31867bd5c Revert r3976 (removal of SQL_MODE handling in export), and revert r3988. Use a IF(@OLD_XYZ IS NULL, 0, @OLD_XYZ) approach instead. This way we fix unwanted auto_increment values for "0", and foreign_key_checks are restored to its previous value instead of 0. Fixes issue #2870 and might also be related to issue #2619. 2012-06-17 10:43:26 +00:00
Ansgar Becker
5e8bf8306a Remove unused unit inclusions, detected by CNPack/Uses cleaner 2012-05-01 08:34:12 +00:00
Ansgar Becker
6703f20711 Move global LoadConnectionParams() to class function TDBConnection.ReadFromRegistry() 2012-03-26 18:34:33 +00:00
Ansgar Becker
2e6d39c401 Do not auto check all child nodes by checking parent node, when clicking "Check all tables". See http://www.heidisql.com/forum.php?t=10334 2012-03-24 22:01:27 +00:00
Ansgar Becker
156bd42291 Prevent exporting dummy VIEWs from having multiple DEFAULT CURRENT_TIMESTAMP clauses. Fixes issue #2748. 2012-02-28 22:36:25 +00:00
Ansgar Becker
af3f590723 Use one color pulldown for setting grid text colors, not one per data type. Use all TDBDatatypeCategory's here, so this introduces a separate color for floats and integers, which were "numeric" before. 2012-02-27 22:16:05 +00:00
Ansgar Becker
504aed87e6 Follow up to r4059, use Tree.CheckState[Node] also when unchecking nodes. See issue #2738. 2012-02-24 23:33:12 +00:00
Ansgar Becker
b76bd09d13 Use Tree.CheckState[Node], not Node.CheckState to fix a potential OnCheck event. Fixes issue #2738. 2012-02-24 20:14:11 +00:00
Ansgar Becker
a816787be4 Add context menu to object tree in export dialog, and add items to check all/none/bytype. See http://www.heidisql.com/forum.php?t=9844 2012-02-04 11:47:41 +00:00
Ansgar Becker
ba14143238 Export whole CREATE VIEW code, not only the VIEW body. Fixes issue #2625. 2012-02-04 06:52:21 +00:00