Problem populating table with a SQL Cursor from VB GUI

Question

Hi all

I have a store proc that that does various bits of data manipulation, but the last part I have used a cursor to update 2 fields in a table.  This sp is called by a VB front end and then the contents of the table in question displayed in a Crystal Report.

The problem is, if I run the sp directly (within VB's Server Explorer) these 2 fields are always fully populated.  If however I call the sp from within code in a GUI, after each call (which should fully populate the table based on certain criteria) the 2 fields become less populated.  What I mean by this is on the 1st call the 2 fields are 100% populated, with each subsequent call only populating maybe 50% of records, then 20%, until no records are populated.

Would anyone have any ideas where I may look.

thanks

Answer 1

Having done the obvious and removed the cursor for a batch update, the problem has gone.  Still has me curious about the above however.