This project has moved. For the latest updates, please go here.

SQLite error - no such column: minx

Topics: Data Access, SharpMap v0.9 / v1.x, WinForms Controls
Dec 15, 2008 at 9:55 PM
Edited Dec 15, 2008 at 10:54 PM
When using SQLite in v0.9 (latest) i get an SQLite error: no such column: minx

The error occurs in GetGeometriesInView with folowing command: "SELECT WKT_GEOMETRY AS Geom FROM lakes WHERE (minx < 0.5 AND maxx > -0.5 AND miny < 0.253759398496241 AND maxy > -0.253759398496241)"

Does anyone have an idea what i am overlooking?

Dec 15, 2008 at 10:12 PM
Hi jan99 are you sure that the table contains the column minx? jd
Dec 15, 2008 at 10:56 PM
Thanks John.

Yes the column is present, but an older test database function just before it didn't.
Sometimes it's too obvious.