there is no row at position 0(sql server 2000)

[almajed]

hello everyone,

we have a problem in my system that will say it now.

we have two departments can access to the same database , the first department fill all the fields in the application(web_enabled), the second department can fill some fields from whole the fields and the remaining fields are set as default values because they don't have access to the remaining items.
the problem here, when the first department go to fill the fields and then press save to save the filled information , will operation successful, but when the second one want to fill the fields then click save , will appear this error
" there is no row at position 0".

note that we can't to change any thing in the code , i hope to find the answer for our problem thru database.
with my regards

[skhanal]

Run sql profiler on the database to see what sql statement is sent by second set of users.

It looks like it is trying to update a row using a cursor and the row does not exist.