Problems with selecting and updating tables

  • hi guys,

    do you know how can solve the following problem:

    "Query-based update failed because the row to update could not be found."

    thx,

    mike

  • Add the row its looking for? Are you getting this in a SQL tool, or from an application?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • If and application please let us know the name of the app as well. It should be sending something to the effect of

    UPDATE tblX SET colx = valx (WHERE clause if there)...

    But all that it sees is

    UPDATE tblX (WHERE clause if there)...

    or something else along those lines.

  • You need to supply more detail about what's failing.

    In EM, you can get this if you are trying to update rows from a complex view that doesn't include a key column from the base table you are trying to update.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply