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

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

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

±¨Ê²Ã´´í¶ù??
ÊDz»ÊÇ´´½¨µÄÁ¬½ÓÀàûдºÃ?
¿ÉÒÔÕý³£Á¬½ÓÊý¾Ý¿âô?


ÕâÖÖÇé¿öÓöµ½¹ý£¬Ã»ÕÒµ½Ô­Òò~±È½ÏÓôÃÆ¡£

ÕÒµ½Ô­ÒòÁË£¬¾ÍÏñweiweiloong˵µÄ£¬WinceÉÏûÓе±Ç°Â·¾¶

SQLite±È½ÏÄÕÈ˵ÄÒ»µã¾ÍÊÇ£º
Èç¹ûÕÒ²»µ½Ö¸¶¨Êý¾Ý¿â£¬¾ÍÖØ½¨Ò»¸ö¸ø¶¨Â·¾¶µÄÐÂÊý¾Ý¿â
ÕâÑùÒÔÀ´±íµ±È»Ã»ÓÐÀ²¡£¡£¡£

Á¬½Ó×Ö·û´®ÒªÉèÖþø¶Ô·¾¶


Ïà¹ØÎÊ´ð£º

sqlite »ñÈ¡×î½üÉúÈÕÓû§µÄ·½·¨£¿

1¡¢juliandayÕâ¸öº¯ÊýÖ»ÓдøÉÏÄê·Ý¼ÆËã²Å¿É¿¿£»
2¡¢ÎÒĿǰÓõķ½·¨SELECT £¨jolianday(¡®now¡¯)-jolianday(¡®1981-12-23¡¯)£©%365
3¡¢Õâ¸ö·½·¨¿Ï¶¨ÓÐÎÊÌ⣬µ«ÊµÔÚ²»ÖªµÀÔõôʵÏÖ£»
Òò´ËÏ£Íû¸÷λÈÊÐÖ°ï°ïæ£ ......

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 ......

ÇósqlÓï¾ä£¬sqliteÊý¾Ý¿â

µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
 
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:

ºÅÂë(num)      ÁªÏµÈË (relationname)     
10086          ÒÆ ......

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

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

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

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