Nightly builds

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

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...

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

I want to know how display checkbox in field edit window with visualstringtree?

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;

Thank you!

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?

sorry, it's press Enter Key

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.

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.

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.

thank you.

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.

Oh nice, compiling HeidiThat 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?

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.

Or you can just remove that line, it's cosmetic stuff.

Thank you.

Hello,
when I browse table data and change the table, the desktop of my computer repaint, how to avoid it?

I don't understand "the desktop of my computer repaints" - do you mean the application gets an OnPaint event?

application short cut ICON on desktop
blink.

I think those were repaint again.

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.

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 :)

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 ;

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...

"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.

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.

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.

thak you.

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.

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.

thanks.

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

It works OK.

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.

thank you.

I am not able to run any stored procedure with nightly builds, is it a feature, or a bug? thnx

A feature, of course. Oh man that joke is so outdated, that was not funny...

"I am not able to run" means what?

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?

when I using utf8 charset the chinese char "" display as "?",
when I using GBK the all record disappeared.

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`)
)

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?

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.

I think calling SET NAMES within HeidiSQL breaks Unicode logic everywhere. Just leave it on UTF-8, should enable all international characters.

while I execute query :
"set names utf8" in heidisql, the chinese char "" became to "?" again.

the last version (delphi 2010 comliled), the chinese char "" became to "?" yet.

My-SQL Front work well

Where? In the query editor, in the query results or what?

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.

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?

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?

"" 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 "?"

I run :

set names gbk

in My_SqlFront, "" can be display.

Then, this char is probably not in the UTF-16 charset. Can't believed that... hmm

you can see it in:
http://atkins.5d6d.com/viewthread.php?tid=12127&extra=

[/url][url=http://atkins.5d6d.com/viewthread.php?tid=12127&extra= ]