Decide for a slightly darker gray value for non-focused cells of selected nodes. Fixes issue #1757.

ListTables.OnBeforePaint is a fine place to check if db objects in active db are already cached. Also, there is no need to clear the whole cache after renaming a table. Fixes issue #1755. Fixes issue #1758.

Slightly enhance colors of selected grid cells:
* Use system default colors for highlighted cell
* Do not colorize a focused cell in a non-selected node, so it does not look as if it's selected

Fix empty table name in SELECT and following AV when hiding tabs auto selects the data tab for a millisecond. Reproducible when you have the table editor open and click a different database in the tree.

Display colored bar for table size and row count columns in ListTables, and for process time column in ListProcesses. Also, extend the preferences dialog so this color can be customized and/or disabled.

Extend "about" menu item with version string, so the session manager's system menu also shows it.

Ensure both overloaded SelectNode procs do the same with the desired node.

Code cosmetic: rename showstatus to ShowStatusMsg

Fix stuff on "Import Textfile" dialog:
* Store settings in FormDestroy instead of btnImportClick
* Restore settings in FormCreate instead of FormShow
* Turn editFilename into a TButtonedEdit, including the file browse button
* Turn SpeedButtons for column moving into a TToolbar, to remove hackish code for assigning icons
* Increase dropdown items on charset pulldown, to decrease the need to scroll.

Various AVs (e.g. after SessionConnect) caused by ListTables nodes, still bound to old TDBObject items. Fixes issue #1747.

Strip "CHARSET xyz" from routine body. Fixes issue #1744.

Slightly increase minimum dimensions of user manager dialog. Fixes issue #1746

Accidentally deleted event for previous commit

Minor: Reset highlighter's list of table names when selecting a new db and not having fetched its objects.

Internal refactoring: Directly bind TDBObject's to nodes in ListTables, instead of copying everything to an internal array structure first. Most events on ListTables have their own procedures now. Also, when selecting a database in the tree without expanding it and a query tab is selected, do not fetch objects. Could annoy some SQL writers which won't see the objects in selected db highlighted in that case. On the other hand this avoids loading objects in situations where you don't need them. For larger databases this should be really helpful, e.g. for the reporter of issue #1742.

Updater: Repost WM_CLOSE message to host application every 2 seconds. Looks like the first post sporadically gets ignored or blocked if system is busy or whatever. Fixes issue #1739.

Restore focused cell in data grid for tables which were selected before. Fixes issue #1586.

Include HTML portion when copying SQL to clipboard, so rich text applications like MS Word get highlighted SQL. Fixes issue #1740. Todo: Find out why OpenOffice Writer does not accept these HTML fragments.

Session manager bugs: When clicking "New" and the selected session has modifications, RefreshSessionList caused the new session name to disappear which then again caused AVs. Different click situations fixed here. Fixes issue #1741.

Turn filter input box into a TButtonedEdit, and add a "X" button to the right edge which clears its content.

Minor: Just process initialized nodes in DeInitializeVTNodes(). Can produce AVs otherwise on startup, and makes superfluous loops on non initialized ones.

After setting grids to multi line mode their vertical scrollbar was not updated. Fix that. Additionally, let FixVT() do what's required instead of doing that in OnInitNode respectively the "Apply" action on the preferences dialog.

Avoid AVs when index lists are in editing mode and user clicks "Remove" or "Clear" button. Fixes issue #1733.

Enable variable node height in data and query grids. Customizable as number of lines per row. Fixes issue #1082.

Missing files in r3123

Use folder/magnifier icon instead of blue folder from Crystal icon set.

Fix wrong maximum length restriction in popup text cell editor. Seems PMYSQL_FIELD._type returns wrong FIELD_TYPE_BLOB on a MEDIUMTEXT field - should be FIELD_TYPE_MEDIUM_BLOB. Also, other properties such as PMYSQL_FIELD.length and PMYSQL_FIELD.max_length return nonsense values here.

Organize controls on session manager into 3 tabs "Settings", "SSL options" and "Statistics", so less important stuff does not spam the initial screen.

Introduce a more simple strategy in data tab grid for loading data:
* Load in OnBeforePaint, if the tree's tag is set to NOTLOADED
* Load 1,000 rows in one step, up to a maximum of 100,000 rows. Both values are customizable.
* Load next chunk when user presses PageDown on the last node, or, more explicitly, when user clicks "Next rows" button
* Should fix all AVs which seem to be a timing issue with loading data on demand.
* Fixes issue #1675, fixes issue #1580, fixes issue #1721, fixes issue #1734, fixes issue #972

