Hello Dan
Are you using sqlite3_prepare() or sqlite3_prepare_v2()? If the former, try switching to prepare_v2() then checking the error message again.
The former. I've switched to V2.
One possibility is that you're hitting one of the r-tree tables built-in constraints by specifying a record with (minval > maxval) for one or more of the dimensions.
Excellent call. I've been inserting lat,long,lat,long rather than lat,lat,long,long - the CREATE VIRTUAL TABLE statement having been copied & pasted from the online example.
Apologies for the noise. Many thanks :) Jerry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users