problem with error ADODB.Field error '80020009' BOF or EOF

[ceeleelewis]

My application has been fine up to this point but I have ran into an error that crashes my application everytime I try to submit a change to record. I receive the following message ...

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.


Now I know that my dBase has the record that I'm trying to edit inside the correct table.

I just don't know if I'm using the EOF property correctly in this case?

While objRS.BOF= false
'objRS("reqFormId&quot = Trim(Request.Form("reqFormId&quot)
'objRS("reqDate&quot = Trim(Request.Form("reqDate&quot)
objRS("DNS&quot = Trim(Request.Form("DNS&quot)
objRS("pssWrd&quot = Trim(Request.Form("PASSWORD&quot)
objRS("chDksp&quot =Trim(Request.Form("chDksp&quot)
objRS("shMem_pre&quot = Trim(Request.Form("shMem_pre&quot)
objRS("dtAppsdb&quot = Trim(Request.Form("dtAppsdb&quot)
objRS("sndMrt&quot = Trim(Request.Form("sndMrt&quot)
objRS("preInstDate&quot = Trim(Request.Form("preInstDate&quot)
objRS("PreInstall_Comments&quot = Trim(Request.Form("PreInstall_Comments&quot)

objRS.Update

objRS.MoveNext

Wend

Any help would be greatly be apriciated.

 

[Tarwn]

Ok, sorry for the above post, I was incorrect about the opening of a table, it's been a qwhile since I did an update in this fashion.

The error is occuring because your opening the table dynamically and checking the recordcount. The recordcount only is set in the recordset if you open it with a static or keyset cursor. Since it isn't set the recordset always returns a recordcount of 0 which means it automatically goes into the else of your if/else, skipping the portion where your updating.

It would be better to switch that if check to an if EOF check instead. The recordset will only come back with EOF if there are no records. If there are any records whatsoever than it will come back pointing to one of them instead.

This still doesn't solve your EOF error, however. Basically in this case your recordset is coming back empty, meaning it isn't matching that hardcoded value for the primary key. The portion of the code where it is throwing the EOF error is further down:

        response.write"****"
        response.write(objRS("DNS"))

So besides the recordcount issue it isn't pulling in the record your looking for either.

-Tarwn

[sub]01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101 [/sub]
[sup]29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19[/sup]
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048