Old servers need TYPE instead of ENGINE in CREATE TABLE statement. Fixes issue #1732.

Do not truncate contents of column contents if it contains NUL chars. Fixes issue #1731.

Item caption for "Add to index" > [Primary Key] should always be "PRIMARY", not a custom name. Fixes issue #1726.

Remove database name from UPDATE and INSERT queries, triggered by data tab grid, making it consistent with DELETE queries. Seems that queries including the database name get ignored on replicated servers. Should have no effect in Heidi when we remove it. Fixes issue #1727.

Routine comments can have single quotes escaped by single quotes. Fixes issue #1728.

Introduce SSL support on session manager. Code parts from SuperNiFF. Fixes issue #518.

Add support for startup SQL script on session manager. Fixes issue #1716.

Don't prompt more than one time if a table, trigger etc. should be saved, after user clicked "No" and focused a different db tree node. Fixes issue #1715.

Realign most controls on SQL help dialog, sanitize them from weird paddings and margins. Remove statusbar which was just there to display the size grip in the lower right corner.

Add filter input above SQL help tree. Fixes issue #1718. New code mostly from SuperNiFF.

Add "EXPLAIN query" to context menu of process list. Fixes issue #1717.

Keep EXPLAIN link disabled if selected process is a SHOW command or even has an empty SQL. Fixes issue #1717.

Only replace updater tool in temp directory if it has become outdated. Avoids annoyance for users which have whitelisted this .exe in their antivirus or whatever software.

Fix readme file: Remove obsolete notice wrt Windows Scripting Host, add a hint for Wine/Linux usage.

Fix enabled EXPLAIN link on startup and avoid AVs on click, as long as no FocusChanged event has fired.

Try a newer client library from a 5.1.44 / 32bit server.

Parse result of SHOW CREATE PROCEDURE, instead of querying information_schema.ROUTINES, which seems broken as escaped quotes appear non-escaped here, on a 5.1.22 server. Fixes issue #1713.

The new EXPLAIN feature needs to prepend a "USE dbxyz" to the EXPLAIN, or that will only run without error if the user has selected the relevant database.

Again, increase length of fetched SQL column from 10kb to 50kb, so it's less likely that we cut important queries. Fixes issue #1714.

Tweak help menu items:
* Link issue tracker instead of separating them for bugs + features
* Rename "user to user forum" into "Support forum"
* Add "Changelog" item

Place a "EXPLAIN" link label to the process viewer, which creates a new query tab and executes "EXPLAIN [selected process query]".

Fix non working right anchors of aligned controls (mainly TEdit) on user manager dialog.

Replace remaining loadXYZwindow() functions for dialogs by a more native way.

Remove unused unit

Privilege tree doesn't repaint automatically when calling ReInitNode

Organize controls on routine editor into 3 tabs (options, parameters, create code). Fixes issue #1708.

Apply a new style to the user manager dialog:
* Use 2 VirtualTree's instead of broken TComboBoxEx pulldown's
* Enlarge the user list so all items are visible at once
* Privilege objects now use a tree style, 1st level is the objects name, 2nd level is the privilege name ("select", "update" ...)
Fixes issue #1707

Work around too few items in TComboBoxEx in higher DPI modes. Fixes issue #1707.

No more casting to TTableColumn required since we have these nice Generics

Forgot that views are so similar to tables in previous commit.

Display parameters of stored routines in "Cols" tab of query helpers when a procedure or function is selected. Fixes issue #1702.

Do not rely on the application's caption text to be "HeidiSQL x.x.x.x" when sending the WM_CLOSE message. Instead, find the exe name of the window and see if that's the one we're aiming to update. Fixes issue #1701.

Load full cell content before applying quick filters on larger text columns. Fixes issue #1703.

Avoid AV when registry value for connection port is fucked up. Fixes issue #1700.

GetParentForm() returns the parent form of a frame. So, list layouts were saved with potential naming conflicts in registry since table editor and friends are TFrame, not TForm. Solve that by implementing GetParentFormOrFrame() and add that control's name to all relevant registry names in SaveListSetup() and RestoreListSetup(). This resets everyone's favorite list layout once, using this new build, but that should not be a problem.

Save and restore layout of procedure parameter tree.

Add default length/set in parentheses when user selects a datatype for a procedure parameter. Fixes issue #1698.

For datatypes which require a length/set parameter in parentheses, we should provide a default length.

Also don't quote default values of a float type column, same as for integers.

