This post should perhaps be in a bug report…
The exception shown below is thrown when drawing features from an SQLite database on a system with ‘,’ (comma) as decimal separator.
Changing the decimal to ‘.’ (dot) will avoid the exception.
Exception:
System.Data.SQLite.SQLiteException was unhandled
HResult=-2147467259
Message=SQL logic error or missing database
near “,”: syntax error
Source=WpfDesktopEdition
ErrorCode=1
StackTrace:
at ThinkGeo.MapSuite.WpfDesktopEdition.Tile.<>c__DisplayClass6.<DrawException>b__4()
The error was experienced in evaluation version of WPF Desktop Edition 8.0
Exception drawing features from SQLite with ',' as decimal separator
Hi Peter,
Sorry that it’s unable to recreate it on our end, would you please send a demo data to us for test? If it’s a bit big, please contact sales@thinkgeo.com for a FTP address. Also you can send it to forumsupport@thinkgeo.com.
Thanks,
Johnny
Hi Johnny,
Demo data with full exception details are attached to this post.
My test was based on this sample:
WpfDesktopEditionSample_EditAttributeOfShapefile_CS_110306
with an SqliteFeatureLayer added to overlay the source shape file.
Steps to reproduce on my system (Win 7):
Control Panel | Clock, Language and Region | Change the date, time or number format | … | Customize Format
Decimal symbol=’,’ -> exception (those are my default nation settings)
Decimal symbol=’.’ -> map displays all right
For consistency I changed the ‘Digit Grouping Symbol’ to avoid a clash with the decimal symbol.
Thanks,
Peter
Hi Peter,
Seems like all works fine on our end, would you please attached a demo for us? Here as following are the screenshot what we got:
Thanks,
Johnny
Hi Johnny,
A Visual Studio WPF solution will be forward via ftp. I need to get relevant info as per your former post.
Point it to the SQLite database of my former post.
Thanks,
Peter
Hi Peter,
We have fixed this bug, and you can get the latest version 8.0.247.0 or higher version for it.
Thanks,
Hi Don,
I’ve downloaded and tested Evaluation Production version 8.0.0.250.
The bug persists in that one.
But perhaps I’m missing something here.
The Evaluation Development version I currently see in the ThinkGeo Product Center is 8.0.238.0 and that one’s well below the version you mention.
Am I doing anything wrong here or is there another link for downloading the version you mention?
Thanks,
Peter
Hi Peter,
Please don’t download Evaluation Production version, because our nearest fix only contained in Development version.
I have let our Product center manager knows the development version haven’t been updated in Product Center, I think they will handle that today.
Thanks for let us know that.
Regards,
Don
Hi Don,
Fix is confirmed on 8.0.252.0.
Thanks,
Peter
Hi Peter,
Great! Please keep info us if you have more queries.
Thanks,
Howard