"Roger Tranchez" <RogerTranc***@discussions.microsoft.com> wrote in message
news:21B62709-128A-461C-ACDA-893ACD979F3C@microsoft.com...
> Hello,
>
> I'm trying to update some records of a database table called
> "PETICIONS_TRESORERIA" with this structure:
>
> codi        int
> data_peticio datetime
> name            varchar
>
> (first two fields made the primary key)
> .
> .
> .
> I'm using a data adapter with a UpdateCommand as follows:
>
> update PETICIONS_TRESORERIA set
> codi=@codi,data_peticio=@data_peticio,name=@name where codi=@codi and
> data_peticio=@data_peticio
>
> The "SourceVersion" property for the UpdateCommand parameters @codi and
> @data_peticio, are set to "DataRowVersion.Original", as if the user
> change
> them on the associated datagrid , I want to return the original values
> for
> changing them
>
> An example will be more clear:
>
> If I have these original values for codi, data_peticio and name :
>
> 1000,1/1/2007,Roger
>
> And I change the "name" to other value, when I do the data adapter
> update,
> it works perfect, but, if I change the code or data_peticio, nothing
> happens
> (no errors, no update).
>
> The same happens if I undo the definition of the primary key on the
> table.
>
> What's the problem ?
>
>
> Thanks in advance,
>
>
> Roger Tranchez
> .NET 2005 and DB developer

"RobinS" wrote:

> You are setting code to the original version in both cases. You need to use
> different parameters, one for codi in the SET clause, and one for codi in
> the WHERE clause. Same for data_peticio.  The one in the WHERE clause
> should be DataRowVersionOriginal, the other one needs to be
> ModifiedCurrent.
> Robin S.
> ---------------------------------------
> "Roger Tranchez" <RogerTranc***@discussions.microsoft.com> wrote in message
> news:21B62709-128A-461C-ACDA-893ACD979F3C@microsoft.com...
> > Hello,
> >
> > I'm trying to update some records of a database table called
> > "PETICIONS_TRESORERIA" with this structure:
> >
> > codi        int
> > data_peticio datetime
> > name            varchar
> >
> > (first two fields made the primary key)
> > .
> > .
> > .
> > I'm using a data adapter with a UpdateCommand as follows:
> >
> > update PETICIONS_TRESORERIA set
> > codi=@codi,data_peticio=@data_peticio,name=@name where codi=@codi and
> > data_peticio=@data_peticio
> >
> > The "SourceVersion" property for the UpdateCommand parameters @codi and
> > @data_peticio, are set to "DataRowVersion.Original", as if the user
> > change
> > them on the associated datagrid , I want to return the original values
> > for
> > changing them
> >
> > An example will be more clear:
> >
> > If I have these original values for codi, data_peticio and name :
> >
> > 1000,1/1/2007,Roger
> >
> > And I change the "name" to other value, when I do the data adapter
> > update,
> > it works perfect, but, if I change the code or data_peticio, nothing
> > happens
> > (no errors, no update).
> >
> > The same happens if I undo the definition of the primary key on the
> > table.
> >
> > What's the problem ?
> >
> >
> > Thanks in advance,
> >
> >
> > Roger Tranchez
> > .NET 2005 and DB developer
>
>
>

"Roger Tranchez" <RogerTranc***@discussions.microsoft.com> wrote in message
news:7FCC83C1-C7CF-453E-95EA-F564132C9ADA@microsoft.com...
> Hi,
>
> THIS IS an absolute satisfactory answer ! thanks a lot... nothing like
> being
> a "crack" as you... thanks again.
>
> p.d.: I love managed newsgroups 8-D ; I hope someday I could help others
> as
> you so easily...
>
> --
> Roger Tranchez
> .NET 2005 and DB developer
>
>
> "RobinS" wrote:
>
>> You are setting code to the original version in both cases. You need to
>> use
>> different parameters, one for codi in the SET clause, and one for codi
>> in
>> the WHERE clause. Same for data_peticio.  The one in the WHERE clause
>> should be DataRowVersionOriginal, the other one needs to be
>> ModifiedCurrent.
>> Robin S.
>> ---------------------------------------
>> "Roger Tranchez" <RogerTranc***@discussions.microsoft.com> wrote in
>> message
>> news:21B62709-128A-461C-ACDA-893ACD979F3C@microsoft.com...
>> > Hello,
>> >
>> > I'm trying to update some records of a database table called
>> > "PETICIONS_TRESORERIA" with this structure:
>> >
>> > codi        int
>> > data_peticio datetime
>> > name            varchar
>> >
>> > (first two fields made the primary key)
>> > .
>> > .
>> > .
>> > I'm using a data adapter with a UpdateCommand as follows:
>> >
>> > update PETICIONS_TRESORERIA set
>> > codi=@codi,data_peticio=@data_peticio,name=@name where codi=@codi and
>> > data_peticio=@data_peticio
>> >
>> > The "SourceVersion" property for the UpdateCommand parameters @codi
>> > and
>> > @data_peticio, are set to "DataRowVersion.Original", as if the user
>> > change
>> > them on the associated datagrid , I want to return the original values
>> > for
>> > changing them
>> >
>> > An example will be more clear:
>> >
>> > If I have these original values for codi, data_peticio and name :
>> >
>> > 1000,1/1/2007,Roger
>> >
>> > And I change the "name" to other value, when I do the data adapter
>> > update,
>> > it works perfect, but, if I change the code or data_peticio, nothing
>> > happens
>> > (no errors, no update).
>> >
>> > The same happens if I undo the definition of the primary key on the
>> > table.
>> >
>> > What's the problem ?
>> >
>> >
>> > Thanks in advance,
>> >
>> >
>> > Roger Tranchez
>> > .NET 2005 and DB developer
>>
>>
>>