|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
07/09/2007, 22h04
|
#1 |
Messages: n/a
Hébergeur: |
Updating a row in a recordset
What properties to you set to make a SQL 2005 recordset updatable?
In Access, it's Recordset.edit Recordset!FieldName=SomeValue Recordset.update Any is appreciated. |
|
|
07/09/2007, 22h18
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Updating a row in a recordset
Charlie (jadkins4@yahoo.com) writes:
> What properties to you set to make a SQL 2005 recordset updatable? > > In Access, it's > Recordset.edit > Recordset!FieldName=SomeValue > Recordset.update > > Any is appreciated. There are no properties you can set. Either the column is updatable or it is not. Un-updatable columns are for instance computed columns, or columns from UNION queries. You can always address the problem by bouncing the data over a temp table. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
|
|
08/09/2007, 14h53
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Updating a row in a recordset
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 s. 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 is appreciated. > |
|
|
 |
| Outils de la discussion | |
|
|
