ret = sqlite3_get_table(datb,"select * from demoF",&dbresult,&nrow,&ncolumn,&errmsg);

上面那句在頁表中有內容時可以查看頁表的字段,不過頁表中如果沒有記錄,上面那句就不能查看頁表中的字段.

不過下面這句可以查看(不管你的頁表是否有內容)

sprintf(sql,"PRAGMA table_info(%s)",str11);

我下面演示的是將頁表中的字段及其數據類型存放到數組中(部分代碼)

	ret = sqlite3_get_table(datb,"select * from demoF",&dbresult,&nrow,&ncolumn,&errmsg);
	if(ret == SQLITE_OK)
	{
		cout << "查詢到 " << nrow << " 行結果" << endl;
		//index = ncolumn;
		index = 0;
		for(int i = 0;i < nrow; i++)
		{
			printf("[%2i]",i);
			for(j = 0;j < ncolumn;j++)
			{
				printf(" %-8s",dbresult[index]);
				index++;
			}
			printf("\n");
		}
		sqlite3_free_table(dbresult);
	}
	sprintf(sql,"PRAGMA table_info(%s)",str11);
	char * lijixin[521] = {0};
	char * lijixin1[521] = {0};
	int rec = sqlite3_get_table(datb,sql,&dbresult,&nrow,&ncolumn,&errmsg);
	if(ret == SQLITE_OK)
	{
		cout << "查詢到 " << nrow << " 行結果" << endl;
		index = ncolumn;
		int count1 = index + 1;
		int count2 = index + 2;
        for(int i = 0;i <= nrow; i++)
		{
             lijixin[i] = dbresult[count1];
             printf("%s",dbresult[count1]);
            // if( dbresult[count2] == "1")
			 cout << " " ;
			 lijixin1[i] = dbresult[count2];
                 printf("%s",dbresult[count2]);

             count1+= ncolumn;
             count2+= ncolumn;
			 cout << endl;
           strcat(lijixin[i], " ");
            strcat(lijixin[i], lijixin1[i]);
           cout << lijixin[i] << endl;
		}
       /*  cout << "nihao" << endl;
		for(int i = 0;i < 3;i++)
		{
			cout << lijixin[i] << endl;
		}*/

		sqlite3_free_table(dbresult);
	}

運行結果