copysqlstr = "Select * From T_copyrount Where "
For i = 1 To Grid2.Rows - 1
id = Trim(Grid2.TextMatrix(i, 1))
copysqlstr = copysqlstr & "F_thID = '" & id & "' Or "
Next i
copysqlstr = Left(copysqlstr, Len(copysqlstr) - 3)我想把表格种的记录复制,用上面的循环,可到了最后copysqlstr的值,怎么与循环内的copysqlstr的值相同,难道left不管用吗?我在最后一句的copysqlstr字符串改成copysqlstr1 = Left(copysqlstr, Len(copysqlstr) - 3),copysqlstr1的值还与copysqlstr相同,怎么回事啊?
For i = 1 To Grid2.Rows - 1
id = Trim(Grid2.TextMatrix(i, 1))
copysqlstr = copysqlstr & "F_thID = '" & id & "' Or "
Next i
copysqlstr = Left(copysqlstr, Len(copysqlstr) - 3)我想把表格种的记录复制,用上面的循环,可到了最后copysqlstr的值,怎么与循环内的copysqlstr的值相同,难道left不管用吗?我在最后一句的copysqlstr字符串改成copysqlstr1 = Left(copysqlstr, Len(copysqlstr) - 3),copysqlstr1的值还与copysqlstr相同,怎么回事啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货