比较奇怪的问题,以更改但不显示
Dim rsPrice As ADODB.Recordset
Set rsPrice = New ADODB.Recordset
Dim strSQL As String
strSQL = "select * from houses where house_ID =" & Val(frmHousesPool.lvwHouses.SelectedItem.Key)
rsPrice.Open strSQL, CN, adOpenDynamic, adLockPessimistic
Dim n
Dim m
n = rsPrice.Fields("house_address")
m = rsPrice.Fields("saling_price")
rsPrice.Fields("saling_price") = 333
rsPrice.Update
Debug.Print rsPrice("saling_price").Value
rsPrice.Close
Set rsPrice = Nothing
/////
Debug.Print 也是333
但是打开数据库确实没有变动的,还是原样