Implement a new external updater tool, stick that updater.exe as resource to the main executable, release and run it when the user clicks "Download build xyz". The updater itself posts WM_CLOSE messages to all Heidi instances, waits until all instances are gone, and then replaces the .exe with the downloaded one, after having copied a backup file to your temp directory.

Disable horizontal scrollbar on SQL log for the benefit of having one more free line there. Seems more important than being able to scroll to the right to see the end of large sql queries.

Consistently update SQL viewer for selected process node, in "Processes" tab. Also, make it more clear if no process is selected. Fixes issue #1693.

Remove jheidi sources - it's dead.

Seems ForceDirectories does not create all subdirectories if we have two slashes between dirnames. Happens when the user appends a slash to the end of the output directory.

Silence compiler warning

Create subdirectories for each involved database in SQL export. Fixes issue #1690.

Fix broken ALTER TABLE code when dropping primary key. Fixes issue #1688.

Decrease pre calculated number of rows per INSERT, to make that safer against exceeding the popular 1MB max_allowed_packet default setting. Fixes issue #1682.

Warn user via log panel when a customized shortcut conflicts with another one. Do not crash the whole app in that case, a log message saying how to fix that should be nice enough. Fixes issue #1683.

Fix wrong PageIndex of data tab in printer implementation. Plus: Enable printing columns list on table editor. Fixes issue #1684.

Bulk table editor: No comma between charset + collation clause. Fixes issue #1685

When pressing Tab key in grids and the next column does not allow editing, just focus it, instead of jumping to the next editable cell. Fixes most situations described in issue #1677.

Ensure we have full grid cells in source row when user clicks "Duplicate row". Fixes issue #1678.

Fix old row count in data grid header when rows were deleted from outside. Fixes issue #1227.

Prefer VT.FocusedNode over VT.GetFirstSelected in various places. Clicking a node twice deselects it and subsequent actions have an access violation. Fixes issue #1674.

Delphi 2010 has PNG + alpha channel support in TImageList, so we don't need PNGcomponents any longer.

Remove unused icons

Unify color depth of icons to 32 bits per pixels.

Surround TRIGGER creation export with custom DELIMITER, so readers (including HeidiSQL itself) are able to detect query end positions. Fixes issue #1672.

Remove pink foreign key icon - we already had another one. Use that consistently in both foreign key list and columns list.

Add pink icon for foreign key columns. Fixes issue #1669.

Auto create pretty foreign key name "FK_thistable_reftable" if it was not customized yet. Fixes issue #1671.

End editing with home brown editors when the underlying tree scrolls, to avoid a misplaced cell editor. Fixes issue #1670.

Only display tables in reference table pulldown of foreign key editor. Stored procedures or triggers cannot be applied here. Fixes issue #1668.

Also quote column names when doubleclicking or dragging from a query helpers column list. Fixes issue #1666.

Same as r3053, this time for doubleclicking a tree node: Prepend database name, and use backticks. Fixes issue #1666.

Foreign key editor needs to be repainted when selecting another table. Fixes issue #1667.

Fix mysterious endless loop in user manager, after having focused the password editor once. Make use of Delphi's new TextHint property to display the old hashed password, instead of assigning and removing OnChange handlers all the time. Fixes issue #1658.

Include database name when dropping a db tree node onto a query editor. Fixes issue #1661.

Issue #1656: Upscale status bar panels in non-96-DPI mode, so text is not cut off.

Avoid desktop flickering on WinXP at the cost of minor flickering on the main tabs. Seems LockWindowUpdate() should be used with caution. Fixes issue #1659.

Fix invisible "New query tab" button, broken in r3049.

Try to fix most DPI related glitches. Especially TFrames need a ScaleBy() call, which is done automatically on TForms. Fixes issue #1656.

Do not reset remove AUTO_INCREMENT clause from CREATE TABLE when no data gets exported. Fixes issue #1110.

Introduce new log category lcUserFiredSQL, and make log level customizable via preferences. Fixes issue #1652.

Work around non working SynEdit.OnSearchNotFound event, when search text could not be found in query memo.

Force multi line hint tool tips in grids.
* Fixes issue #1649
* Fixes issue #1567

Replace default value in object editors by ghosted hint text

Fill default content of trigger body with a BEGIN END block. Fixes issue #1653.

Display ghosted hint text on combobox for database filter

Highlight matching brackets in all SQL editors. Use code from the SynEdit Demo "OnPaintTransient". Fixes issue #1630.

Cosmetic: Avoid jumping column headers when many notices go into the result log.

