Try:

http://support.persits.com/show.asp?code=PS01040432

I have seen this error in ASP and have been away from work for the last three months. I bet that 2 AM in the morning I will wake up and say - oh yeah - the solution is... :)


>The following code worked fine (I think) yesterday.
>

>< %
>sql = "select as_scoping,a_scoping,as_planfile,a_planfile,as_envclr,a_envclr,"
>sql = sql + "as_rwclr,a_rwclr,as_const,a_const "
>sql = sql + " from TIP where tip_id=" & lnTIP_ID	
>oPage.open sql, oConnection, adOpenKeyset, adLockBatchOptimistic, adCmdText
>with oPage
>.fields("as_Scoping").value = formatdate2(request.form("as_Scoping"))
>.updatebatch
>end with
>% >
>

>Today it fails on the update, BUT the new date value IS stored in the table. Not only that but the new date is stored to most but not all of the records in the table even though there is only 1 record that fits the criteria. Running a record count loop confirms that only 1 record was selected. The formatdate2 function is simply to deal with a blank date coming from the form.
>
>The error message is
>Error Type:
>Microsoft Cursor Engine (0x80040E21)
>Multiple-step operation generated errors. Check each status value.
>/tip/save_tippage1_edits.asp, line 395
>
>
>Any ideas on what's causing this? Other functions that write to this table seems to work OK so I don't think its a permissions issue.
>Thanks for any insights.