Hi,
Very simple, What will be the output of printf("i"); it won't be 0 right?
use snprintf or sprintf and formulate the string then execute the query.
int i=0;
char * a[100];
snprintf(a,100,"insert into emp values(%d);",i); /or
/*sprintf(a,"insert into emp values(%d);",i);*/
rc = sqlite3_exec(db, "create table emp (empid num);", callback, 0, &zErrMsg);
rc = sqlite3_exec(db, a, 0, 0, &zErrMsg);
This should work.
VENKAT
Bug the Bugs
________________________________
From: RAKESH HEMRAJANI <rakesh_hemraj...@hotmail.com>
To: sqlite-users@sqlite.org
Sent: Tue, April 5, 2011 10:51:09 AM
Subject: [sqlite] insert statement using temp variable
hi,
need help with very basic question.. More of C than SQLite.
have a very simple C program using sqlite DB.
..................
int i=0;
rc = sqlite3_exec(db, "create table emp (empid num);", callback, 0, &zErrMsg);
rc = sqlite3_exec(db, "insert into emp values(i);", 0, 0, &zErrMsg);
-------------------
the insert query fails with the message stating no such column i.
the aim is very simple to insert the value of i into empid column but not sure
how to achieve it.
pls note that value of i is dynamic and wont be hardcoded.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
