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

SQliteµÄÒ»¸öÎÊÌâ

ÈçÏÂÓï¾ä £º
select TimeSpan from T_Table where onlineDate = '2009-12-2'
Êý¾Ý¿âÀïÃæÓзûºÏÌõ¼þµÄÖµµ«ÊDz鲻³öÀ´
Èç¹û¸Ä³ÉÈçÏ£º
select TimeSpan from T_Table where onlineDate = '2009-12-02'
¾Í¿ÉÒÔ²éÕÒ³öÀ´ Ôõô»ØÊ¶ù£¬SQlite¾ÍÕâÑùô£¿
»¹ÓÐÏÖÔÚ´Ó³ÌÐò´«ÈëÒ»¸ö DateÀàÐ͵ÄÖµ ¾ÍÊÇ2009-12-2 Õâ¸öÐÎʽµÄ
Ôõô»ØÊ¶ù£¬ÓÐʲô°ì·¨¿ÉÒÔ²»¸Ä¶¯³ÌÐò ¾Í¿ÉÒÔÈÃËü²éѯ³ö½á¹ûô£¿


up

×Ô¼º¸ã¶¨ÁË¡£



¡£¡£¡£

ÈÕÆÚ¸ñʽÎÊÌ⣿

strftime("%Y-%m-%d", onlineDate) = '2009-12-2'


Ïà¹ØÎÊ´ð£º

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

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

Óа취ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ²Ù×÷sqliteÊý¾Ý¿âÂð£¿

visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆÕ±é¶¼ÊÇÕâÑùÂð£¿Ë­Óнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..

ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......

SqliteÎÞ·¨¸üÐÂ

C# code:
public static bool UpdateFriendUrl(int id, string cnName, string jpName, string logoUrl, string site, int order)
{
string sql = "update FriendUrl set SiteNameCN=@SiteNameC ......

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

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

winceÏÂʹÓÃsqliteµÄ¿ìËÙ²éѯ£¿

´ó¼ÒºÃ£º
      ×î½üÔÚwinceÏÂʹÓÃsqlite£¬µ«ÊÇÓÉÓÚ±íµÄÄÚÈÝÁ¿´ó£¬ËùÒÔ²éѯЧÂʺܵͣ¬²»ÖªµÀʲôÎÊÌâ¼°Ôõô½â¾ö¡£
      ÎҵıíµÄ½á¹¹ÈçÏ£º
      name&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