呵呵, 不好意思啊, 还真如你说的, 参数在第二个子句中才出现就不行了, 只能出现在第一个子句中!
不错不错, 学习了, 看来以后我还真得要注意这地方的应用了.
我改成下面的就能运行了:
void my_test()
{
system("del db1.sdb");
int ret;
sqlite3 *pdb = 0;
sqlite3_stmt *stmt = 0;
char *error = 0;
const char *tail = 0;
int index1, index2, index3;
const void *value = "asdfadsfasdfjasdfjaksdfaskjdfakdsfaksfja";
ret = sqlite3_open("db1.sdb", &pdb); //打开数据库，跟打开文本文件一样
if( ret != SQLITE_OK )
return;
ret = sqlite3_exec(pdb, "CREATE TABLE qin_country (GROUP_NAME BLOB PRIMARY KEY, VALUES1 BLOB, VALUES2 BLOB);", 0,0, &error );
if( ret != SQLITE_OK )
return;
ret = sqlite3_exec(pdb, "insert into qin_country values('group_1234','55555','xxxxy');", 0,0, &error );
if( ret != SQLITE_OK )
return;
char *sql = "select @pa1, @pa2, @pa3 where 0>1; update qin_country set values1 = @pa1 where group_name = @pa2; update qin_country set values2 = @pa3 where group_name = @pa2; ";
//char *sql = "update qin_country set values1 = @pa1 where group_name = @pa2; update qin_country set values2 = @pa3 where group_name = @pa2; ";
//char *sql = "update qin_country set values1 = @pa1, values2=@pa3 where group_name = @pa2; ";
ret = sqlite3_prepare(pdb, sql,strlen(sql), &stmt, &tail);
if( ret != SQLITE_OK )
return;
index1 = sqlite3_bind_parameter_index(stmt, "@pa1");
ret = sqlite3_bind_blob(stmt, index1, value, strlen((char*)value), SQLITE_STATIC);
index2 = sqlite3_bind_parameter_index(stmt, "@pa2");
ret = sqlite3_bind_blob(stmt, index2, value, strlen((char*)value), SQLITE_STATIC);
index3 = sqlite3_bind_parameter_index(stmt, "@pa3");
ret = sqlite3_bind_blob(stmt, index3, value, strlen((char*)value), SQLITE_STATIC);
if( ret != SQLITE_OK )
return;
ret = sqlite3_step(stmt);
if( ret != SQLITE_DONE )
return;
sqlite3_close(pdb);
}
