distal-attribute
distal-attribute
distal-attribute
distal-attribute

Nightly builds

nqrith posted 5 years ago in General
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
ansgar posted 5 years ago
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...
vga posted 5 years ago
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
vga posted 5 years ago
I want to know how display checkbox in field edit window with visualstringtree?
ansgar posted 5 years ago
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;

vga posted 5 years ago
Thank you!

vga posted 5 years ago
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?
vga posted 5 years ago
sorry, it's press Enter Key
ansgar posted 5 years ago
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.
vga posted 5 years ago
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.

ansgar posted 5 years ago
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.
vga posted 5 years ago
thank you.
vga posted 5 years ago
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.
ansgar posted 5 years ago
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?
vga posted 5 years ago
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.
ansgar posted 5 years ago
Or you can just remove that line, it's cosmetic stuff.
vga posted 5 years ago
Thank you.
vga posted 5 years ago
Hello,
when I browse table data and change the table, the desktop of my computer repaint, how to avoid it?
ansgar posted 5 years ago
I don't understand "the desktop of my computer repaints" - do you mean the application gets an OnPaint event?
vga posted 5 years ago
application short cut ICON on desktop
blink.

I think those were repaint again.
ansgar posted 5 years ago
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.
ansgar posted 5 years ago
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 :)
walkeer posted 5 years ago
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 ;
walkeer posted 5 years ago
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...
vga posted 5 years ago
"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.
vga posted 5 years ago
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.
ansgar posted 5 years ago
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.
vga posted 5 years ago
thak you.
nqrith posted 5 years ago
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.
ansgar posted 5 years ago
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.
vga posted 5 years ago
thanks.

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

It works OK.
ansgar posted 5 years ago
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.
vga posted 5 years ago
thank you.
walkeer posted 5 years ago
I am not able to run any stored procedure with nightly builds, is it a feature, or a bug? thnx
ansgar posted 5 years ago
A feature, of course. Oh man that joke is so outdated, that was not funny...

"I am not able to run" means what?
ansgar posted 5 years ago
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?
vga posted 5 years ago
when I using utf8 charset the chinese char "" display as "?",
when I using GBK the all record disappeared.
vga posted 5 years ago
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`)
)
ansgar posted 5 years ago
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?
vga posted 5 years ago
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.
ansgar posted 5 years ago
I think calling SET NAMES within HeidiSQL breaks Unicode logic everywhere. Just leave it on UTF-8, should enable all international characters.
vga posted 5 years ago
while I execute query :
"set names utf8" in heidisql, the chinese char "" became to "?" again.
vga posted 5 years ago
the last version (delphi 2010 comliled), the chinese char "" became to "?" yet.
vga posted 5 years ago
My-SQL Front work well
ansgar posted 5 years ago
Where? In the query editor, in the query results or what?
vga posted 5 years ago
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.
ansgar posted 5 years ago
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?
ansgar posted 5 years ago
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?
vga posted 5 years ago
"" 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 "?"
vga posted 5 years ago
I run :

set names gbk

in My_SqlFront, "" can be display.
ansgar posted 5 years ago
Then, this char is probably not in the UTF-16 charset. Can't believed that... hmm
vga posted 5 years ago
you can see it in:
http://atkins.5d6d.com/viewthread.php?tid=12127&extra=
vga posted 5 years ago
[/url][url=http://atkins.5d6d.com/viewthread.php?tid=12127&extra= ]

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