How to maintain the recorset in a recursive functions?
for eg
Public Function upload(id)
sqlstr = "select doc_id,doc_title from t_document where parent_id =" & id
Set orschild = oCompanyConn.Execute(sqlstr)
Do While Not orschild.EOF
loopsqlstr = "update t_document set document_type_limiter=" & toolid & " where doc_id =" & id
oCompanyConn.Execute (loopsqlstr)
orschild.Requery
childupdate orschild("doc_id")
orschild.MoveNext
If Not orschild.EOF Then
upload orschild("doc_id")
End If
DoEvents
Loop
End Function
here I want to maintain the earlier recordset. Is it possibel?
