When I use recordset object to open a database, after executing one command ( it doesn't differ which command relating to database or not ) the value of field becomes NULL. It's very strange. It's code is like this :
SQLCommand="select * from test"
'hear rs("field1") is NULL and after executing one command rs("field1").value also becomes NULL
a=rs("field1") ' this command is valid
b=rs("field1") ' but this command isn't valid anymore
It seems like a bug.I saw another thread in this forum like mine but it wasn't answered.
Thank you very much,