Can Database Fields Exist after the RecordSet is gone

Can you save of Database Field objects that remain valid after the the RecordSet goes out of scope and the DB is closed?

I mean would code like this be valid?

[code] Dim RS as RecordSet = DB.SQLSelect(“SELECT * FROM aTable”)
Dim DataList(), D as Dictionary, theField As DatabaseField

While NOT RS.EOF
D = New Dictionary
For i as Integer = 1 to RS.FieldCount
theField = RS.IdxField(i)
D.Value( theField.Name) = theField
Next
DataList.Append D
RS.MoveNext
Wend
RS.Close
Call DB.Close

Return DataList
[/code]

No. The object is reused. You would only have the final value, which would be empty once the recordset hit eof.

Thanks

You can, of course, save a copy of the value of each field, if not the field itself.

D.Value( theField.Name) = theField.Value