7,763
社区成员
发帖
与我相关
我的任务
分享
'Set rs = cn.Execute(sqlstr)
rs.Open sqlstr, cn
If rs.EOF Then
getLastCode = letter & "000000"
Else
getLastCode = rs(0).Value
End If
sqlstr = "select top 1 * from equipment where code like '"& letter &"%' order by code desc"