[BUG] Overflow converting decimal to currency

[expired user #8582]'s profile image [expired user #8582] posted 9 years ago in General Permalink
This error has been in heidi since forever, I'd be thankful for a fix.

date/time : 2014-12-16, 14:11:48, 458ms
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : Portuguese
system up time : 17 days 21 hours
program up time : 35 seconds
processors : 8x Intel(R) Core(TM) i7-2630QM CPU @ 2.00GHz
physical memory : 3013/8099 MB (free/total)
free disk space : (C:) 415,25 GB
display mode : 1366x768, 32 bit
process id : $16c4
allocated memory : 77,79 MB
largest free block : 8185,47 GB
executable : heidisql.exe
exec. date/time : 2014-11-11 20:38
version : 9.1.0.4867
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $5a550c46, $ea0405e9, $9a968fe0
exception number : 1
exception class : EVariantOverflowError
exception message : Overflow while converting variant of type (Decimal) into type (Currency).

main thread ($2150):
0049055e heidisql.exe System.Variants VarOverflowError
00490a5e heidisql.exe System.Variants VarResultCheck
00495af1 heidisql.exe System.Variants VarToCurrencyViaOS
00496103 heidisql.exe System.Variants @VarToCurrency
00a37395 heidisql.exe Data.Win.ADODB VarToBuffer
00a37cdd heidisql.exe Data.Win.ADODB TCustomADODataSet.GetFieldData
009e3404 heidisql.exe Data.DB TField.GetData
009ef3a2 heidisql.exe Data.DB TBCDField.GetValue
009eef31 heidisql.exe Data.DB TBCDField.GetAsString
009e2e89 heidisql.exe Data.DB TField.GetAsAnsiString
00a8b8b0 heidisql.exe dbconnection 5513 +16 TAdoDBQuery.Col
00c27edf heidisql.exe Main 8191 +28 TMainForm.AnyGridGetText
008eb35f heidisql.exe VirtualTrees 35268 +2 TCustomVirtualStringTree.DoGetText
008e9d7c heidisql.exe VirtualTrees 34775 +7 TCustomVirtualStringTree.GetText
008eb2a7 heidisql.exe VirtualTrees 35257 +26 TCustomVirtualStringTree.DoGetNodeWidth
008db7ca heidisql.exe VirtualTrees 28548 +109 TBaseVirtualTree.GetDisplayRect
00c2aa90 heidisql.exe Main 8719 +28 TMainForm.AutoCalcColWidth
00c14d6f heidisql.exe Main 4854 +167 TMainForm.DataGridBeforePaint
008c8f89 heidisql.exe VirtualTrees 21198 +2 TBaseVirtualTree.DoBeforePaint
008e18aa heidisql.exe VirtualTrees 31781 +5 TBaseVirtualTree.PaintTree
008d3677 heidisql.exe VirtualTrees 25419 +22 TBaseVirtualTree.Paint
006a4006 heidisql.exe Vcl.Controls TCustomControl.PaintWindow
0069adb3 heidisql.exe Vcl.Controls TWinControl.PaintHandler
0069bc4f heidisql.exe Vcl.Controls TWinControl.WMPaint
006a3f98 heidisql.exe Vcl.Controls TCustomControl.WMPaint
008c55b1 heidisql.exe VirtualTrees 19414 +8 TBaseVirtualTree.WMPaint
0040cb1e heidisql.exe System TObject.Dispatch
00693453 heidisql.exe Vcl.Controls TControl.WndProc
0069ab1e heidisql.exe Vcl.Controls TWinControl.WndProc
008d7f7b heidisql.exe VirtualTrees 27144 +32 TBaseVirtualTree.WndProc
00699d5a heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da693 heidisql.exe System.Classes StdWndProc
771811f1 ntdll.dll KiUserCallbackDispatcher
76f26e67 USER32.dll DispatchMessageW
00812f6f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00812fe3 heidisql.exe Vcl.Forms TApplication.HandleMessage
008134cf heidisql.exe Vcl.Forms TApplication.Run
00c57d87 heidisql.exe heidisql 77 +24 initialization
770259eb kernel32.dll BaseThreadInitThunk

main thread ($2150), inner exception level 1:
>> EVariantOverflowError, Overflow while converting variant of type (Decimal) into type (Currency)
0049055e heidisql.exe System.Variants VarOverflowError
76f29e99 USER32.dll GetMessageW
004ec666 heidisql.exe madExcept HandleException
004f9184 heidisql.exe madExcept InterceptAHandleExcept
00699d7e heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da693 heidisql.exe System.Classes StdWndProc
771811f1 ntdll.dll KiUserCallbackDispatcher
76f26e67 USER32.dll DispatchMessageW
00812f6f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00812fe3 heidisql.exe Vcl.Forms TApplication.HandleMessage
008134cf heidisql.exe Vcl.Forms TApplication.Run
00c57d87 heidisql.exe heidisql 77 +24 initialization
770259eb kernel32.dll BaseThreadInitThunk
[expired user #8582]'s profile image [expired user #8582] posted 9 years ago Permalink
This happens when clicking the 'Data' tab on a table with columns of the following types: CHAR, BIT, VARCHAR, TEXT, DATETIME and NUMERIC. The database is an SQL Server 2008 database.

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