Download HeidiSQL

Fix sstr() to return the exact wanted length instead of length + 1

Fix access violation on actived grid editors (enum, date, set) when the grid got reloaded. Fixes bug #893 and bug #883.

Fix bug #891: Wrong view loaded into view editor

Fix invisible items in SET column editor. Fixes bug #884.

fix gui methods which do not work on jdk 1.5

Activate new inplace editor again for numeric and other columns, but with hidden edit button. Enables tabbing feature for datatypes where we don't provide a special editor.

Replace TMemos by TSynMemos in SQL help window and add URI openers. Enables linked URIs in text.

Add fitting icon and hint text to inplace editor button.

Do not use the new inplace editor for numeric columns, instead use VT's default editor again.

Fulfill rfe #887 : Do not close connection dialog on connection error

fix NPE in worker

Add locking to get rid of orphaned progress bar

update for a3.6

Fix bug #875 : Table creation form create the table hitting enter when create button is enabled

Fix inconsistent window and button captions (bug #864)

Fix bug #876 : Incorrect database name ''

fix more unquoted strings

dont process unneeded events

parent message boxes correctly on multiple monitors systems

finally get rid of console scrolling bug

move waitoperation string into the worker

remove slow simulation

decrease class load times slightly

make tree init a worker

remove unused file

fix typo

change refresh to use new worker stuff

remove slow simulation again

dont run detector if worker is cancelled immediately

refactor workers to get rid of anon-inners and make workers smarter

make devmode only compile when necessary

set reaper as daemon thread

fix duplicate worker invocations

comment out slow motion simulation

fix sql logging db

fix cache not flushing on refresh

fix classpath

sadly handle race condition

diff said there was a diff show checking in

fix longrunning task detector interrupts

remove file

make table tab data load asynch in case of long running op

handle case where worker is already running

add handling for lazy updates and cancelation

update lib with new status bar code

Put all execution in try block so that stop button will be reset in case of unsucessful connection

get rid of ununsed condition

various lib enhancements

dont flush the cache on refresh if the user is just refreshing the processes tab

fix bogus args passed to worker

Second attempt to fix bug #868: during login heidi crashes

Attempt to fix issue #845.

Try a safe-fix on a suspicious line which could cause bug #868 (during login heidi crashes)

fix bogus worker cancellation

update ajl lib

add on cancel to kill statement

get rid of blank pixel

add ability to cancel JDBC statement on user queries not just the swing
worker

fix conn cleanup

fix file ext

fix comment

update binary

src for mutex exe

update version

only create mutex on first invocation

update ajl.jar

use unix zip to keep perms

add chmods for linux builds

update for alpha 3.5

prepare for MySQL 5.1 bugs

Make nsis launcher parent to java.exe

Fix rfe #850 : Column Add/Edit Dialog - Default Setting "Custom string ..." misleading for Numeric fields

Fix bug #852 : user manager delete/add object. The privilege enumeration relies on Combo.ItemIndex being the correct priv number which didn't work for privs which were marked as "deleted" and therefore hidden. Deleted access objects are now kept in the object pulldown and marked with a "deleted" icon plus a text postfix " (deleted)".

Fix bug #836 "no default value" dialog pops up twice

latest autoupdater

change highlite color

fix compile errors

cache enhancements

remove unused script

exclude user queries from caching

make refresh button flush DB cache

remove outdated comment

fix startup state of toolbar buttons

remove sysout

Remove icons from query helper tabs. They steel needed width from the query memo.

Fix bug #846: Copy to clipboard doesn't copy the entire field contents

Try a clear yellow for selected but unfocused cells in datagrid

Oops, forgot to expand array. See r1905.

Fix bug #828: AV after switching back to data tab when it had unsaved changed

Enhance error message for cases in which a grid cell change is silently back converted to the original value by the server. Fixes issue #818: Silent data conversion leads to misleading error message.

Accept negative sign before floats in FloatStr(), fixes bug #826

Implement rfe #816: wrong font in SQL log and query tab line numbers

Fix bug #817 : cannot see anything in the field editor; color is white on white background

Beautify installer image, add "4" and MySQL logo

Rename "View" to "Perspective" in GUI controls and apply a more specific icon to the relevant toolbutton.

Switch from yellow selected but unfocused cells to light blue background + black foreground. Hopefully fits somehow with most customized system colors.

Only draw the focused grid cell using highlight fg/bg colors if multiple rows are selected.

* Split the readme in two.
* Add section 'Upgrading third-party packages'.
* Add section 'Finding the source line from a memory address'.

Automatic change after recent SynEdit update.

Fix bug #751 exporting a table: table is not marked in the export dialog

Ensure visibility of the just selected table in dbtree, for cases in which the table was autoselected via ListTables.DoubleClick or arrow_up/down within tree.

Find a better place for autosizing the second dbtree column. Fixes the column content from being cut at startup after loading the previously selected database. (Totally minor + cosmetic)

Fix bug #791 missing background color on selected rows. Switches to full row selecting if more than one node was selected.

Fix bug #813 primary key checkbox gets copied to other fields

remove 3 second test delay

update ajl jar

make show table status asynch

Silence unhelpful 'Check what must be adapted' (?) messages from SynEdit developers to SynEdit developers.

Fix AV mentioned in issue #801 AV on "Set NULL" with no focused row in datagrid

Usability enhancement: Colorize any unfocused cell in a focused row with clInfoBk (mostly light yellow). Helps with identifying the focused row.

Fix bug #801 Set NULL cause Access Violation Error

Fix unfocused grid on the second arrow_down, broken in r1871

Fix bug #795 : AV when inserting two rows.
Could be more pretty as the second arrow_down unfocusses the grid somehow and no new row is appended. Anyway, cosmetic now.

Property changes by SynEdit update. Fixes an IDE error while loading options.dfm .

Remove a remainder of pre Delphi 11 support

Update UniSynEdit to latest version from October 3, 2008 (no repository available unfortunately)
* Merge with heidi related changes (basically only SingleLineMode)
* Readd missing file changelog.htm to keep that file list consistent with the downloaded one
* Merge our own compiler detection again
* Disable including a further compiler includefile jedi.inc

Fix compiler error by accidently deleted line in previous commit.

fix broken classpath

Fix bug #799 default value '' of a field changed to '''' when field name changed

Fix bug #798: unable to change the case of a fieldname in the create table dialog

fix incorrect filename

update relnotes

add startEDT in the launch script

Fix imports for Stack

add restartCommand

Work around bug #794: OK + Apply buttons enabled after just switching to a different tab
The bug seems caused by any TUpDown + TEdit which fire OnChange when they get visible for the first time. PageControl.OnChanging + .OnChange help here.

* Bugfix: where clauses can contain Unicode characters.
* Bugfix: don't add cell data for a row which were not found by the server.
* Bugfix: pop up a dialog if an INSERT or UPDATE unexpectedly failed.

Fixes issue #456.

Fix bug #783 AV after while inserting record

Bugfix (regression): the value '-' was handled incorrectly when scanning for values looking like floating point stuff.

Fix bug #332 "index manager: column names unreadable" by making the form resizable, including fixes for the side by side listboxes.

Fix redundant "SHOW KEYS FROM xyz" when calling the field editor. Was duplicated since r1843. Now the field editor benefits in two places from Childwin.FSelectedTableKeys

Fix bug #784 Cant add field without default value

Enable customizing SQL colors for identifiers, delimited identifiers, conditional comments and symbols.

Workaround: reclaim used memory when TVirtualTree crashes in allocation of child nodes. The correct fix would be to postpone creation of child nodes until they are actually needed (dynamic allocation), but I'm not in a mood to learn how TVirtualTree internals work and Mike didn't seem too eager to produce a fix, so this is it for now. Fixes issue #761.

Preferences dialog, SQL tab, enhancing color coding and font selection:
* Remove sub tabs
* Replace the color panels by a combobox showing which item is to be changed and a color combo box.
* Add a SynMemo, displaying color and font changes immediately using some sample SQL text.

Cosmetic face-lift on preferences dialog:
* Normalize component names
* Apply and use modal results to OK and Cancel buttons
* Fix apply button to be enabled after changing NULL color
* Fix all tab orders
* Fix cut labels on Vista
* Also disable btnOK after applying changes
* Find better/shorter captions for main tabs
* Remove form borders and apply 8px edge margins instead

Implement rfe #763: Average columns for certain status variables

Fix bug #780 (selected column in datagrid unclear) by highlighting the focused cell only instead of the full row. Probably needs some other row indicator now for cases in which the focused cell was scrolled out of sight.

Bugfix: Read 5M instead of 50 bytes per loop while an SQL file loads and gets executed. 50 bytes per round take way too many loops, time and CPU.

Fix bug #778 you will be asked twice if you want to apply the modifications in the editor window after ESC pressed. The editor dialogs are modal now which fixes a certain part of this issue and makes the code paths less complex.

Fix bug #774: Problems after not saving or cancelling a textfield (or binary field). Solution: Detect any focus steeling and automatically invoke the cancel action.

Follow up to r1830: Use FillAvailColumns in all places where that's applicable.

Fix bug #771 : Index editor - available columns in bad order after dropping one or more of the used columns

Fix bug #773 : Renamed column + column selection breaks grid editing

Fix bug #772: cannot change value after set NULL

Remove the margin indicator in the SQL log.

fix download url

add user agent to http calls

Fix bug #769: Query columns don't clear on update

Implement a simple crash indicator for SELECTing a table's data. This boolean registry value is always set directly before executing the relevant GetResults(). If the query succeeds, the indicator gets just removed directly after that GetResults(). If the table loads for a longer time and the user exits HeidiSQL by killing the process, the indicator is still present and will be used to automatically disable filtering and sorting when that table is loaded again. Helps with issue #714 . See also http://www.heidisql.com/forum/viewtopic.php?p=2638 for a user report which this fix is addressing.

create table field list broken

fix typo

create table dlg: add error messages for adding a field

launch java download link when NSIS cant find Java

fill null pointer when saving table with one field

make autoupdate check async

Add error handling for autoupdate check

Fix bug #759 : wrong context-sensitive help

Fix bug #160 : interface allows selecting autoinc without index or key. Not the neatest solution as the PK checkbox could be unchecked again if AI is unchecked but that didn't seem worth the hacks that would need. The table creation dialog should be reinvented some day.

Fix double masked tablenames in completion proposal, when finding column names after having typed "`sometable`." All we can do to fulfill rfe #639 "Back quote adding to tooltips fields that have spaces in them". The second suggestion was to display tables in the proposal after having typed "`somet" [Ctrl+Space] . That *could* be done by adding the backtick to SynCompletionProposal1.EndOfTokenChr list of chars. But then again this would stop the first mentioned example from working (listing all column names after "`sometable`.") which has - I'd say - more weight.

Remove ToolbarTable completely from the main tool strip. Seemed worthless in terms of that I think all users rather use the context menu buttons instead of those on the toolbar which are far at the right top (= out of sight). Helps issue #738 a bit.

Fix bug #757 error message when removing not-yet inserted row

Fix bug #758 Incorrect tab order in the "Update Field" dialog box

Implement background colors for NULL fields, part 2 of rfe #692

Implement SET editor, rfe #764

Fix bug #760: Cannot drag column into query

Make the memo for build infos slightly larger in updatecheck dialog. Put notes from more than only the last revision into it. By passing the revision with "?r=123" to the PHP file, it returns all notes from the current up to the used revision (but never more than 10, as TIniFile seems to have a small maximum line size of 2048 chars.

Fix bug #754 grid not refreshed correctly after modifiying a record value when filter condition set

Fulfill rfe #750: Field editor - allow non quoted literals for default value

Add 5 pixels more margin to all 4 edges of the connection screen, hopefully makes it a bit more looking like the pretty startup screen and less like a normal dialog.

Fix regression in previous revision: various code used an external variable that was moved to a place where setting it avoids race conditions.

Add markers to help debug issue #691.
To see them, run Sysinternals' DebugView (dbgview.exe) and filter by "mem: ".

Fix bug #749 : size of tables truncated to unreadable in the tree

Updatecheck: Fix displaying the correct filesize of a nightly build while downloading. Read it from the checkfile. The server doesn't include the filesize in the header any longer.

Column width tweaking: Only memorize manually resized column sizes for the second refresh of a table, always do the auto calculation for non resized columns. Especially helpful when clicking a column for sorting, which then needs some extra space for the sort glyph.

Enable printing grid content by using VirtualTree's Print method instead of a homebrown one. Optimizes various controls and code away from the printer dialog.

Fix part 1 of bug #307 export to directory did not create files for each table if "Table structure" was unchecked. Instead the data was found in the header file afterwards.

Fix bug #741: Switching from host node to table node in tree should activate table tab, not database tab

Fix bug #736 cannot drop a table when cursor is on top of the tree

Minor fixes for query grid filling:
- Optimize it using Begin/EndUpdate
- Unselect any nodes from previous result
- Reset view area to top left

Fix name, default value and meaning of preference option "Maximum column width". By default it's 300 now.

Do auto calculation of column widths also in the query results

Don't ORDER BY xyz in SELECT COUNT(*) for datagrid preparation. Could possibly enhance performance on huge tables.

Fix bug #565: Post pending UPDATE when switching tables in data tab . To be exact, there are two events which call actDataPostChanges now: 1. Switching to another table or refreshing the current one and 2. closing the whole form .

Block the grid fields from getting NULLs via menuitem "Set NULL" or the mapped shortcut (Shift+Ctrl+N) if the table is also blocked for normal editing because of insufficient keys.

Bugfix: we're not Internet Explorer, so stop pretending to be.

Bugfix: (regression) missing space caused SQL error.

* Bugfix: after an edit, a new row which did not match the filter was included in the grid.
* Bugfix: the entire width of all fields of edited columns were loaded, instead of a limited view.
* Bugfix: (follow-up to above) one too many rows were included in RootNodeCount after less rows were matched than expected from the data source.
* Bugfix: some memory was not released as early as it could've been when less rows were matched than expected from the data source.

Hopefully fixes issue #730.

Bugfix: some buttons were not disabled when canceling a change where no edits had happened. Fixes issue #729.

Terminology change: 'Changes' instead of 'Edit' in CancelChanges (and PostChanges), since 'edit' is used heftily in context of the data grid, where it means editing a single cell (as opposed to a whole row, which the former applies to).

Bugfix: change the enable/disable code for data buttons into "enable this button when this and that condition is true" and put the logic in ValidateControls. Call ValidateControls in various appropriate places. Fixes issue #713.

Enhancement: Make it optional to display the tables/db sizes in the tree. Rightclick -> "Display sizes"

Fix bug #728 cannot open the tree with cursor keys after starting HeidiSQL

Fulfill rfe #692 "Add color-coding settings to data-appearance tab in preferences". Including new default color for ENUM fields and settings to enable/disable the grid editors.

Preferences dialog: Make data appearance options more compact, giving room for coming data color + editor options. Rename components reasonably.

Fix issue #722 Keyboard shortcut problem

Rounding for copy tabe dialog:
- Fix cut labels using Vista font
- Fix wording in several places
- Normalize positions of controls, use default 8px margin to form edges
- Put a "Select / deselect all" checkbox below the field selection box
- Move registry related constants to const.inc and normalize their names

* DPI fix: The node height of editable Virtual Trees was still not optimal as an editing node didn't have enough height to show the editing cursor. Steal some code from StdCtrls.TCustomEdit.AdjustHeight which does basically what we need here.
* Detected the VirtualTree.Header.ParentFont property and activated that instead of fixing the header font in FixVT

* Bugfix: fix issue #717.
* Rely on IsFloat instead of a more obscure check to determine float values.

Normalize node heights in dbtree and all other virtual trees, make them slightly less high. Keeping 120 DPI compatibility for editing boxes.
Cosmetic todo: Fix Vista selection colors and tree collapse/expand buttons

Missing file from last commit.

* Bugfix: default enclose/separate for CSV should be " and ;. Takes care of export part of issue #709.
* Indicate in CSV files which rows need to be UNHEX()ed with LOAD DATA INFILE during import. Takes care of export part of issue #709.
* Optimization: stop copying records and arrays to stack where appropriate. See also note in helpers.pas.
* Factor out code to extract a cell in it's full width into EnsureFullWidth().
* Create method DiscardData() to release memory for a row.
* Bugfix: GridTo{Xml,Csv,Html} did not export cells in their full widths; they do now. Fixes remainder of issue #685.
* Bugfix: remove superfluous field separator at end of each CSV record.
* Bugfix: CSV field enclose characters within field data must be escaped by printing the enclose character twice, as per de-facto (is it a standard when there are hundreds of applications supporting it, but *all* the major ones all come from the same company?..) CSV.
* Indicate in CSV files which cells are NULL by removing field enclosing (non-standard MySQL CSV extension).
* Indicate in XML files which cells are null and which cells are in hexadecimal format.
* Bugfix: always escape <, &, > in HTML and XML files.

rfe #708: No indicator of changed row . Adds a red small triangle at the top left corner of a modified cell. Background colors don't work here as the cell always has the selection color before modifications get posted.