Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Data Environment recordset problems...
Hello,
My code below generates this error. "Object was open"
I dont understand this error. I am sure that checking the state and closing it if the state =1 should close the command.
Furthermore. I removed the state check code and proceeded to do this:
de.rscmdRetSite.close
I then received a message that my command is closed.
After which I tried to execute the select statemtent only to receive the
"Object was open" error again..
If de.rscmdRetSiteDet.State = 1 Then
de.rscmdRetSiteDet.Close
End If
de.rscmdRetSiteDet.Open "SELECT * FROM Site" & _
" WHERE customerID= '" & customerid & "'"
Any help would be appreciated.
Thank You,
Alvin
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement