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

sqlite£¬updateµÄÎÊÌâ

ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£

ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵģ¬µ«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Óû§updateµÄÕâÌõÊý¾ÝµÄrowid£¬µ«ÎÒÏëµÃÖªÓû§updateÊý¾Ý±íÖÐijһÁеÄ×Ö¶ÎÃûºÍ¾ÉÖµ£¬Õâ¸öÔõôÀ´ÊµÏÖ£¿ÄÄλ¸ßÊÖ¸øµãÌáʾ°¡
×Ô¼º¶¥

¾ÉÖµ:old.×Ö¶ÎÃû

ijһÁеÄ×Ö¶ÎÃû£ºÎÞ·¨×öµ½

ÎÒµÄÎÊÌâÊÇ£¬±í½á¹¹Î´ÖªµÄÇ°Ìá°¡¡£¼ÙÈçÒ»¸öÊý¾Ý±íµÄ×Ö¶ÎÓÐ10¶à¸ö¡£ÎÒ²»ÄܸøÕâ¸ö±í¼Ó10¶à¸ö´¥·¢Æ÷°É?ÓÐʲôºÃ°ì·¨Âð£¿sqlite3ÀïµÄ×Ô½¨º¯Êý£¬Äܽâ¾öÕâ¸öÎÊÌâÂð

ÎÒµÄÎÊÌâÊÇ£¬±í½á¹¹Î´ÖªµÄÇ°Ìá°¡¡£¼ÙÈçÒ»¸öÊý¾Ý±íµÄ×Ö¶ÎÓÐ10¶à¸ö¡£ÎÒ²»ÄܸøÕâ¸ö±í¼Ó10¶à¸ö´¥·¢Æ÷°É?

¼ÓÒ»¸ö´¥·¢Æ÷£¬¾ÍÐÐÁË£¬È»ºó¶Ô±Èÿ¸ö×ֶεÄnew, old µÄÖµÊÇ·ñÏàͬ¡£²»ÏàͬÔò˵Ã÷±»¸ÄÁË¡£
µ«¶ÔÕâÖÖ update t set c=c £¬¼´ÖµÃ»±ä»¯µÄ£¬ÔòûÓа취¡£


Ïà¹ØÎÊ´ð£º

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

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

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

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

sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ

ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......

cb2010ÔõôʹÓÃSQLiteÊý¾Ý¿â£¿

×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£

ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI

ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿

2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ

ÒýÓÃ
ÄѵÀCBÌṩµÄÊý¾Ý×é¼ ......

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>
SQLITEϲ»ºÃÓà
Ìáʾ: 
sqlite error 
no such function: stuff 
Ôõô½â¾ö?
SQL code:
--------------------------------------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