Dim i_num As Long
Dim i_sub As Longi_num = Val(DataGrid1.Columns(0).Text)
i_sub = Val(DataGrid1.Columns(1).Text)
Call Main
Set adoRS = adoCon.Execute("delete from issuelog where issue_num = '" + i_num + "' and i_sub_num = '" + i_sub + "'")运行后提示数据类型不匹配,请问是什么问题?谢谢.
Dim i_sub As Longi_num = Val(DataGrid1.Columns(0).Text)
i_sub = Val(DataGrid1.Columns(1).Text)
Call Main
Set adoRS = adoCon.Execute("delete from issuelog where issue_num = '" + i_num + "' and i_sub_num = '" + i_sub + "'")运行后提示数据类型不匹配,请问是什么问题?谢谢.
把i_num,i_sub类型改为integer,同样的提示...
Dim i_sub As Long i_num = Int(Val(DataGrid1.Columns(0).Text))
i_sub = Int(Val(DataGrid1.Columns(1).Text))
Call Main
Set adoRS = adoCon.Execute("delete from issuelog where issue_num = '" + i_num + "' and i_sub_num = '" + i_sub + "'") 做如上改动后还是不行,郁闷啊...
Dim i_sub As stringi_num = DataGrid1.Columns(0).Text
i_sub = DataGrid1.Columns(1).Text
Call Main
Set adoRS = adoCon.Execute("delete * from issuelog where issue_num = " + i_num + " and i_sub_num = " + i_sub)