Hello.
I have build a workflow application on SQL2k using office xp developer.
when i try to insert a record into sql and update some fields in the
workflow(session.item & session.item.updatebatch). I always get an error
msg. If i mark this update script in the workflow and only addnew & update
in the ASP, it works. My scripts are as follow
in ASP:
rsADO.CursorType = 1
rsADO.LockType = 4
rsADO.AddNew
rsADO("blah") = "blah"
rsADO.UpdateBatch
in SQL Workflow Action script:
Session.Item("blah") = "blah2"
Session.Item.UpdateBatch