Can't update one side of a composite primary key - TechRepublic
Question
June 5, 2009 at 07:26 AM
rmccollo

Can’t update one side of a composite primary key

by rmccollo . Updated 17 years, 1 month ago

I’m having a horrible time trying to discover why I can’t update one side of a composite primary key in asp.net FormView control.

I have a table that uses a number field and a field called Alias that I need to update. I am able update the Alias field fine in my Access database that links the Oracle tables, but not in the FormView where I need it for my web application. I’m using the standard sqldatasource with update, insert, and delete commands. I don’t get an error – the update just doesn’t go in for Edit mode. No problem with inserting. Tried adding :original_alias in the where clause – had no effect. I have a short schedule for developing this web application. Please help!

This discussion is locked

All Comments