Nightly builds

User, date Message
Written by nqrith
4 years ago
Category: General
2 posts since Thu, 08 Oct 09 		Hi,

I was wondering why there haven't been any nightly builds since the 24th of September, before that, there was a release each day, but in the past couple of weeks, nothing, it's a bit strange, but I am sure there is a logical explanation.

Regards,

AJ
Written by ansgar
4 years ago
3950 posts since Fri, 07 Apr 06 		Hehe, I just didn't work on HeidiSQL itself recently, more on the website and on this forum. But this is nearly ready so the builds will come again...
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		I was wondering why Field(s) removed when drag it.

would you mind send me the source code of the Nightly builds to me?

vga26*126*com
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		I want to know how display checkbox in field edit window with visualstringtree?
Written by ansgar
4 years ago
3950 posts since Fri, 07 Apr 06 		Source code of HeidiSQL is available at Google Code:
- Check out SVN locally: http://code.google.com/p/heidisql/source/checkout
- Browse directories: http://code.google.com/p/heidisql/source/browse/

The removed columns are surely a bug, I just saw the same here. Painting checkboxes was done using the OnAfterCellPaint method, together with OnClick where checking/unchecking is done.


procedure TfrmTableEditor.listColumnsAfterCellPaint(Sender: TBaseVirtualTree;
TargetCanvas: TCanvas; Node: PVirtualNode; Column: TColumnIndex;
CellRect: TRect);
var
Col: PColumn;
ImageIndex, X, Y: Integer;
VT: TVirtualStringTree;
begin
// Paint checkbox image in certain columns
// while restricting "Allow NULL" checkbox to numeric datatypes
if (Column in [4, 5]) and CellEditingAllowed(Node, Column) then begin
Col := Sender.GetNodeData(Node);
if (Col.Unsigned and (Column=4)) or (Col.AllowNull and (Column=5)) then ImageIndex := 128
else ImageIndex := 127;
VT := TVirtualStringTree(Sender);
X := CellRect.Left + (VT.Header.Columns[Column].Width div 2) - (VT.Images.Width div 2);
Y := CellRect.Top + Integer(VT.NodeHeight[Node] div 2) - (VT.Images.Height div 2);
VT.Images.Draw(TargetCanvas, X, Y, ImageIndex);
end;
end;
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		Thank you!
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		when entry data, I must press enter before, and must entry enter after,
I'd like Excel entry way of excel,what can I modify for that?
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		sorry, it's press Enter Key
Written by ansgar
4 years ago
3950 posts since Fri, 07 Apr 06 		I had changed that behaviour before, so that a single-click into a datagrid cell started the inplace editor. But that lead to various users being annoyed, including me, so I reverted that. See issue #1272 for a discussion on that topic.
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		Thank you,
how about
adding a switch "In which mode do you want to start:" (like in Outlook:
Calendar/Inbox/Contacts....)
1. table definition editor
2. table editor manual edit mode
3. table editor direct edit mode.

best regards.
Written by ansgar
4 years ago
3950 posts since Fri, 07 Apr 06 		I don't believe you're serious about that... A dialog with 3 oprions for such minor stuff - I'm very sure many users would complain about that, including me.

