Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÀÏÊDZ¨´íno such column

SELECT qsmallClass.Sname, qproducts.pmodel, qproducts.punit, qmaintain.mcount from qsmallClass INNER JOIN (qproducts INNER JOIN qmaintain ON qproducts.pid = qmaintain.pid) ON qsmallClass.Sid = qproduc ......

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

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

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

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

ÒýÓÃ
ûÓÐÖ÷¼ü

......

sqlite ²»Ö§³Ölast()?


Java code:

stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from table");//±¨´íµÄÐÐ
rs.last()

ÓÃrs.last( ......

help£¡SQLiteÖвÙ×÷blobÀàÐ͵Ä×ֶεÄÎÊÌâ

ÕâÊÇÎҲ鵽µÄ×ÊÁÏ
http://www.cppprog.com/2009/0108/43.html ÒѾ­´æ½øÍ¼Æ¬ÁË£¬ÏÖÔÚ×öµ½ÕâÒ»²½ÁË£¬
¡°ÕâʱÊý¾Ý¿âµ±ÖÐÒѾ­ÓÐÁËÒ»Ìõ°üº¬BLOB×ֶεÄÊý¾Ý¡£½ÓÏÂÀ´ÎÒÃÇÒª¶ÁÈ¡ÕâÌõÊý¾Ý£º  1.  //ѡȡ¸ÃÌõ ......

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

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

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