Error Message ADODB.Recordset error '800a0e79'

[victoria_1018]

Hi,
I had an error message in my program and I don't know where it had gone wrong.
The error message is :

ADODB.Recordset error '800a0e79'
Operation is not allowed when the object is open.

/WOSchedule/UpdateSchedule1.asp, line 64

It would be great if someone can tell me where my program had gone wrong and tell me how to edit it.

Thanks

Regards
Victoria

[allida77]

WorkOrderNo = Request("WorkOrderNo")

temp = "SELECT WorkOrderNo from Schedule where WorkOrderNo = '" & WorkOrderNo & "'"

Set ScheduleRS = Server.CreateObject("ADODB.Recordset")
set ScheduleRS = ScheduleConn.execute(temp)


if ScheduleRS.eof then

Response.write " The Work Order No You Have Key In Is Invalid.Please check The Work Order No, Thank You!"

else


SQL = "SELECT * FROM Schedule WHERE WorkOrderNo = '"&WorkOrderNo&"' "
set ScheduleRS1 = ScheduleConn.execute(SQL)

ScheduleRS.Open SQL, ScheduleConn, 3,3,1


You are opening SceduleRS twice. Once before the if and again in your if statement. You must close it if you are going to open it again.

[victoria_1018]

Dear allida77,
Thank for your help, I have solve my problem.
Regards
victoria