ADODC出现错误:Method 'refresh' of object 'IAdodc' failed何解?
以下语句用于单头和单身的关联,当记录移动时就触发以下语句以保持单头和单身同步。但有时出现错误:Method 'refresh' of object 'IAdodc' failed何解?
If Adodc_header_general.Recordset.eof = False Then
Adodc_body_general.RecordSource = "select VAj.* from VAj with (nolock) where VAj.VAjid='" & Adodc_header_general.Recordset.Fields("VAjid").Value & "'"
Adodc_body_general.Refresh
End If
注:当Form load ‘时
Adodc_body_general.ConnectionString=library_general_2.about_db_register.connection_string
Adodc_body_general.CommandType = adCmdUnknown
Adodc_body_general.RecordSource = "select top 1 VAj.* from VAj with (nolock) "
Adodc_body_general.Refresh
End sub
有人说是CommandType问题。应该是adCmdText,但adCmdUnknown不是包含所有的了吗?
不知大家有何高见。或有什幺方法进行单头和单身关联方法