Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

cb2010ÔõôʹÓÃSQLiteÊý¾Ý¿â£¿

×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£

ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI

ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿

2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ

ÒýÓÃ
ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿

ºÃÏñCB2010ûÓÐÌṩ·ÃÎÊSQLITEµÄ×é¼þ.


ÒýÓÃ
ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI


µÚÒ»,ÎÒ²»ÖªµÀÄÄÀïÏÂÔØÕâ¸öDLL
µÚ¶þ,ÓÐûÓо²Ì¬µÄµ÷Ó÷½·¨?


È¥sqlite¹ÙÍøÓÐdllÏÂÔغÍÔ´´úÂë¡£
cb×Ô´øµÄ×é¼þûÓÐÖ§³ÖsqliteµÄ¡£ÓеÚÈý·½×é¼þ°üÖ§³ÖsqliteµÄ£¬Ãû×ÖÍüÁË¡£

sqliteÓÐ×Ô¼º°ü×°ºÃµÄsqlite3.dll£¬ÌṩÁ˵¼³ö½Ó¿Ú¸øÄãʹÓÃ
http://blog.donews.com/jetport/archive/2007/06/25/1179461.aspx

http://topic.csdn.net/u/20090427/10/47e56aae-0698-487e-903e-e6e1b14d6b72.html

лл¸÷λ´ó´ó»Ø¸´.
ÎÒÏÖÔÚÒѾ­¸ãºÃÁ˾²Ì¬Á´½Ó,²»ÐèÒªDLLÁË.
ÁíÍâÇëÎÊsqliteµÄsqlÓï¾äÊÇutf-8µÄ,»¹ÊÇansiµÄ?



ÒýÓÃ
µ÷Óýӿڲ»Í¬£¬¿ÉÒÔÑ¡ÔñUTF-8£¬Ò²¿ÉÒÔÑ¡ÔñUTF-16£¬Çë²Î¿´SQLiteµÄAPI
ÖÁÓÚÔÚCBÏÂʹÓ㬿ÉÒÔÓÃASQLite C++ ·â×°
Ò²¿ÉÒÔÑ¡Ôñ SQLite µÄ ODBC Çý¶¯ http://www.ch-werner.de/sqliteodbc/
ºÍ DISQLite3 µÈ

µ«ÊÇ SQLite ÔÚCBϵķâ×°£¬ºÃÏñ¶¼²»Ì«ÀíÏ룬ֱ½ÓÓÃAPIµÄ»°£¬»Øµ÷±È½ÏÂé·³£¬²»¹ý¼æÈÝÐԷdz£ºÃ£¬¶øÇÒÊý¾Ý¿â´æÈ¡³¬¿ì£¨ÄÚ´æģʽÏ£©


Õâλ´ó´ó£¬Çë¸æËßÎÒSQLÓï¾äµÄUTF-16·½Ê½ÈçºÎµ÷Óã¿

{{----


Ïà¹ØÎÊ´ð£º

ÈçºÎÔÚsqliteÖÐɾ³ýÇ°NÌõ¼Ç¼

ÈçÌ⣬ûÓÐÖ÷¼ü£¬ÎÒֻҪɾ³ýÇ°NÌõ¼Ç¼¡£nÊýÖµ´ó¸ÅÔÚǧÍò¼¶±ðµÄ¡£
ûÓÐÖ÷¼ü

ÓÐûÓÐÆäËü¿É¹©ÅÅÐòµÄ×ֶΣ¿

SQL code:
delete from tb where id in (select top n id from tb)

ÒýÓÃ
ûÓÐÖ÷¼ü

......

ÐÂÏîÄ¿ÐèҪʹÓÃsqlite,ÇëÎÊÔõôÏÂÔغʹʹÓû·¾³

ÎÒÏÖÔÚ¿ªÊ¼×öÒ»¸öÐÂÏîÄ¿,ÐèÒªÊÇÓÃEVC+SqliteµÄ»·¾³,µ«ÎÒûÓùýSqlite,Çë´ó¼Ò¸øµã½¨Òé,лл!!
sqlite ºÜ¼òµ¥£¬Ö±½Óµ½ËüµÄ¹ÙÍøÏÂÔØ sqlite3.exe ¾ÍÐÐÁË£¬ÆäËüʲô¶¼²»ÐèÒª¡£
È»ºó¾ÍÊÇÏÂÔØÄãÐèÒªµÄÇý¶¯¡£

µ±ÄúµÄ ......

ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂë

ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂ룬½â˵ԽÏêϸԽºÃ£¬ÒòΪÎÒ»¹Ã»ÓÐÓùýSQLite£¬Ð»Ð»£¡
Éϴζ¼²»¸øÎÒ·Ö¡£¡£
×¢²ásqltp30.dllÕâ¸öActiveX DLL
ÓÃÀïÃæµÄSQLiteDBÀཨÁ¢¡¢Á¬½ÓÊý¾Ý¿âÎļþ£¬¾ÍÏñADODBÀïµÄConnecti ......

SQLite·µ»ØµÄÖÐÎļǼÊÇÂÒÂë

WTL¿ò¼ÜʹÓÃUnicode×Ö·û¼¯
ÓÃÏÂÃ溯Êý²åÈë¼Ç¼
void CMainFrame::Insert()
{
TCHAR query[MAX_PATH] = {0};
_stprintf(query, _T("insert into correct_word values (\'發\',\& ......

WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ

.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬

±¨Ê²Ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