ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éѯÊý¾Ý¿â£¬ÏÔʾ¿Ø¼þÉÏ£¬³öÏÖÁËÖÐÎÄÂÒÂëµÄÎÊÌ⣬Çë½ÌÒ»ÏÂÊÇʲôÔÒò
ÒýÓà Ӧ¸Ã»¹ÊDZàÂëµÄÎÊÌ⣬ ÔÙ³¢ÊÔһϸıä±àÂëÉèÖ÷½ÃæµÄ²âÊÔ ÎÒÈ·¶¨ÁË´íÎóµÄµØ·½£¬¾ÍÊÇÔÚ¶ÁÊý¾Ý¿âÊý¾Ý£¨UTF-8£©ÏÔʾÔÚlist control¿Ø¼þÊÇ£¬list¿Ø¼þÈç¹û¶Áµ½µÄÊý¾ÝΪUTF-16µÄ£¬¾ÍÕýÈ·ÁË£¬ËùÒÔÎÒÐèÒª½â¾öµÄÊÂÇé¾ÍÊÇ£¬¶ÁÊý¾Ý¿âÊý¾Ý£¨UTF-8£©£¬×ª»»ÎªUTF-16£¬È»ºóÏÔʾ£¬Ó¦¸Ã¾ÍokÁË¡£
¼ÌÐøÑо¿£¬acmain_chm£¬ÓкõĽ¨ÒéÇëÖ¸µã¹þ~~~~ÏÂÃæÊdzöÎÊÌâµÄ´úÂë¶Î
void CKLMDlg::OnRefresh()
{
int i = 0 ;
int nrow = 0, ncolumn = 0;
char **azResult=NULL; //¶þάÊý×é´æ·Å½á¹û
char *zErrMsg = 0;
int index,j;
int nItem;
int result;
CListCtrl * pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST2);
CRect rt;
pListCtrl->GetClientRect(&rt);
char *sql = "SELECT * from Fault";
/****************************************************************************************************************/
result=sqlite3_get_table( db , sql , &azResult , &nrow , &ncolumn,&zErrMsg );
index = ncolumn;
Ïà¹ØÎÊ´ð£º
»·¾³£ºQNX 6.3.2 °æ±¾£ºSQLite 2.7.3 ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ database is locked Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£ Áí£ºÔÚһ̨Íê ......
СµÜ Ūµã¶«Î÷¿ÉÊǵ÷Óà sqlite3_prepare Õâ¸öº¯Êý select ¾ÍºÃʹ Ö»Òª ¸Ä±äÊý¾Ý¿â µÄ¾Í²»ÐÐ ±ÈÈçinsert Ö®ÀàµÄ ËÀ´°ï¸öæ°¡ ÇëÎÊÕâÊÇʲôÔÒò °¡ Óà c ȥʵÏÖµÄ ÄãÓõÄʲô¹¤¾ß°¡? °ÑÄã×Ô¼ºµÄ´úÂë·¢ ......
ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£ ±ÈÈ磺 Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ ÒýÓà һ°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏ ......
¸ÕÈëÃÅ ÏëʵÏÖÐÂÎűíÐÂÎÅÖö¥µÄ¹¦ÄÜ select * from web_news order by id desc limit 0,6 web_news ±íÀïÓÐTOPÁÐ ÔõÑùÈÃTOPÁмǼΪ1µÄΪÖÃÇ° ¸÷λ´ó´óÃÇ°ï°ïæ ·Ö²»¶à Çë°üº£¡£¡ order ......
sqlite ÖÐ CREATE TABLE table1 ( id integer primary key autoincrement, name text default '', [index] integer default ROWID ) ÓÐûÓÐÀàËƵŦÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬ ......