"Query tab name" and snippets -- is this an anomaly??

[expired user #3694]'s profile image [expired user #3694] posted 14 years ago in General Permalink
1.In the query pane, I import an SQL query file (e.g., query1.sql). I open up a second query tab and import another SQL query file (query2.sql).

(Notice that the first query tab does not have a close "x" symbol, but the second query tab does.)

2. I select the query1.sql tab. In the rightmost pane, I scroll to the SNIPPETS display. I select a snippet and double-click on it (e.g., entitled: "Find records only present in 1 of 2 tables".) The query1.sql tab was RENAMED to the name of the snippet.

3. I select the query2.sql tab. In the rightmost pane, I again scroll to the SNIPPETS display again. I select a snippet and double-click on it. The query2.sql tab is RENAMED to the name of the snippet.

4. Since the second query tab has a close "X" on it, I click on it. HeidiSQL "bongs" and gives me a conspicuous error message.

Is this OK, or is there something I'm not understanding? BTW, why does the default query tab not have a close "x" option?

Thank you very much.
[expired user #3694]'s profile image [expired user #3694] posted 14 years ago Permalink
You know, I'm not sure my previous post makes much sense...I think perhaps I need to work more with HeidiSQL. For example, the default query tab is probably not meant to be closed, etc...
ansgar's profile image ansgar posted 14 years ago Permalink

the default query tab is probably not meant to be closed


exactly.

2. + 3.: very normal, if a file is loaded, the tab gets renamed.

4.: What does the error message say?
[expired user #3694]'s profile image [expired user #3694] posted 14 years ago Permalink
Thanks for your reply. Here is the text of "bugreport.txt":

date/time : 2010-04-05, 21:28:19, 154ms
computer name : DESKTOP
user name : Dave <admin>
registered owner : Microsoft / Microsoft
operating system : Windows 7 x64 build 7600
system language : English
system up time : 2 hours 41 minutes
program up time : 55 minutes 1 second
processors : 4x Intel(R) Core(TM)2 Quad CPU Q9400 @ 2.66GHz
physical memory : 2604/4028 MB (free/total)
free disk space : (C:) 429.80 GB
display mode : 1920x1200, 32 bit
process id : $1ccc
allocated memory : 54.80 MB
executable : heidisql.exe
exec. date/time : 2010-03-26 23:03
version : 5.0.0.3222
compiled with : Delphi 2010
madExcept version : 3.0k
callstack crc : $ccc834b8, $fc4aec37, $fc4aec37
count : 2
exception number : 5
exception class : EAccessViolation
exception message : Access violation at address 0053F4B8 in module 'heidisql.exe'. Read of address 0000005C.

main thread ($4c4):
0053f4b8 +00c heidisql.exe Controls TControl.GetClientWidth
00576089 +041 heidisql.exe Buttons TSpeedButton.MouseUp
00541e50 +038 heidisql.exe Controls TControl.DoMouseUp
00541ecc +070 heidisql.exe Controls TControl.WMLButtonUp
005414b0 +2d4 heidisql.exe Controls TControl.WndProc
00545d78 +568 heidisql.exe Controls TWinControl.WndProc
00567c68 +594 heidisql.exe Forms TCustomForm.WndProc
005410d4 +024 heidisql.exe Controls TControl.Perform
00545418 +02c heidisql.exe Controls TWinControl.MainWndProc
005410d4 +024 heidisql.exe Controls TControl.Perform
005456a4 +0ac heidisql.exe Controls TWinControl.IsControlMouseMsg
00545bf4 +3e4 heidisql.exe Controls TWinControl.WndProc
00545418 +02c heidisql.exe Controls TWinControl.MainWndProc
00499d08 +014 heidisql.exe Classes StdWndProc
75cd7df5 +00a USER32.dll DispatchMessageW
00570d69 +11d heidisql.exe Forms TApplication.ProcessMessage
00570dae +00a heidisql.exe Forms TApplication.HandleMessage
005710d9 +0c9 heidisql.exe Forms TApplication.Run
007198bd +0d9 heidisql.exe heidisql 66 +18 initialization
752f3675 +010 kernel32.dll BaseThreadInitThunk

thread $1c84 (TWorkerThread):
75c70810 +92 KERNELBASE.dll WaitForSingleObjectEx
752f117f +3e kernel32.dll WaitForSingleObjectEx
752f1133 +0d kernel32.dll WaitForSingleObject
005cd75d +19 heidisql.exe VirtualTrees TWorkerThread.Execute
004606e7 +2b heidisql.exe madExcept HookedTThreadExecute
00497836 +42 heidisql.exe Classes ThreadProc
004067f8 +28 heidisql.exe System 548 +0 ThreadWrapper
004605c9 +0d heidisql.exe madExcept CallThreadProcSafe
00460633 +37 heidisql.exe madExcept ThreadExceptFrame
752f3675 +10 kernel32.dll BaseThreadInitThunk
>> created by main thread ($4c4) at:
005cd652 +16 heidisql.exe VirtualTrees TWorkerThread.Create

thread $994:
752f3675 +10 kernel32.dll BaseThreadInitThunk

thread $1fd4: <priority:2>
004605c9 +0d heidisql.exe madExcept CallThreadProcSafe
00460633 +37 heidisql.exe madExcept ThreadExceptFrame
752f3675 +10 kernel32.dll BaseThreadInitThunk
>> created by main thread ($4c4) at:
74356fcd +00 winmm.dll

thread $12a4:
752f3675 +10 kernel32.dll BaseThreadInitThunk
ansgar's profile image ansgar posted 14 years ago Permalink
Well, that is indeed an unhandled exception. Only I'm not able to reproduce that. Could you please update to the latest build (Help > Check for updates) and recheck?
[expired user #3694]'s profile image [expired user #3694] posted 14 years ago Permalink
Anse, thanks for your reply.

This is how I get the error. I'm using version 5.0.0.332. I downloaded the "newest" version of 5.0.0.332 this morning and the same thing happens.

1.In the default query pane, I import an SQL query file (e.g., query1.sql). I open up a second query tab and import another SQL query file (query2.sql).

2. I select the query1.sql tab. In the rightmost pane, I scroll over to the SNIPPETS display. I select a snippet and double-click on it (e.g., entitled: "Find records only present in 1 of 2 tables".) The query1.sql tab was RENAMED to the name of the snippet.

3. I select the query2.sql tab. In the rightmost pane, I again scroll to the SNIPPETS display again. I select a snippet and double-click on it. The query2.sql tab is RENAMED to the name of the snippet.

4. Since the second query tab has a close "X" on it, I click on it. HeidiSQL "bongs" and gives me an error message: "An error occurred in the application."

5. I did this consistently for about 5 times. Here is the latest bugreport.txt:
------------------------------
date/time : 2010-04-06, 10:48:54, 711ms
computer name : DESKTOP
user name : Dave <admin>
registered owner : Microsoft / Microsoft
operating system : Windows 7 x64 build 7600
system language : English
system up time : 3 hours 20 minutes
program up time : 7 minutes 36 seconds
processors : 4x Intel(R) Core(TM)2 Quad CPU Q9400 @ 2.66GHz
physical memory : 2647/4028 MB (free/total)
free disk space : (C:) 429.47 GB
display mode : 1920x1200, 32 bit
process id : $207c
allocated memory : 40.82 MB
executable : heidisql.exe
exec. date/time : 2010-03-26 23:03
version : 5.0.0.3222
compiled with : Delphi 2010
madExcept version : 3.0k
callstack crc : $ccc834b8, $fc4aec37, $fc4aec37
exception number : 3
exception class : EAccessViolation
exception message : Access violation at address 0053F4B8 in module 'heidisql.exe'. Read of address 0000005C.

main thread ($20d0):
0053f4b8 +00c heidisql.exe Controls TControl.GetClientWidth
00576089 +041 heidisql.exe Buttons TSpeedButton.MouseUp
00541e50 +038 heidisql.exe Controls TControl.DoMouseUp
00541ecc +070 heidisql.exe Controls TControl.WMLButtonUp
005414b0 +2d4 heidisql.exe Controls TControl.WndProc
00545d78 +568 heidisql.exe Controls TWinControl.WndProc
00567c68 +594 heidisql.exe Forms TCustomForm.WndProc
005410d4 +024 heidisql.exe Controls TControl.Perform
00545418 +02c heidisql.exe Controls TWinControl.MainWndProc
005410d4 +024 heidisql.exe Controls TControl.Perform
005456a4 +0ac heidisql.exe Controls TWinControl.IsControlMouseMsg
00545bf4 +3e4 heidisql.exe Controls TWinControl.WndProc
00545418 +02c heidisql.exe Controls TWinControl.MainWndProc
00499d08 +014 heidisql.exe Classes StdWndProc
77577df5 +00a USER32.dll DispatchMessageW
00570d69 +11d heidisql.exe Forms TApplication.ProcessMessage
00570dae +00a heidisql.exe Forms TApplication.HandleMessage
005710d9 +0c9 heidisql.exe Forms TApplication.Run
007198bd +0d9 heidisql.exe heidisql 66 +18 initialization
773f3675 +010 kernel32.dll BaseThreadInitThunk

thread $1d68 (TWorkerThread):
762a0810 +92 KERNELBASE.dll WaitForSingleObjectEx
773f117f +3e kernel32.dll WaitForSingleObjectEx
773f1133 +0d kernel32.dll WaitForSingleObject
005cd75d +19 heidisql.exe VirtualTrees TWorkerThread.Execute
004606e7 +2b heidisql.exe madExcept HookedTThreadExecute
00497836 +42 heidisql.exe Classes ThreadProc
004067f8 +28 heidisql.exe System 548 +0 ThreadWrapper
004605c9 +0d heidisql.exe madExcept CallThreadProcSafe
00460633 +37 heidisql.exe madExcept ThreadExceptFrame
773f3675 +10 kernel32.dll BaseThreadInitThunk
>> created by main thread ($20d0) at:
005cd652 +16 heidisql.exe VirtualTrees TWorkerThread.Create

thread $21e0:
773f3675 +10 kernel32.dll BaseThreadInitThunk

thread $20b8:
773f3675 +10 kernel32.dll BaseThreadInitThunk

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