Re: [sqlite] Simple example for dummy user writing C code

[My Name]

I don't quite understand blobs yet so help is needed...

Here's my database:

CREATE TABLE foo
(
 a  INT,
 b  TEXT,
 c  BLOB
);

int write_foo(int a, char *b, void *c, size_t len)
{
  int i;
  char cmd[1024];
  sqlite3_stmt *stmt;

  sprintf(cmd, "UPDATE foo SET c=? WHERE a=%d AND b='%s';", a, b);

  i = sqlite3_prepare_v2(db, cmd, strlen(cmd)+1, &stmt, NULL);
  if (i != SQLITE_OK) printf("1 i=%d\n", i);

  i = sqlite3_bind_blob(stmt, 1, c, len, NULL);
  if (i != SQLITE_OK) printf("2 i=%d\n", i);

  i = sqlite3_step(stmt);
  if (i != SQLITE_OK) printf("3 i=%d\n", i);

  printf("i=%d\n", i)
  return i;
}

What am I doing wrong here?

I'm always getting "3 i=101" but if I use the command line tools and
do "select * from foo;" I see nothing, like the database is empty and
update didn't work.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users