On Wed, Jan 18, 2012 at 11:15 AM, g...@novadsp.com <g...@novadsp.com> wrote:

> One more oddity. Can anyone help?
>
> 1. Create a 2D index as per documentation:
>
> "CREATE VIRTUAL TABLE gps_index USING rtree(id,minX, maxX,minY, maxY)"
>
> 2. Create a statement using a binding string:
>
> "INSERT INTO gps_index VALUES(last_insert_rowid(), ?, ?, ?, ?)"
>
> 3. Bind values. Binding indices run from 1 to 4. This works.
>
> 4. Call sqlite3_step(). This now returns a 1 - SQLITE_ERROR.
>

What does sqlite3_errmsg() say?



>
> Thx++
>
> Using SQLite version 3.7.7.1 built with SQLITE_ENABLE_RTREE=1
> (Windows/VS2008)
>
>
> ______________________________**_________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to