Re: [sqlite] System.Data.SQLite INT vs INTEGER

Hello, You can take a look at http://sqlite.phxsoftware.com/forums/t/31.aspx where you can find the DataType mappings for the .NET provider. Be careful also with DOUBLE -> DbType.Double FLOAT -> DbType.Double REAL -> DbType.Single Xevi 2011/5/19 Joe D : > > I have an app that creates a table o

Re: [sqlite] bug in the RTree module

Hi, I think there has to be something wrong with the first insert that you do in a RTree table. If before copying the records to the virtual table you do a dummy insert then everything works OK. sqlite> CREATE VIRTUAL TABLE test_rtree USING RTREE(pkid, xmin, xmax, ymin, ymax); sqlite> INSERT INTO