WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ
.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬
±¨Ê²Ã´´í¶ù??
ÊDz»ÊÇ´´½¨µÄÁ¬½ÓÀàûдºÃ?
¿ÉÒÔÕý³£Á¬½ÓÊý¾Ý¿âô?
ÕâÖÖÇé¿öÓöµ½¹ý£¬Ã»ÕÒµ½ÔÒò~±È½ÏÓôÃÆ¡£
ÕÒµ½ÔÒòÁË£¬¾ÍÏñweiweiloong˵µÄ£¬WinceÉÏûÓе±Ç°Â·¾¶
SQLite±È½ÏÄÕÈ˵ÄÒ»µã¾ÍÊÇ£º
Èç¹ûÕÒ²»µ½Ö¸¶¨Êý¾Ý¿â£¬¾ÍÖØ½¨Ò»¸ö¸ø¶¨Â·¾¶µÄÐÂÊý¾Ý¿â
ÕâÑùÒÔÀ´±íµ±È»Ã»ÓÐÀ²¡£¡£¡£
Á¬½Ó×Ö·û´®ÒªÉèÖþø¶Ô·¾¶
Ïà¹ØÎÊ´ð£º
1¡¢juliandayÕâ¸öº¯ÊýÖ»ÓдøÉÏÄê·Ý¼ÆËã²Å¿É¿¿£»
2¡¢ÎÒĿǰÓõķ½·¨SELECT £¨jolianday(¡®now¡¯)-jolianday(¡®1981-12-23¡¯)£©%365
3¡¢Õâ¸ö·½·¨¿Ï¶¨ÓÐÎÊÌ⣬µ«ÊµÔÚ²»ÖªµÀÔõôʵÏÖ£»
Òò´ËÏ£Íû¸÷λÈÊÐÖ°ï°ïæ£ ......
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 ......
µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:
ºÅÂë(num) ÁªÏµÈË (relationname)
10086 ÒÆ ......
ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂ룬½â˵ԽÏêϸԽºÃ£¬ÒòΪÎÒ»¹Ã»ÓÐÓùýSQLite£¬Ð»Ð»£¡
Éϴζ¼²»¸øÎÒ·Ö¡£¡£
×¢²ásqltp30.dllÕâ¸öActiveX DLL
ÓÃÀïÃæµÄSQLiteDBÀཨÁ¢¡¢Á¬½ÓÊý¾Ý¿âÎļþ£¬¾ÍÏñADODBÀïµÄConnecti ......
ÕâÊÇÎҲ鵽µÄ×ÊÁÏ
http://www.cppprog.com/2009/0108/43.html ÒѾ´æ½øÍ¼Æ¬ÁË£¬ÏÖÔÚ×öµ½ÕâÒ»²½ÁË£¬
¡°ÕâʱÊý¾Ý¿âµ±ÖÐÒѾÓÐÁËÒ»Ìõ°üº¬BLOB×ֶεÄÊý¾Ý¡£½ÓÏÂÀ´ÎÒÃÇÒª¶ÁÈ¡ÕâÌõÊý¾Ý£º 1. //ѡȡ¸ÃÌõ ......