int inquire_nocb(sqlite3 *db)
{
int nrow,ncolumn;
char **azresult;
char *sql;
char *errmsg = NULL;
int i;
sql = "select * from txl;";
if(sqlite3_get_table(db,sql,&azresult,&nrow,&ncolumn,&errmsg) != SQLITE_OK)
{
printf("遍历失败!%s\n",errmsg);
exit(-1);
}
printf("row: %d column: %d\n",nrow,ncolumn);
for(i = 0;i < (nrow + 1) * ncolumn;i++)
{
printf("%15s",azresult[i]);
if((i+1) % ncolumn ==0)
printf("\n");
}
sqlite3_free_table(azresult);
}
{
int nrow,ncolumn;
char **azresult;
char *sql;
char *errmsg = NULL;
int i;
sql = "select * from txl;";
if(sqlite3_get_table(db,sql,&azresult,&nrow,&ncolumn,&errmsg) != SQLITE_OK)
{
printf("遍历失败!%s\n",errmsg);
exit(-1);
}
printf("row: %d column: %d\n",nrow,ncolumn);
for(i = 0;i < (nrow + 1) * ncolumn;i++)
{
printf("%15s",azresult[i]);
if((i+1) % ncolumn ==0)
printf("\n");
}
sqlite3_free_table(azresult);
}