[sqlite] Prepared statements on rtree index

[Oyvind Idland]

Hi,

I am trying to insert records into a rtree table using prepared statements.
The table
is defined like this:

CREATE VIRTUAL TABLE points_index USING rtree(id, x, y);

I successfully populate the table containing geometries/attributes using
prepared stmt's.

Inserting values into the points_index table via command prompt works fine,
but I cant seem
to get prepared statements to work:


  char *sql_idx = "INSERT INTO points_index VALUES (?, ?, ?);";
  sqlite3_stmt *stmt_idx = NULL;
  const char *tail = NULL;
  rc = sqlite3_prepare(db, sql, strlen(sql_idx), &stmt_idx, &tail);
  if( rc!=SQLITE_OK )
    return sqlerror(db);

  for(i=0; i<1000000; i++)
  {
    /* Insert into index*/
    rc = sqlite3_bind_int(stmt_idx, 1, i);
    if( rc!=SQLITE_OK )
      return sqlerror(db);
    rc = sqlite3_bind_double(stmt_idx, 2, blob.x);
    if( rc!=SQLITE_OK )
      return sqlerror(db);
    rc = sqlite3_bind_double(stmt_idx, 3, blob.y);
    if( rc!=SQLITE_OK )
      return sqlerror(db);
    if (sqlite3_step(stmt_idx) != SQLITE_DONE)
      return sqlerror(db);
    sqlite3_reset(stmt_idx);
  }


The first two binds runs fine, but binding the blob.y yields
"SQL error: bind or column index out of range"

Let me know if I left out important details.

Regards,


Oyvind Idland
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users