Can't update row, No Matching row found

0 votes

when I select a row and then try to update it~I get the following message

Can't update row, No Matching row found

This was working fine but suddenly stopped working

any pointers would be helpful

in Errors by (120 points)

1 Answer

0 votes

The most likely reason is that the table has no primary key or unique index.

When a table has no way to uniquely identify individual records then dbFront will do it's best to continue functioning but if you attempt to update a row where multiple records might match the update request then it will fail and roll-back the attempted update.

Please open the table properties. If the table is missing a primary key then dbFront will place a warning in the table properties dialog.

Newer versions of dbFront return the message: "No single matching row found".

by (64.5k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer