[sqlite] System.Data.SQLite: The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column

Windows 7 64bit SQLite version 3.17.0 sqlite-netFx46-static-binary-x64-2015-1.0.104.0 Note: The code is working correctly with Devart ODBC driver for SQLite 2.1.4 The problem is with System.Data.SQLite How to reproduce: ON SQLite Create database N:\SqLite\outStream.db CREATE TABLE FromNum (id

Re: [sqlite] Need help with System.Data.SQLite

onverted to real (double) floating point numbers, each to the closest possible approximation (or, if the approximation is not "close enough", as text !!!). -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Bur

Re: [sqlite] Need help with System.Data.SQLite

a close look at what is being fed into the other numeric columns. I doubt these are SqlDecimals too. Burtsev, Dmitriy schrieb am 10.01.2017 um 15:33: > Thank you for response. > > It looks like we are on different pages here. Let me start from the beginning. > > We are moving data

Re: [sqlite] Need help with System.Data.SQLite

Thank you for response. It looks like we are on different pages here. Let me start from the beginning. We are moving data between SQLite database and Microsoft SQL Server. At this time we are using Excel files but we run into some Excel limitation. I am trying to change Excel files to SQLite

[sqlite] Need help with System.Data.SQLite

Is this a right mail group for System.Data.SQLite ? -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Burtsev, Dmitriy Sent: Thursday, January 05, 2017 9:08 AM To: 'sqlite-users@mailinglists.sqlite.org' Subject: [sqlite] Need help

[sqlite] Need help with System.Data.SQLite.SQLiteDataReader and NUMERIC(5, 5) column

Hello I got this error: Exception calling "WriteToServer" with "1" argument(s): "The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column." How to reproduce. 1. On SQLite execute this statements. CREATE TABLE FromNum ( id