我用vb调用ACCESS
mysql="SELECT [],[],[],[],[],[],[]...,[],[] FROM [] WHERE []= AND []= AND []= AND []= AND []="
rs.Open mysql, cn, adOpenDynamic, adLockOptimistic
然后就报错,查看本地窗口发现mysql后面几个字符被截掉了,怎么办?
后来我又用了数组,传送到rs内,在本地窗口内发现rs下的Source内的select语句后面几个字符也被截掉了,估计是字符串太长了,请问下这个该怎么解决啊???
mysql="SELECT [],[],[],[],[],[],[]...,[],[] FROM [] WHERE []= AND []= AND []= AND []= AND []="
rs.Open mysql, cn, adOpenDynamic, adLockOptimistic
然后就报错,查看本地窗口发现mysql后面几个字符被截掉了,怎么办?
后来我又用了数组,传送到rs内,在本地窗口内发现rs下的Source内的select语句后面几个字符也被截掉了,估计是字符串太长了,请问下这个该怎么解决啊???
另外,你预计中的WHERE []= AND []= AND []= AND []= AND []="
部分,怎么看都有问题
mysql = "SELECT [字段0] From [数据表1] WHERE [字段1]='" & DataGrid1.Columns(0).Text & "' and [字段2]='" & DataGrid1.Columns(1).Text & "' and [字段3]='" & DataGrid1.Columns(2).Text & "' and [字段4]='" & DataGrid1.Columns(3).Text & "' and [字段5]='" & DataGrid1.Columns(4).Text & "' and [字段6]='" & DataGrid1.Columns(5).Text & "' and [字段7]='" & DataGrid1.Columns(6).Text & "' and [字段8]='" & DataGrid1.Columns(7).Text & "' and [字段9]='" & DataGrid1.Columns(8).Text & "' and [字段10]='" & DataGrid1.Columns(9).Text & "' and [字段11]='" & DataGrid1.Columns(10).Text & "' and [字段12]='" & DataGrid1.Columns(11).Text & "' and [字段13]='" & DataGrid1.Columns(12).Text & "' and [字段14]='" & DataGrid1.Columns(13).Text & "'"
mysql = "SELECT [字段0] From [数据表1] WHERE [字段1]='" & DataGrid1.Columns(0).Text & "' and [字段2]='" & DataGrid1.Columns(1).Text & "' and [字段3]='" & DataGrid1.Columns(2).Text & "' and [字段4]='" & DataGrid1.Columns(3).Text & "' and [字段5]='" & DataGrid1.Columns(4).Text & "' and [字段6]='" & DataGrid1.Columns(5).Text & "' and [字段7]='" & DataGrid1.Columns(6).Text & "' and [字段8]='" & DataGrid1.Columns(7).Text & "' and [字段9]='" & DataGrid1.Columns(8).Text & "' and [字段10]='" & DataGrid1.Columns(9).Text & "' and [字段11]='" & DataGrid1.Columns(10).Text & "' and [字段12]='" & DataGrid1.Columns(11).Text & "' and [字段13]='" & DataGrid1.Columns(12).Text & "' and [字段14]='" & DataGrid1.Columns(13).Text & "'"这样看起来方便些!