How to figure out a Cast Error?
Using Tokyo and Latest FR6 ...
One thing i've struggled with is this error on tracking down the offending field that is causing it.
Some of my reports get overly dumb complex and query heavy and its hard to track down on a customers system sometimes.
It would be nice to actually somehow figure out the field that failed from FormatData ?
One thing i've struggled with is this error on tracking down the offending field that is causing it.
exception class    : EVariantTypeCastError
exception message  : Could not convert variant of type (String) into type (Double).
main thread ($b94):
00470a97 +06f CMW.exe      System.Variants  679  +1 VarCastError
00470ede +01a CMW.exe      System.Variants  748  +3 VarResultCheck
00473be3 +08f CMW.exe      System.Variants  2537  +9 VarToDoubleAsString
00473f09 +1e9 CMW.exe      System.Variants  2612  +30 @VarToDouble
00474118 +008 CMW.exe      System.Variants  2646  +1 @VarToReal
00d4791d +205 CMW.exe      frxClass        9033  +21 TfrxCustomMemoView.FormatData
00d47563 +3e3 CMW.exe      frxClass        9001  +67 TfrxCustomMemoView.CalcAndFormat
00d46ed6 +3ca CMW.exe      frxClass        8886  +58 TfrxCustomMemoView.GetData
00ceeec4 +14c CMW.exe      frxEngine        1830  +33 TfrxEngine.Stretch
00cf19f3 +223 CMW.exe      frxEngine        2796  +58 TfrxEngine.DoShow
00cee6ca +05a CMW.exe      frxEngine        1638  +8 TfrxEngine.ShowBand
00ced286 +47a CMW.exe      frxEngine        1226  +84 ShowBandTree
00ceda7c +114 CMW.exe      frxEngine        1367  +12 ShowPage
00cedd5e +102 CMW.exe      frxEngine        1418  +27 TfrxEngine.RunPage
00ceb2c1 +0e5 CMW.exe      frxEngine        514  +14 DoPages
00ceb31e +026 CMW.exe      frxEngine        523  +3 TfrxEngine.RunReportPages
00ceaf42 +1b2 CMW.exe      frxEngine        435  +37 TfrxEngine.Run
00d558e3 +1df CMW.exe      frxClass        13517  +43 TfrxReport.PrepareReport
0197bf8a +372 CMW.exe      dm_FastReports    511  +73 tCMFastReports.ShowReport
0197f950 +788 CMW.exe      dm_Reports        514 +105 TdmReports.InvoiceReport
Some of my reports get overly dumb complex and query heavy and its hard to track down on a customers system sometimes.
It would be nice to actually somehow figure out the field that failed from FormatData ?
Comments
If I run the same deal logged in, it works fine.
If ran from Session 0 , I noticed ALOT of variant conversion errors.
Possibly something SetThreadLocale / Locale related and Session 0 with FR ?