|
Posted by Dan Guzman on 09/08/07 13:53
To add on to Erland's response, APIs that use client cursors often require
that each row have a unique column(s) (e.g. primary key) in order to be
updatable. This is because an UPDATE statement is generated under the
covers and the generated WHERE clause needs to specify values that uniquely
identify the row to be updated. Make sure all tables have a primary key.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Charlie" <jadkins4@yahoo.com> wrote in message
news:46e1bcd7$0$32553$4c368faf@roadrunner.com...
> What properties to you set to make a SQL 2005 recordset updatable?
>
> In Access, it's
> Recordset.edit
> Recordset!FieldName=SomeValue
> Recordset.update
>
> Any help is appreciated.
>
Navigation:
[Reply to this message]
|