ASP Error Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[victoria_1018]

I am having this error when doing my program. After trying many time still can't get the bugs clear. Cam anyone help me please!
Thanks
Regards

ADODB.Field error '80020009'

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

/WOSchedule/UpdateSchedule3.asp, line 29

[allida77]

Put a

If Not ScheduleRS.EOF Then
'Put all your Session() = ScheduleRS between this
End If

You can also try a ScheduleRS.MoveFirst before all your ScheduleRS statements but I think the problem is that you are not returning any records.

[victoria_1018]

Hi,
Regarding your solution, I don't really get what you mean. Am I going to put the if statement before session("xxx") = Request.Form ("xxx") or before
If session("xxx") = "" Then
session("xxx") = ScheduleRS("xxx")
End If

Another thing is, why is there time when I do an update in a program, the first information give an error message and the second update in the same session will update the first, the third update the second and go on in this pattern?

Thanks
Regards
Victoria


Originally posted by allida77
Put a

If Not ScheduleRS.EOF Then
'Put all your Session() = ScheduleRS between this
End If

You can also try a ScheduleRS.MoveFirst before all your ScheduleRS statements but I think the problem is that you are not returning any records.

[csmajor231]

how are you doing the update, are you doing a

thisfield=test
objDataRec.Update
or are you doing a

strsql="Update table set thisfield=test"


if you are doing the first the problem you are having it the placement of the cursor is incorrect. Does this work for you?

[allida77]

Put them around the entire

If Not ScheduleRS.EOF Then
If session("xxx") = "" Then
session("xxx") = ScheduleRS("xxx")
End If
If session("xxx") = "" Then
session("xxx") = ScheduleRS("xxx")
End If
ect.
End If


I am not sure about your second question, need to see more code.

[victoria_1018]

Hi,
I had try the method you provide but it still don't work. It seem that the program cannoyt select the record with Schedule ID provoded by user.
Is there any other way I can do to solve the problem?
Thanks
Regards
Victoria