急~~基础问题难死我~~在线跪求(50分)
vb 中的一段sql,代码如下:
strSql = "select fname,ffieldname from t_BasStruct where fitemclassid='" & strNodeClassid & "' order by forderid"
Rs.Open strSql, cnnMydb, adOpenStatic, adLockOptimistic
strbuiltsql = "select " & Trim(Left(strbuiltsql2, Len(strbuiltsql2) - 1)) & strbuiltsql1 & strbuiltsql3
RsBulit.Open strbuiltsql, cnnMydb, adOpenStatic, adLockOptimistic
Rs.MoveFirst
Do While Not Rs.EOF
intLoop = intLoop + 1
.Row = intLoop
.Text = Rs("fname")
.Col = 2
.Text = RsBulit(Rs("ffieldname"))‘此处想把Rs的记录集的结果,放到RsBulit记录集中作为字段名称,然后选出RsBulit的记录集,程序报错,望高手指教
Rs.MoveNext
Loop
Set RsBulit = Nothing
Set Rs = Nothing