Nightly builds

User, date Message
User: nqrith
Posted: Thu, 08 Oct 09 02:56
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
User: anse
Posted: Thu, 08 Oct 09 08:10
1775 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...
User: vga
Posted: Fri, 09 Oct 09 07:13
57 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
User: vga
Posted: Fri, 09 Oct 09 07:15
57 posts since Fri, 09 Oct 09 		I want to know how display checkbox in field edit window with visualstringtree?
User: anse
Posted: Fri, 09 Oct 09 08:01
1775 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;
User: vga
Posted: Fri, 09 Oct 09 10:33
57 posts since Fri, 09 Oct 09 		Thank you!
User: vga
Posted: Fri, 09 Oct 09 11:11
57 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?
User: vga
Posted: Fri, 09 Oct 09 11:12
57 posts since Fri, 09 Oct 09 		sorry, it's press Enter Key
User: anse
Posted: Fri, 09 Oct 09 13:11
1775 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.
User: vga
Posted: Sat, 10 Oct 09 01:55
57 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.
User: anse
Posted: Sat, 10 Oct 09 09:34
1775 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.
User: vga
Posted: Sat, 10 Oct 09 10:07
57 posts since Fri, 09 Oct 09 		thank you.
User: vga
Posted: Tue, 03 Nov 09 07:27
57 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.
User: anse
Posted: Tue, 03 Nov 09 07:50
1775 posts since Fri, 07 Apr 06 		Oh nice, compiling Heidi smile That 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?
User: vga
Posted: Tue, 03 Nov 09 23:18
57 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.
User: anse
Posted: Wed, 04 Nov 09 00:00
1775 posts since Fri, 07 Apr 06 		Or you can just remove that line, it's cosmetic stuff.
User: vga
Posted: Wed, 04 Nov 09 03:34
57 posts since Fri, 09 Oct 09 		Thank you.
User: vga
Posted: Tue, 24 Nov 09 03:46
57 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?
User: anse
Posted: Tue, 24 Nov 09 09:30
1775 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?
User: vga
Posted: Tue, 24 Nov 09 10:01
57 posts since Fri, 09 Oct 09 		application short cut ICON on desktop
blink.

I think those were repaint again.
User: anse
Posted: Tue, 24 Nov 09 17:05
1775 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.
User: anse
Posted: Tue, 24 Nov 09 17:07
1775 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 smile
User: walkeer
Posted: Wed, 25 Nov 09 12:24
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 ;
User: walkeer
Posted: Wed, 25 Nov 09 12:25
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...
User: vga
Posted: Thu, 26 Nov 09 01:09
57 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.
User: vga
Posted: Mon, 30 Nov 09 07:28
57 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.
User: anse
Posted: Mon, 30 Nov 09 12:37
1775 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.
User: vga
Posted: Tue, 01 Dec 09 00:57
57 posts since Fri, 09 Oct 09 		thak you.
User: nqrith
Posted: Tue, 01 Dec 09 02:51
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.
User: anse
Posted: Tue, 01 Dec 09 08:02
1775 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.
User: vga
Posted: Tue, 01 Dec 09 09:11
57 posts since Fri, 09 Oct 09 		thanks.

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

It works OK.
User: anse
Posted: Tue, 01 Dec 09 10:59
1775 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.
User: vga
Posted: Wed, 02 Dec 09 01:39
57 posts since Fri, 09 Oct 09 		thank you.
User: walkeer
Posted: Wed, 09 Dec 09 10:27
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
User: anse
Posted: Wed, 09 Dec 09 14:49
1775 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?
User: anse
Posted: Wed, 09 Dec 09 14:52
1775 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?
User: vga
Posted: Thu, 10 Dec 09 03:13
57 posts since Fri, 09 Oct 09 		when I using utf8 charset the chinese char "" display as "?",
when I using GBK the all record disappeared.
User: vga
Posted: Thu, 10 Dec 09 03:21
57 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`)
)
User: anse
Posted: Thu, 10 Dec 09 09:31
1775 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?
User: vga
Posted: Thu, 10 Dec 09 09:43
57 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.
User: anse
Posted: Thu, 10 Dec 09 09:46
1775 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.
User: vga
Posted: Thu, 10 Dec 09 09:52
57 posts since Fri, 09 Oct 09 		while I execute query :
"set names utf8" in heidisql, the chinese char "" became to "?" again.
User: vga
Posted: Sat, 23 Jan 10 01:04
57 posts since Fri, 09 Oct 09 		the last version (delphi 2010 comliled), the chinese char "" became to "?" yet.
User: vga
Posted: Sat, 23 Jan 10 01:05
57 posts since Fri, 09 Oct 09 		My-SQL Front work well
User: anse
Posted: Sat, 23 Jan 10 08:21
1775 posts since Fri, 07 Apr 06 		Where? In the query editor, in the query results or what?
User: vga
Posted: Sat, 23 Jan 10 10:16
57 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.
User: anse
Posted: Sat, 23 Jan 10 10:43
1775 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?
User: anse
Posted: Sat, 23 Jan 10 10:56
1775 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?
User: vga
Posted: Sun, 24 Jan 10 00:31
57 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 "?"
User: vga
Posted: Sun, 24 Jan 10 00:40
57 posts since Fri, 09 Oct 09 		I run :

set names gbk

in My_SqlFront, "" can be display.
User: anse
Posted: Sun, 24 Jan 10 01:17
1775 posts since Fri, 07 Apr 06 		Then, this char is probably not in the UTF-16 charset. Can't believed that... hmm
User: vga
Posted: Tue, 26 Jan 10 02:24
57 posts since Fri, 09 Oct 09 		you can see it in:
http://atkins.5d6d.com/viewthread.php?tid=12127&extra=
User: vga
Posted: Tue, 26 Jan 10 03:47
57 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.