Eveyone has been a great help, I belive that I wil have to back to the 3dr party vendor to have them change the schema to fit teh actual data...
Thanks Jay ________________________________________ From: [email protected] [[email protected]] on behalf of Joe Mistachkin [[email protected]] Sent: Friday, April 06, 2012 2:28 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Integer Truncation Issue Jay Howard wrote: > > I have gone as far as > > Modifying the table but still no dice.. > Maybe I have to drop and recreate the table? > How did you change the data type of the column without dropping and re-creating the table? As others have said, System.Data.SQLite uses the declared types in the table schema to map the values to .NET Framework types. Therefore, if you want double values, you should use DOUBLE. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
