Db.Execute "delete from B " & _
" where KH='" & fg.TextMatrix(i, 2) & "' " & _
" and dttime between (select min(dttime1) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " & _
" and (select max(dttime2) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " 这语句只能删除KH字段数字的内容,能改成支持英文和数字嘛?
" where KH='" & fg.TextMatrix(i, 2) & "' " & _
" and dttime between (select min(dttime1) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " & _
" and (select max(dttime2) from A where KH='" & fg.TextMatrix(i, 2) & "' and dttime2 = #" & fg.TextMatrix(i, 1) & "#) " 这语句只能删除KH字段数字的内容,能改成支持英文和数字嘛?
db.execute "delete from b where kh='"& 字符变量 &"'"
'KH为数值型字段:
db.execute "delete from b where kh="& 数值型变量 &""