New Error (for me anyway)

[Gatorajc]

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Function sequence error


This is the block of code and the line I am getting the error.

if RS1.EOF then
if not RS1.BOF then
RS1.MoveFirst
end if
end if

I am trying to back to the first record in the record set. I know it works, I moved it from a server that it was working on. But now I get this error that I have never seen before.


AJ

 

[onpnt]

seems a bit redundant to say both BOF and EOF
both equate to the same thing
if anything I would only do

if RS1.EOF OR RS1.BOF then
RS1.MoveFirst
end if

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[Gatorajc]

true. I fixed it.

But I still get the same error.


AJ

 

[onpnt]

hmm.. according to the magic error guide
it is saying you are trying to access the data (rs) prior to the fact the data was sent with in the function. in this case the if statement. is this a possibility?

maybe this is jsut a order of operations issue

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]