vb sqlÔËËãÎÊÌ⣿£¿

ÎÒÏë¼ÆËã¡°×Ö¶Î1¡±ÖеÄÊý¾Ý¡£
¾ÍÊÇÔÚ¡°×Ö¶Î1¡±ÖÐÉÏÒ»Ìõ¼Ç¼¼õÏÂÒ»Ìõ¼Ç¼£¬Ò»Ö±µ½×îºóÒ»Ìõ¼Ç¼£¬
µÃ³öµÄ½á¹ûÊä³öµ½¡°×Ö¶Î2¡±ÖС£

×Ö¶Î1 ×Ö¶Î2
 9
 7
 8
 5
 2
 2
¡­
¡­
¡­
n

Çë¸÷λ¸ßÊÖд³ö´úÂëÀ´£¡Ð»Ð»£¡

---

ßÀ£¡ÎªÊ²Ã´Ã»ÓÐÈ˻صģ¬ÊÇ¿´²»Ã÷°×£¬»¹ÊÇÌ«ÄÑÁË£¿£¿

---

ÏÂÃæifº¯ÊýµÄÄǾäÓбàÒë´íÎó£¬Ó¦¸ÃÔõÑùÐ޸ģ¿£¿

Private Sub Command1_Click()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String
Set cn = New ADODB.Connection
cn.Open "provider=microsoft.jet.oledb.4.0;data source=E:\³É¼¨\·ÖÊý.mdb;"
sql = "select * from ·ÖÊý±í"
Set rs = New ADODB.Recordset
Dim i as Integer 
rs.Open sql, cn, adOpenForwardOnly, adLockOptimistic
while not rs!eof
   
  if i <> 0 then
  i=rs.×Ö¶Î1-i  
  rs.×Ö¶Î2=i
  end if
  i=rs.×Ö¶Î1
wend
rs.update
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
{{