sqliteÒÆÖ²ÎÊÌâ
ÎÒÏÖÔÚÊÖÍ·ÓÐÕâôһ¸öÎÊÌ⣬ÎÒÏëÈÃÒ»¸ö²Ù×÷sqlite3µÄ³ÌÐòÔÚÒ»¸öARM°å×ÓÉÏÅÜÆðÀ´£¬°å×ÓÉϵÄosÊÇwince5.0¡£
ÎÒÊÇÕâô×öµÄ£¬ÎÒÏÈ´Ósqlite3Ö÷Ò³ÏÂÔØÔ´ÂëÏÂÀ´£¬ÓÐÕâô3¸öÎļþ£ºsqlite3.c¡¢sqlite3.h¡¢sqlite3ext.h £¬»¹ÓÐÒ»¸ö½Ðsqlitedll-3_6_16.zipµÄѹËõ°ü£¬ÀïÃæ°üÀ¨sqlite3.def¡¢sqlite3.dll£¨¹ÙÍøÏÂÔØÌáʾ˵Õâ¸ödllÊÇfor windowsµÄ£©
È»ºó¸ù¾ÝÒÆÖ²QtµÄ¾Ñ飬ÎÒÏëÓ¦¸ÃÊÇÔÚ½»²æ±àÒëǰ£¬½«LINKÊôÐÔÄÚµÄÒÀÀµÏî¼ÓÉÏARMƽ̨µÄsqlite3.libÎļþ£¨Õâ¸ö¿âÎļþ£¬ÎÒÓÃvcÏÂbinĿ¼ÖеÄlib.exe³ÌÐò¸ù¾Ýsqlite3.defÎļþ£¬È»ºóÖ¸¶¨MACHINE:ARMÉú³ÉµÄ£©£¬È»ºó½«±àÒëÉú³ÉºÃµÄexe³ÌÐòÓëÏà¹ØµÄdll¿½±´µ½°å×ÓÉϼ´¿É¡£
ÓÚÊÇÎÒÒ²¾ÍÕâô×öÁË£¬½«ËùÐèÒªµÄdllÓëÉú³ÉµÄexe¿½±´µ½°å×ÓÉÏÔËÐУ¬½á¹ûÌáʾ¸ÃÓ¦ÓóÌÐò²»ÊÇÓÐЧµÄwindows ceµÄÓ¦ÓóÌÐò¡£ÎÒ²ÂÏëÎÊÌâ¿ÉÄܳöÔÚsqlite3.dllÉÏ£¬ËùÒԾͽ«¸Õ²ÅÄǸö³ÌÐòÈ¥µô¶ÔÊý¾Ý¿âµÄËùÓвÙ×÷£¬ÒÔ¼°Ïà¹ØµÄÒÀÀµÏÔÙ´ÎÉú³Éexe¿½±´µ½°å×ÓÉÏ£¬½á¹ûÔËÐгɹ¦¡£
ÓÚÊÇÎÒÎÊÁ˼¸¸öʦÐÖ£¬È·ÈÏÁËÒ»´ÎÎҵIJÂÏ룺ÐèÒª¶ÔӦƽ̨ÉϵÄdll¡£ÓÚÊÇÎÒÏëµ½ÄãÉÏ¿ÎÌáµ½¿ÉÒÔÓÃIDEÉú³Édll£¬ÓÚÊÇÎÒʹÓÃvs¡¢evc£¬½á¹û×ÜÊǸ÷ÖÖ´íÎóµ¼ÖÂʧ°Ü¡£
²»ÖªµÀÎÒÕâô¸ö˼·¶Ô²»¶Ô£¬ÊÇ·ñÊÇÐèÒª×Ô¼ºÉú³ÉËùÐèµÄdll£¿Í¨¹ý¹Ù·½ÌṩµÄÕâЩԴ´úÂëºÍÎļþÓÖÈçºÎÉú³ÉËùÐèµÄdllÄØ£¿ÊÇ·ñÓÐÏà¹ØµÄÎĵµ×ÊÁÏ¿ÉÒԲο¼£¿
ss
×Ô¼º±àÒë¾ÍºÃÁË£¬
¾ßÌå¿´ÎҵIJ©Îİɡ£¡£ºÇºÇ
http://blog.csdn.net/ExclusivePig/archive/2009/09/18/4566255.aspx
Ï£Íû¶ÔÄãÓÐËù°ïÖú
ÒѾ½â¾ö£¬ÓÐÎÊÌâ¿ÉÒÔ·¢luohui8891@gmail.comºÍÎÒ¹µÍ¨¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎʸ÷λ´óϺ£¬ËÓÐSQLITE´æÍ¼Æ¬Â·¾¶µÄ´úÂë»òÀý×Ó°¡£¬Çë°ïæ¸øÐ¡µÜ·¢Ò»¸ö£¬tiandaliubin@163.com ÕæµÄºÜ¼±°¡¡£ÏÈллÁË¡£
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
ÒýÓÃ
http://www.sql ......
mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");
ÎÒÏë°Ñ½á¹¹Ìå±äÁ¿stu.szNumberÖеÄÄÚÈÝ´æ´¢µ½Êý¾Ý ......
.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬
±¨Ê²Ã ......
delphiÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
Êý¾Ý¿âÒѾÁ¬Í¨ÁË, ²åÈë»á±¨´í£¬no query specified
with dm.ASQLite3Query1 do
begin
dm.ASQLite3Query1.Close;
dm.ASQLite3 ......
ÎÒÓÐÒ»·ÝsqliteÊý¾Ý¿âÎļþ£¬µ«²»ÖªµÀÀïÃæµÄ±íÃû£¬ÈçºÎö¾Ù³öËùÓеıíÃûÒÔ¼°Æä×Ö¶ÎÃû£¿£¿
¹Ø¼üÊÇsqliteµÄsqlÓï¾äÈçºÎд£¿ÎÒÊÔÁËһЩsqlÓï¾ä²»ÐУ¬ÌØÀ´ÇóÖú¡£
×Ö¶ÎÃû¡¡ÔòÎÞ·¨Ïó±íÃûÒ»Ñù´ÓÊý¾Ý¿âϵͳ±íÖÐÖ±½Ó ......