updating main data source

[Grant]

For some reason I cannot update certain adapters using the command:
'predecessorAdapter.Update(agencyDatabaseDataset1)'.

The error message I get is:

Operation must use an updateable query.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)
at AgencyDatabaseAdminTool.MainForm.menuItem4_Click(Object sender,
EventArgs e)

Does this have anything to do with the insert or update statement?

Update statement looks like:
UPDATE Predecessor
SET comments = ?, predecessor = ?, successor = ?
WHERE (predecessor = ?) AND (successor = ?)

Insert statement look like:
INSERT INTO Predecessor
(comments, predecessor, successor)
VALUES (?, ?, ?)


Thanks,
Grant

 

[William Ryan eMVP]

Hi Grant:

The first thing to look at is verify that you have a primary key . This is
the most common cause of this particular error that I've seen.

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/