ERROR when selecting a foreign key value from dropped table

[expired user #5249]'s profile image [expired user #5249] posted 13 years ago in General Permalink
error:
it appears when selecting values on tableA.columnX that has a foreign key constraint on tableB.columnY while tableB has already been dropped so the data editor tries to fetch all possible values from tableB and ends up in an error.

solution:
check whether there are such tables the foreign keys are referring to before fetching the data into the data editor.

date/time : 2010-11-28, 23:00:41, 36ms
computer name : xxx
user name : xxx <admin>
registered owner : Microsoft / Microsoft
operating system : Windows 7 x64 build 7600
system language : German
system up time : 3 hours 37 minutes
program up time : 6 minutes 48 seconds
processors : 2x Pentium(R) Dual-Core CPU T4500 @ 2.30GHz
physical memory : 2706/4094 MB (free/total)
free disk space : (C:) 117,55 GB
display mode : 1920x1080, 32 bit
process id : $c70
allocated memory : 72,75 MB
executable : heidisql.exe
exec. date/time : 2010-11-28 22:03
version : 6.0.0.3619
compiled with : Delphi 2010
madExcept version : 3.0k
callstack crc : $0bb566d0, $93a21afe, $93a21afe
exception number : 2
exception class : EDatabaseError
exception message : SQL Error (1146): Table 'xxx' doesn't exist.

main thread ($c8c):
0075aad6 heidisql.exe mysql_connection 687 +18 TMySQLConnection.Query
0076103e heidisql.exe mysql_connection 2086 +4 TMySQLQuery.Execute
0075b767 heidisql.exe mysql_connection 924 +5 TMySQLConnection.GetResults
0075c11a heidisql.exe mysql_connection 1113 +1 TMySQLConnection.GetVar
006d3a22 heidisql.exe Main 7407 +11 TMainForm.AnyGridCreateEditor
0061c5fc heidisql.exe VirtualTrees TBaseVirtualTree.DoCreateEditor
00630145 heidisql.exe VirtualTrees TCustomVirtualStringTree.DoCreateEditor
0061cbb3 heidisql.exe VirtualTrees TBaseVirtualTree.DoEdit
0053b56e heidisql.exe Controls TControl.WMMouseMove
0061a268 heidisql.exe VirtualTrees TBaseVirtualTree.WMTimer
0053ac48 heidisql.exe Controls TControl.WndProc
0053f510 heidisql.exe Controls TWinControl.WndProc
00625518 heidisql.exe VirtualTrees TBaseVirtualTree.WndProc
0053ebb0 heidisql.exe Controls TWinControl.MainWndProc
0049a5dc heidisql.exe Classes StdWndProc
76b07df5 USER32.dll DispatchMessageW
0056b311 heidisql.exe Forms TApplication.ProcessMessage
0056b356 heidisql.exe Forms TApplication.HandleMessage
0056b681 heidisql.exe Forms TApplication.Run
007a673a heidisql.exe heidisql 66 +15 initialization
75093675 kernel32.dll BaseThreadInitThunk
ansgar's profile image ansgar posted 13 years ago Permalink
Yes, this should be a handled exception. Will check.
Code modification/commit from ansgar.becker, 13 years ago, revision 6.0.0.3621
Silence SQL exception in grid editing when foreign table is not accessible. See http://www.heidisql.com/forum.php?t=7070
ansgar's profile image ansgar posted 13 years ago Permalink
Exception silenced in r3621

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