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.

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

Reply via email to