wince 5.0 ¿ª·¢sqliteÊý¾Ý¿âµÄÎÊÌâ
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éѯÊý¾Ý¿â£¬ÏÔʾ¿Ø¼þÉÏ£¬³öÏÖÁËÖÐÎÄÂÒÂëµÄÎÊÌ⣬Çë½ÌÒ»ÏÂÊÇʲôÔÒò£¿
¼ÈÈ»Edit¿ÉÒÔ£¬Èç¹û±àÂëÊÇÒ»ÖµĻ°£¬list controlÓ¦¸ÃҲûÎÊÌâ¡£Êý¾ÝÊÇͬÑùµÄÊý¾Ýô£¿
ÊÇͬÑùµÄÊý¾Ý£¬ÎÒ»³ÒÉÓпÉÄÜÊÇÔÚ²éѯʱ£¬Ê¹ÓÃsqlite_get_table();º¯ÊýµÄʱºò·µ»ØµÄÊý¾ÝÀàÐͲ»¶Ô£¬ÓÐÏë²»³öʲô°ì·¨£¬ËùÒÔÀ´ÎÊÎÊ£¬Çë½ÌÏ¡£
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;
pListCtrl->DeleteAllItems(); <
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¡
sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.
Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string
ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......
Ä¿Ç°ÔÚ¹«Ë¾µÄlinux pcÉÏÓÐÒ»¸öSQLite server, ÎÒÏëÓÃÔÚͬ¸öÇø網µ×ϵÄwin pcÈ¥Á¬½ÓSQLite serverÓÃASP進ÐвÙ×÷, ÇëÎÊÓа취°ìµ½Âð? »¹ÊÇSQLite serverÎÞ·¨Ö§³ÖÍøÂçÁ¬½Ó....ÕÒÁËÒ»¸öÏÂÎç
剛 ......
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔظ ......
ΪʲôÓÃselect name,distinct phone from phone_book¾Í˵Óï·¨´íÎó£¬
ÓÃselect distinct phone,name from phone_book¾Í¿ÉÒÔ£¿
ûÓÐΪʲô distinct ÊÇ select µÄÐÞÊηû£¬Ö»ÄÜÔÚ select ºóÖ ......
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......