Fix broken r3034: "100%" was displayed in between on large tables, after each loop of 100MB loading. Fixes issue #1628.

Fix unresponsive query memo on large "replace all" actions. Also, move redundant code to DoSearchReplace.

After selecting a valid export filename, the export button should be active. Fixes issue #1641.

When foreign key tab is active with a MyISAM table, switching to a InnoDB table did not activate the controls. Fixes issue #1642.

Implement a home brown find + replace dialog, supporting regular expressions, and using all stuff SynEdit gives us. Add main menu item "Search" next to "Edit". Fixes issue #1069.

Don't use the calculated percentage of processed row count after exporting each table. Just display a hard coded "100%" so InnoDB tables display the right percentage (at least when table data is at eof). Fixes issue #1628.

If the specified filename in SQL export dialog is empty, disable the execute button. If the file cannot be created for some reason, do not pop up a message dialog. Instead, log the error message into the result list. Fixes issue #1627.

Fix missing and partly wrong search paths in project files for "release" configuration

Automatic dfm changes by IDE: Removed ComboBox.ItemHeight property and auto-adjusted dimensions of various buttons and other controls.

Silence compiler warning

Preparations for upcoming major release

Add a toolbar button which, when pressed, allows BLOBs to be displayed as text. Explicitly ignoring weird effects in grid updates/inserts. Fixes issue #1624.

Update VirtualTreeView sources to revision 250.

Suppress access violation caused by VCL bug. Fixes issue #1622.

Update readme.txt: Add documentation on command line switches, adjust wording in general, fix wrong infos.

Remove workaround from r2338 - no need to force the taskbar button active now that the "Retry connection" logic was removed. Could probably fix issue #1622.

Minor code simplification, old TNT StringList workaround.

Enhance command line processing:
* Rewrite parameter parser
* Remove support for "-C" option (compressed). Anyway switched on by default.
* Add support for loading multiple SQL files at once instead of only one: "fileA.sql fileB.sql ..."
* Also process connection parameters when "Allow multiple application instances" is disabled
* If a session name is specified with -dXYZ, load params from registry, but allow the user to override these by passing e.g. a different user name "-uOtherUser"
Fixes issue #1332.

Work around a possible timing issue, when the db tree is painted with more nodes than the database has objects. Guess that occurs on a reconnection. Fixes issue #1621.

Minor code simplification

Remove TMySQLConnection.Capabilities , which should have brought some light into the feature set of the server. Still doing that per version comparison which is nice enough.

Add preference option to restrict number of application instances to 1. If the executable is open and called a second time, it's brought to foreground. Plus, if a filename was passed, a new tab is opened. Should fix a part of what is described in issue #1332.

Code cosmetic: Remove dead code, and bring some variables into the right order

Fine tune main package file, so we don't accidentally set weird things like "Typed @ operator" and more.

Add support for indexes using BTREE/RTREE/HASH algorithm. Make that visible in a new, 3rd column in the index tree. Fixes issue #1576.

Don't quote numeric values in grid export as SQL. See: http://www.heidisql.com/forum.php?t=4885

Update readme files, now that a few packages were removed.

SizeOf(AnsiStrings) returns 4, the size of a 32 bit pointer, not the number of bytes which one char takes. Fix that. Also, stabilize text copying to clipboard by just using Clipboard.AsText. Fixes issue #1614.

Convert MySQL date/time values more safely against 0-dates. Fixes issue #1613

Columns of selected datagrid object can also come from a view, so ParseTableStructure is not sufficient in both data sorting and column selection forms. Instead, just use mainform's lists which are exactly what we need. Fixes issue #1611.

Wording: Users know the differences between INSERT/REPLACE/DELETE+INSERT . Say it more clearly in the selection box what gets generated.

Do not generate "_binary 0x" for empty blobs. Fixes issue #1610.

Add formatted HTML to clipboard for "Copy rows as HTML". Fixes issue #1249

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.

Save a loop for finding the right tree node in topic browser, when the user already clicked the relevant item. Fixes wrong item selection when item text exists twice or more often (e.g. "SHOW PLUGINS") Fixes issue #1575.

Disable non working column default values for given data type. Fixes issue #1519.

If user disables "Allow NULL" for some column which has NULL as default value, silently change that default value to "No default", instead of "Custom text". Additionally, this fixes the default text "NULL" as literal in such cases.

Do not pass <Enter> key to parent grid, if radio button or checkbox on default editor is currently focused. Fixes issue #1605.

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.