Home All Groups Group Topic Archive Search About

Invalid Column on Update on table with extra column

Author
8 Nov 2006 8:30 PM
sutphinwb@nospam.nospam
Hi

I am trying to update a dataset table that I have added a column to
that is not in the database.  I load the column in the table RowChanged
event.  I don't want the column to be updated along with the rest of
the table fields, however, when I do the ta.Update(myTable), I get an
exception for an "Invalid Column" with the name of my extra column.  Is
there some way to make this column so that Update doesn't try to send
it to the stored procedure?

Thanks

Bill

Author
8 Nov 2006 9:15 PM
sutphinwb@nospam.nospam
Never mind.  It was a bug in a stored procedure.  Stupid.

sutphinwb@nospam.nospam wrote:
Show quote
> Hi
>
> I am trying to update a dataset table that I have added a column to
> that is not in the database.  I load the column in the table RowChanged
> event.  I don't want the column to be updated along with the rest of
> the table fields, however, when I do the ta.Update(myTable), I get an
> exception for an "Invalid Column" with the name of my extra column.  Is
> there some way to make this column so that Update doesn't try to send
> it to the stored procedure?
>
> Thanks
>
> Bill

AddThis Social Bookmark Button