However, what's the problem exactly? I think I didn't get it yet.
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		thank you.
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		in the main.pas
line 1640 is:
// Prevent generating a seperator for ShortHint and LongHint
miFunction.Hint := StringReplace( miFunction.Hint, '|', '?, [rfReplaceAll] );

I cannot compile, I want to know Replace '|' to which char.

thank you.
Written by ansgar
4 years ago
3950 posts since Fri, 07 Apr 06 		Oh nice, compiling HeidismileThat question mark should be a vertical line, similar to the pipe: ¦ Why is that broken, it's not even a Unicode char and the file has latin1 charset?
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		I use delphi 2007, winxp sp3 chinese version.

I do not know Why is that broken, now I rewrite it to be:

miFunction.Hint := StringReplace( miFunction.Hint, '|', '|', [rfReplaceAll]);

thank you.
Written by ansgar
4 years ago
3950 posts since Fri, 07 Apr 06 		Or you can just remove that line, it's cosmetic stuff.
Written by vga
4 years ago
62 posts since Fri, 09 Oct 09 		Thank you.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		Hello,
when I browse table data and change the table, the desktop of my computer repaint, how to avoid it?
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		I don't understand "the desktop of my computer repaints" - do you mean the application gets an OnPaint event?
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		application short cut ICON on desktop
blink.

I think those were repaint again.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Can't believe this is reproducible and caused by switching a table in HeidiSQL's data tab ... at least here that is not the case.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Btw, if you changed something in the sources I'd be interested in those changes - not a requirement of GPL based OpenSource, just to satisfy my curiosity :)
Written by walkeer
3 years ago
3 posts since Wed, 25 Nov 09 		Hello, I have problem executing proceduires with nightly builds. In latest stable are no problems.

DROP PROCEDURE if exists model_split;
delimiter |
CREATE PROCEDURE model_split(IN id varchar(20),IN table_name varchar(20),IN input_row varchar(20),IN output_row varchar(20))
BEGIN
DROP VIEW IF EXISTS v1;
SET @stmt_text=CONCAT('CREATE VIEW v1 AS SELECT ', id ,' row_id, ', input_row ,' i_row FROM ',table_name); #create VIEW for later use for CURSOR with table name as parameter
PREPARE stmt FROM @stmt_text;
EXECUTE stmt;
BEGIN
declare done int default 0;
declare var varchar(64);
declare pos int;
declare splited varchar (200);
declare lastch char(1);
declare nowch char(1);
declare id1 BIGINT;
DECLARE cur CURSOR for SELECT row_id,i_row FROM v1;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1; # ends REPEAT cycle when cursor reaches last row
open cur;
REPEAT
fetch cur INTO id1,var;
set pos=1;
set lastch=replace(substring(var,-length(var),1),',','.');
set splited=lastch;
while pos < length(var) do
set nowch=replace(substring(var,-length(var)+pos,1),',','.');
set splited=concat(splited,if((lastch regexp '[0-9]' <> nowch regexp '[0-9]') and lastch <> '.' and nowch <> '.',' ',''),nowch);
set pos=pos+1;
set lastch=nowch;
end while;
set @prep = concat(
'UPDATE ',table_name,' SET ',output_row,'=\'',splited,'\' where ',id,'=\'',id1,'\''
);
prepare fill from @prep;
execute fill;
until done end repeat;
close cur;
DROP VIEW IF EXISTS v1;
END;
END|
delimiter ;
Written by walkeer
3 years ago
3 posts since Wed, 25 Nov 09 		sorry, error is " SQL Error 1312: PROCEDURE cant return a result set in the givven context. My procedure is not supposed to return any result set...
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		"Btw, if you changed something in the sources I'd be interested in those changes - not a requirement of GPL based OpenSource, just to satisfy my curiosity "

thank you.

to reproduce the case just close all other program, and run heidisql(no maxisized), browse different table data, we can see application short cut ICON on desktop
repaint again.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		to reproduce the case just close all other program, and run heidisql(no maxisized), browse different table data, we can see application short cut ICON on desktop
were repainted again.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Sorry, I am unable to reproduce that here.

Sounds like a minor cosmetic problem to me, probably caused by some specific graphics card driver problem, interfering with some paint method in the Windows API.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		thak you.
Written by nqrith
3 years ago
2 posts since Thu, 08 Oct 09 		With regards to the screen refresh problem vga is having, I also have it happening on mine.

All I have to do to make it happen, is have all other programs minimized, and have the main Heidi window in a non maximized window state, so I can see the icons on the desktop, and then simply change to another table in the left hand tree list.

I have had similar problems with some of my own programs, and the culprit ended up being a LockWindowUpdate call, specifically when I unlock it with LockWindowUpdate(0), my work around for it was to use the components method, ie BeginUpdate and EndUpdate, not sure if you are using those or not, but that may be a place to start looking.

And FYI, I am running the latest HeidiSQL nightly, and I have an NVidia video card, not the latest drivers though.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Yes, there is a

LockWindowUpdate(PageControlMain.Handle);
..;
LockWindowUpdate(0);


somewhere when there is a tab or a tab close button needing an update. Don't know how to workaround that, there is no BeginUpdate method for a pagecontrol. Hmm.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		thanks.

when delete
LockWindowUpdate(PageControlMain.Handle);
and
LockWindowUpdate(0);

It works OK.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Hehe, no it doesn't. These LockWindowUpdate's are needed to avoid weird animations while repositioning tab close buttons.

Thinking this icon repainting is less weird and more cosmetic than this animation.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		thank you.
Written by walkeer
3 years ago
3 posts since Wed, 25 Nov 09 		I am not able to run any stored procedure with nightly builds, is it a feature, or a bug? thnx
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		A feature, of course. Oh man that joke is so outdated, that was not funny...

"I am not able to run" means what?
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Ah, I see you'r referring to an earlier post above:

SQL Error 1312: PROCEDURE cant return a result set in the given context



How do you call your procedure?
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		when I using utf8 charset the chinese char "" display as "?",
when I using GBK the all record disappeared.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		my table:
CREATE TABLE `test` (
`ID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`PicName` CHAR(50) NULL DEFAULT NULL,
`Image` LONGBLOB NULL,
`New汉字’Field` VARCHAR(255) NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX `ID` (`ID`)
)
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		vga, I am not able to follow you. Is that now a problem with calling a procedure or a new problem? I can't see if this charset problem is related to the procedure problem posted above.

For the procedure problem, again: How do you call your procedure?
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		I create a table with:

CREATE TABLE `test` (
`ID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`PicName` CHAR(50) NULL DEFAULT NULL,
`Image` LONGBLOB NULL,
`New汉字’Field` VARCHAR(255) NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX `ID` (`ID`)
)

and then I entry data(“”) in heidisql, press Enter key, the chinese char "" became to "?" . when execute query :
"set names GBK" in heidisql, error occur and data could not be displayed.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		I think calling SET NAMES within HeidiSQL breaks Unicode logic everywhere. Just leave it on UTF-8, should enable all international characters.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		while I execute query :
"set names utf8" in heidisql, the chinese char "" became to "?" again.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		the last version (delphi 2010 comliled), the chinese char "" became to "?" yet.
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		My-SQL Front work well
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Where? In the query editor, in the query results or what?
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		To reproduce this:

CREATE TABLE `test` (
`ID` int(11) unsigned NOT NULL auto_increment,
`PicName` char(50) default NULL,
`Image` longblob,
`New汉字’Field` varchar(255) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=gbk;

and

Entry "" or past it to the char type field.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Hm, I can paste 汉字 without problems, but not your given char - looks broken, already here in this forum page, and so I cannot paste anything. Is that a chinese char or what?
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Oh I can reproduce that. Found the non-broken char in my RSS feed. And have the same problem inserting it into that table. Can you tell me, is that char somehow a special char from a different charset?
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		"" is a chinese char,and it can be show in access, MS Sql Server, Excel and so on. but in some other shoftware like SQLyog will show "" as "?"
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		I run :

set names gbk

in My_SqlFront, "" can be display.
Written by ansgar
3 years ago
3950 posts since Fri, 07 Apr 06 		Then, this char is probably not in the UTF-16 charset. Can't believed that... hmm
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		you can see it in:
http://atkins.5d6d.com/viewthread.php?tid=12127&extra=
Written by vga
3 years ago
62 posts since Fri, 09 Oct 09 		[/url][url=http://atkins.5d6d.com/viewthread.php?tid=12127&extra= ]
 

Please login to leave a reply, or register at first.