Originally posted by: [ The documentation links do not even mention comments...? Status: NeedInfo
a) According to the documents I searched on MSDN website, it seems MS SQL could only change comment in these way: update http://msdn.microsoft.com/zh-tw/library/ms186885.aspx drop http://msdn.microsoft.com/en-us/library/ms178595.aspx I don't know that there is any simpler way to do these.
Originally posted by: sagara1...@gmail.com I just reproduced "Altering database ... failed. Database ... contains stored routine, which cannot mkjb moved". Can it be fixed?
Originally posted by: sagara1...@gmail.com I just reproduced "Altering database ... failed. Database ... contains stored routine, which cannot be moved". Can it be fixed?
Please use the tracker on Github. HeidiSQL has moved there. https://github.com/HeidiSQL/HeidiSQL/issues
when deleting a crashed table HeidiSQL is using wrong command: DROP VIEW
Access Violation when clicking on crashed table
Remove debug code. See https://www.heidisql.com/forum.php?t=24400
New attempt to fix menu and buttons flicker on Win10, this time by with the help of Delphi Detours library. See https://www.heidisql.com/forum.php?t=19141
Id rather use HeidiSQL versus other tools. Keep checking back every 6 months to see if it's ever been included. Please consider. If not, how about if one of us add it in?
UFT-8 characters in views appear with wrong encoding
Because HeidiSQL requires the definer I constantly have trouble moving databases to other systems where different users are being used. Could this please be fixed?
fix will be disabling Quickfilter, if data grid is empty. menuQuickFilter.Enabled := InDataGrid and (Grid.RootNodeCount > 0);
Feature Request
+1 After using the application for only a day, I am very happy with it, except for this missing enhancement. It's nice to see that it is open source, so if I ever get some time, I will do something about this.
Originally posted by: a...@anse.de No problem. Lucky me I hadn't much to do here :)
Originally posted by: justpus...@gmail.com ansgar.becker, why do you want to wait for a thread? The thread may notify you itself when it finishes. The easiest solution: you can use some mainform variable as a signal that thread finished its work. Also you can use Synchronize method to run some function in main thread and do some work there. I see thread structure something like this: procedure YourThread.Execute; begin for i:=1 to queriesCount do begin ExecuteThisQuery(queries[i]); queriesDone:=i;...
Originally posted by: a...@anse.de This issue was closed by revision [r4266]. Status: Fixed
Originally posted by: a...@anse.de Got it: The UPX compressed .exe breaks MadExcept and its exception handling, not being able to find the right stack trace or whatever. http://forum.madshi.net/viewtopic.php?t=4614 http://forum.madshi.net/viewtopic.php?t=4143 http://stackoverflow.com/questions/603130/madexcept-upx Just disabled UPX for that reason, should fix it. For the current build, I just decompressed the exe Status: Fixed
HeidiSQL crashed when setting filter on empty table
Originally posted by: a...@anse.de Nice idea, because that's really simple, and useful too. That item could live as "Browse table in new query tab" in the context menu of the data grid (as you proposed), and additionally in the database tab when rightclicking a table.
Originally posted by: a...@anse.de hehe, same thing as [r3765].
I don't use VPN, but a network disconnection (eg. ADSL down) will cause this issue.
Originally posted by: a...@anse.de Really? Hm, that way all users are forced to download the installer, which is good for fixed critical bugs. Additionally, I'm aware of the fact that I released way too seldom in the past. Ok, let me fix some more issues and I'll prepare the 8.2 release.
Originally posted by: a...@anse.de [r4728] now adds a read-only tab with the PARTITION clause of the table, if present. Also, the "CREATE code" tabs includes this clause.
Originally posted by: a...@anse.de [r4728] now adds a read-only tab with the PARTITION clause of the table, if present. Also, the "CREATE code" tabs includes this clause.
Restoring the Query tabs you were working on before a restart of the program would be even more useful ever since Windows 10, which auto-restarts after updates. I see the Query History but there's a lot of noise there like background queries ran by HeidiSQL to fetch info or your previous versions of a query, from all tabs. Having HeidiSQL restore previously open tabs on start (possibly after asking the user) would be a great addition.
Can't delete/update a record in a table with image field in sql server
Originally posted by: a...@anse.de Pablo, I guess you are now running into a problem from [r4430]. Before that, I had a "db"."dbo"."table" syntax, where the "dbo" part was hardcoded. Could you please verify that: Does "master"."dbo"."spt_datatype_info" also work?
Originally posted by: a...@anse.de (No comment was entered for this change.) Labels: -migrated
Originally posted by: vanav@vanav.org Yes, please, ask key password interactively. Workaround 1: > pageant "private.key.ppk" -c "C:\Program Files\HeidiSQL\heidisql.exe" Network type: MySQL (SSH tunnel) Hostname: 127.0.0.1 Port: 3306 SSH host: example.com Username: user Private key file: "private.key.ppk" Local port: 3307 Workaround 2: > plink user@example.com -i "private.key.ppk" -N -L 3307:127.0.0.1:3306 Network type: MySQL (TCP/IP) Hostname: 127.0.0.1 Port: 3307
Originally posted by: a...@anse.de (No comment was entered for this change.) Labels: -migrated
Originally posted by: a...@anse.de Yes, that's slightly inconsistent currently. Already reported in issue #595
Extend TMySQLOption enumeration with newer items
Originally posted by: a...@anse.de (No comment was entered for this change.) Status: WontFix
Originally posted by: a...@anse.de I guess configuring as WinXP is the valid solution here. Issue #3371 was fixed. Status: CantFix
Originally posted by: imre.lo...@gmail.com Theres nothing to fix, because it works as intended for me, except the heidisql dialog. Warning are what they are: just warnings, not errors. Thank you, starred the other.
please can you help me after the installation of xamp and heidi db i get this message (when I click on open and the Login or when I open HeidiSQL) damaged NeTypes value(255) in session ... (connection manager heidi db) access denied for root user @localhost (using password No) what can I do? thanks for your help vanessa
fix exception in early stage of table editor initialization
* unify context menu of various sql editors, by supporting all contained editors instead of searching for one with the name "SynMemoBody"
Trigger OnChange event on TSynMemo after toggling comment, so a save button gets enabled. See https://www.heidisql.com/forum.php?t=23834
Save session tree color when creating a copy of a session. See https://www.heidisql.com/forum.php?t=23796
mySQL procedure/function paremeters formatting
Fix detection of column types with DEFAULT CURR...
Crush on performing multiple queries.
Add custom setting for number of days to keep q...
Use new copy-columns icon in main image list
Create a nicer icon for "Copy selected columns/...
Reduce flicker on Windows 10. See https://www.h...
Silence dumb exceptions from mysql_ping() call....
Create a new menu item for copying rows to clip...
Revert r5161, as it makes more problems than it...
Set DoubleBuffered property on main form, an at...
Use the grid export dialog for setting values f...
Set tsvn:projectlanguage to english/us
Use unsecure project web url for donor checks, ...
Fix typos in encoding of xml exports. See https...
Support auto_increment flag on indexes other th...
Support grouping by tree node type in "check xy...
Prevent inserting cell text ellipsis in query t...
Add "<server default>" to the engine drop down ...
Use HTTPS for all web requests on heidisql.com
Originally posted by: claudiot...@hotmail.com This is one old thread but uqualy I...
Originally posted by: claudiot...@hotmail.com This is one old thread but uqualy I...
Additional files from SynEdit GitHub repository
Update SynEdit component code to v2.0.9 beta fr...
Revert r5144, which causes more problems than i...
That hostname resolving is not done by HeidiSQL, but by the MySQL server or libmysql.dll....
Option to avoid hostname to IP resolution
Missing file change for previous commit
Fix some labels which I modified wrongly some t...
Attempt to add an error string which Windows pr...
yeah, would also like to see this. Should be an easy fix to use "IDENTITY" instead...
Include ADO connection string in status bar con...
Work around access violation in highlighter, wh...
Make Markdown export code compatible to the par...
Support SQL security setting in view editor via...
Increase width of "name" field on view editor t...
Reasonably increase and unify design time dimen...
Remove per-row comment in PHP array grid export...
I managed to solve the issue. I downloaded the MariaDB window version (10.0.20) that...
Access Violation after login with PAM authenticated user on MariaDB
Revert r5136, which removes support for single ...
Don't encode html entities but escape quotes in...
Fix sloppy regular expression in TDBConnection....
Escape quotes and stuff in JSON keys and values...
Use double quotes for PHP values when exporting...
Originally posted by: a...@anse.de (No comment was entered for this change.) Status:...
PostgreSQL: query timeout is set in millisecond...
Try to load libpq.dll with explicit file path i...
Originally posted by: pklawan...@gmail.com Hi Guys, what's the status with this ...
Originally posted by: r...@probc.com Why not just donate and be done with it? Imagine...
Inject a line break after the data grid WHERE f...
Originally posted by: a...@anse.de (No comment was entered for this change.) Status:...
Cast unknown data type columns as text when gen...
Use the right SQL commands for killing a proces...
Fix compiler warning
Hi - was wondering if this was going to be addressed - it certainly is a valid problem...
Remove quirky logic from TMySQLQuery.Execute wh...
Fix crash when taskbar button interface is not ...