Bug report: Crash editing Trigger

Syntax error clicking on trigger to open.

SELECT SYSTEM_USER;
SHOW TRIGGERS FROM "SANDBOX";
/* SQL Error (156): Incorrect syntax near the keyword 'FROM'. */




date/time : 2015-05-26, 08:50:38, 314ms
computer name : NERIAD
user name : Russell
registered owner : xxxxxxxxxxxxxxxxxx/ Hewlett-Packard
operating system : Windows 8 Tablet PC x64 build 9200
system language : English
system up time : 4 days 23 hours
program up time : 36 seconds
processors : 8x Intel(R) Core(TM) i7-4710HQ CPU @ 2.50GHz
physical memory : 11935/16310 MB (free/total)
free disk space : (C:) 137.74 GB
display mode : 1920x1080, 32 bit
process id : $d09c
allocated memory : 87.20 MB
largest free block : 131029.99 GB
executable : heidisql.exe
exec. date/time : 2015-05-02 13:40
version : 9.2.0.4947
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $2ef15873, $32ba9be2, $e5935a1c
exception number : 1
exception class : EDatabaseError
exception message : SQL Error (156): Incorrect syntax near the keyword 'FROM'.

main thread ($d214):
00a72f8a heidisql.exe dbconnection 2396 +47 TAdoDBConnection.Query
00a8bb10 heidisql.exe dbconnection 5218 +3 TAdoDBQuery.Execute
00a7b30a heidisql.exe dbconnection 3236 +5 TDBConnection.GetResults
00aceb93 heidisql.exe trigger_editor 113 +20 TfrmTriggerEditor.Init
00c33ee7 heidisql.exe Main 9613 +17 TMainForm.PlaceObjectEditor
00c2a1a8 heidisql.exe Main 7799 +69 TMainForm.DBtreeFocusChanged
008ca980 heidisql.exe VirtualTrees 21679 +2 TBaseVirtualTree.DoFocusChange
008d12cc heidisql.exe VirtualTrees 24334 +243 TBaseVirtualTree.HandleMouseDown
008c5115 heidisql.exe VirtualTrees 19184 +6 TBaseVirtualTree.WMLButtonDown
0040cb1e heidisql.exe System TObject.Dispatch
008d8205 heidisql.exe VirtualTrees 27131 +19 TBaseVirtualTree.WndProc
0069a07a heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da9b3 heidisql.exe System.Classes StdWndProc
7ffe5fc6 user32.dll DispatchMessageW
0081328f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00813303 heidisql.exe Vcl.Forms TApplication.HandleMessage
008137ef heidisql.exe Vcl.Forms TApplication.Run
00c5c3b7 heidisql.exe heidisql 77 +24 initialization
7ffe609e KERNEL32.DLL BaseThreadInitThunk
7ffe60b3 ntdll.dll RtlUserThreadStart

main thread ($d214), inner exception level 1:
>> EOleException, Incorrect syntax near the keyword 'FROM'
00a72cc9 heidisql.exe dbconnection 2369 +20 TAdoDBConnection.Query
7ffe5fc6 user32.dll GetMessageW
004ec956 heidisql.exe madExcept HandleException
004f9474 heidisql.exe madExcept InterceptAHandleExcept
0069a09e heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da9b3 heidisql.exe System.Classes StdWndProc
7ffe5fc6 user32.dll DispatchMessageW
0081328f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00813303 heidisql.exe Vcl.Forms TApplication.HandleMessage
008137ef heidisql.exe Vcl.Forms TApplication.Run
00c5c3b7 heidisql.exe heidisql 77 +24 initialization
7ffe609e KERNEL32.DLL BaseThreadInitThunk
7ffe60b3 ntdll.dll RtlUserThreadStart

Hi,

Loving HeidiSQL but have just hit the same error. I can work around it but if I can help improve the product by reporting this (and maybe being a guinea pig to fix) then that will be good :)

I click on a trigger listed in the right hand pane whilst browsing a sql server schema and get an error dialogue. The status window at the bottom shows it was trying to execute...

SHOW TRIGGERS FROM "myschema" which must be invalid syntax for SqlServer

Details from the bugreport generated from the error dialogue ...


date/time : 2015-05-27, 17:00:17, 814ms
computer name : DANO-REDSKYIT
operating system : Windows 8 x64 build 9200
system language : English
system up time : 7 hours 24 minutes
program up time : 18 seconds
processors : 4x Intel(R) Core(TM) i5-3230M CPU @ 2.60GHz
physical memory : 3949/8007 MB (free/total)
free disk space : (C:) 473.55 GB
display mode : 1600x900, 32 bit
process id : $293c
allocated memory : 67.69 MB
largest free block : 131029.99 GB
executable : heidisql64.r4940.exe
exec. date/time : 2015-04-17 10:54
version : 9.1.0.4940
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $0c90a431, $450d9e3b, $450d9e3b
exception number : 1
exception class : Unknown
exception message : Unknown.

main thread ($3570):
00a72dda heidisql64.r4940.exe dbconnection 2388 +47 TAdoDBConnection.Query
7ffba08c user32.dll GetMessageW
004ec956 heidisql64.r4940.exe madExcept HandleException
004f9474 heidisql64.r4940.exe madExcept InterceptAHandleExcept
0069a09e heidisql64.r4940.exe Vcl.Controls TWinControl.MainWndProc
005da9b3 heidisql64.r4940.exe System.Classes StdWndProc
7ffba08c user32.dll DispatchMessageW
0081328f heidisql64.r4940.exe Vcl.Forms TApplication.ProcessMessage
00813303 heidisql64.r4940.exe Vcl.Forms TApplication.HandleMessage
008137ef heidisql64.r4940.exe Vcl.Forms TApplication.Run
00c5ab87 heidisql64.r4940.exe heidisql 77 +24 initialization
7ffba058 KERNEL32.DLL BaseThreadInitThunk
7ffba0a5 ntdll.dll RtlUserThreadStart

Dan