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 in
) are all converted 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
bhezf4.aspx).
Also have 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.
>
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 d
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]
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
6 matches
Mail list logo