我遇到了一个问题，即预准备语句和绑定值适用于Insert语句，但不适用于Select语句......下面是一段代码

int main(int argc, CHAR* argv[])
{
 sqlite3 *db; // sqlite3 db struct
  char *zErrMsg = 0;
  char *szSQL;
  int rc;

  // Open the test.db file
   rc = sqlite3_open("test32.db", &db);

   if( rc )
   {
     // failed
     fprintf(stderr, "Can't open database: %s\n", 
          sqlite3_errmsg(db));
   }
    else
  {
// success
fprintf(stderr, "Open database successfully\n");
 }

  // create myTable
 //szSQL = "create table myTable1011 (FirstName varchar(30), LastName varchar(30), Age smallint not null);";

   // rc = sqlite3_exec(db, szSQL, callback, 0, &zErrMsg);

   // if( rc == SQLITE_OK )
    // {
   //insert 1 record into myTable
    // RunInsertParamSQL(db, "asyb", "com", 42);



// fetch records

sqlite3_stmt *stmt;
const char *pzTest;

 //Doesnt WORK 

szSQL = "select * from myTable1011 where age = ?";

 rc = sqlite3_prepare_v2(db, szSQL, strlen(szSQL), &stmt, &pzTest);

if( rc == SQLITE_OK ) 

  // bind the value 

  int test = 42;

sqlite3_bind_int(stmt, 1, test);//Doesnt work if i give 42 directly instead if test in bind statement

// commit 
 sqlite3_step(stmt);
 sqlite3_finalize(stmt);
}

 // rc = sqlite3_exec(db, szSQL, callback, 0, &zErrMsg);

// Close test.db file
 sqlite3_close(db);

 getchar();

  return 0;
}

// Insert rec
//WORKS WELL
void RunInsertParamSQL(sqlite3 *db, char *fn, char *ln, int age)
{
  if (!db)
    return;

  char *zErrMsg = 0;
  sqlite3_stmt *stmt;
  const char *pzTest;
  char *szSQL;

  // Insert data item into myTable
 szSQL = "insert into myTable1011 (FirstName, LastName, Age) values (?,?,?);";

  int rc = sqlite3_prepare(db, szSQL, strlen(szSQL), &stmt, &pzTest);

  if( rc == SQLITE_OK ) {
   // bind the value 
     sqlite3_bind_text(stmt, 1, fn, strlen(fn), 0);
    sqlite3_bind_text(stmt, 2, ln, strlen(ln), 0);
    sqlite3_bind_int(stmt, 3, age);

    // commit 
     sqlite3_step(stmt);
    sqlite3_finalize(stmt);
  }
}

除了成功打开数据库外，没有其他输出
但是如果我给予szSQL =“从我的表1011中选择 *”;rc = sqlite3_exec（数据库，szSQL，回调，0，和zErrMsg）;//我得到了整个表....
如何选择性打印？？为什么Where条件失败？？？？？