Hi Guys,

I have a question regarding updatable SPT Cursors. I tried to set the cursor to be updatable and it worked on few table fields. But when the table starts to have more than ten fields, It does not update anymore. I wonder if they are limited to ten fields per cursor only though that does not seem to be logical. To give an example, here are the fields that I have been working for my dbo.sample table

refuniqueno Char(10)
trackno Char(10)
field1 Char(10)
field2 Char(10)
field3 Char(10)
field4 Char(10)
field5 Char(10)
field6 Char(10)
field7 Char(10)
field8 Char(10)

these collection works fine. but when i include field9 from the list to have a total of 11 fields, the cursor won't update anymore. If I remove field1 and left field9 to give me 10 fields all in all, the cursor will update.

Any idea or suggestion?

Thanks in advance...