Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : access

¹ØÓÚÏß³ÌÒý·¢Access violation at addressµÄÎÊÌâ

²»ÓÃÏß³ÌÈ¥µ÷Óã¬Ã¿¸öº¯Êý¶¼Ö´Ðеúúõ쬶¼²»»á³ö´í£¬Ò»µ«ÓÃÏ̵߳÷ÓÃÁË£¬¾Í³öAccess violation at addressXXXXX´íÎ󣬻òÊÇInvalid pointer operation£¬´Ó¶øµ¼Ö³ÌÐò±ÀÀ£×Ô¶¯¹Ø±Õ

ÇëÎÊÕâÓÐʲô½â¾öµÄ°ì·¨Â𣿸ø¸öʾÀýµÄ´úÂë»òα´úÂëÒ²ÐÐ

(ÎÒÒ»¹²ÓÐ80¶à¸öÏß³Ìÿ¸ö100msÑ­»·È¥µ÷ÓÃÄÇЩº¯Êý£¬È¥ÅжÏÄÇЩֵ£¬È¥¸ ......

access Êý¾Ý¿â È¥³ýÖØ¸´ ²¢ ÒÔidµ¹Ðò µÄsql д·¨

access Êý¾Ý¿â È¥³ýÖØ¸´ ²¢ ÒÔidµ¹Ðò µÄsql д·¨

ÓÐÒ»¸ö±íΪ£º
id  name
-----------
1    xxx
2    111
3    xxx
4    333
ÒªÇó²é³öÀ´µÄ½á¹ûΪ£º
name
-----------
333
xxx
111
ÔõôʵÏÖ£¿£¿Çë½Ì¸ßÊÖ

select distic ......

c# AccessÊý¾Ý¿âÊý¾ÝÀàÐÍÎÊÌâ

ÊÇÕâÑùµÄ¡£ÎÒÓÃAccess×öÁËÒ»¸öÊý¾Ý¿â£¬ÆäÖÐÓÐBooleanÀàÐ͵ÄÊý¾Ý£¬ÎÒÓÃexcelÍùÊý¾Ý¿âµ¼Êý¾Ý£¬excel±í¸ñÖÐ×Ö¶ÎÊÇ TRUE £¬µ¼ÈëµÄʱºò³öÏÖÁ˷dz£Ææ¹ÖµÄ½á¹û£¬SQLÓï¾äÖн«TRUE ÏÔʾ³ÉÁ˺º×Ö¡°Õ桱¡£¸÷λ´óÏÀ°¡¡£Õâ¸öÊÇʲôÇé¿ö°¡¡££¬
ûÓùýAccess...²»ÖªµÀ.°ï¶¥ÁË.
×¢ÒâAccessÀïµÄÊý¾ÝÀàÐÍ.ÇÒ×Ö¶ÎÊÇ·ñÏà¶ÔÓ¦°É

ACCESSÀïà ......

accessÊý¾Ý¿â¸üÐÂÎÊÌâ~

Õâ¸öÊÇnews.csÀïÃæµÄÒ»¸ö·½·¨ (¸üÐÂÐÂÎÅ)
  public int UpDateNews(NewsInfo objNews, LogNewsInfo objLogNews)
        {
            string sql = "update Data_News set SortID=@SortID,[Title]=@Title,[Body]=@Body,[Writer]=@Writer,[DateTime ......

ÕâÌõSQLÓï¾äÔÚAccessÀïÃæÎªÊ²Ã´²»ÄÜÓÃ

UPDATE TableA SET newsTel = (Select newsTel from TableB Where TableA.newsID = TableB.newsID)

ÕâÌõSQLÓï¾äÔÚAccessÀïÃæÎªÊ²Ã´²»ÄÜÓÃѽ£¬Ò»Ö´ÐоÍÌáʾ˵±ØÐëÊÇÒ»¸ö¿É¸üеIJéѯ¡£

ÔÚSQL 2000ÀïÃæ¿ÉÒÔÕý³£Ö´Ðеġ£


SQL code:
UPDATE TableA SET newsTel =B.newsTel from TableA A,TableB B whe ......

Ò»¸ö¹ØÓÚaccessÊý¾Ý¿â¸üеÄÎÊÌâ

ÎÒÔÚ³ÌÐòÖÐдÁËÒ»¸ö¸üÐÂÓï¾ä
  Delphi(Pascal) code:
a1.Close;
a1.SQL.Clear;
a1.SQL.Add('update JLB set bs=1 where bs=0');
a1.ExecSQL;
showmessage('µ¼ÈëÍê³É~');


ΪʲôÔÚaccessÖоÍÖ´Ðв»ÁËÄØ£¿Ò²²»ËÀ»ú£¬³ÌÐòÒ²ÔËÐе½½áβÁË¡£µ«¾ÍÊDz»Ö´ÐиüÐÂ
ÏëÎÊÏÂÊDz»ÊÇaccessÖеĸü ......
×ܼǼÊý:990; ×ÜÒ³Êý:165; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [119] [120] [121] [122] 123 [124] [125] [126] [127] [128]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