The following question is related to firedac using adquery, updatesql with access database:
First the scenario:
In one of scenario my updatesql gives an error i-e data in the table was not updated, however my dataset after showing error moves to next record. But now data is not in sync with table grid, which is based on this dataset*(adquery)* show updated version which was not successfully applied.
Yet the table still has the old version of the given record.
And my question:
- If an error occurs during modification how to know that
modifysqlwas not run successfully and trap that error to refresh the dataset as per data in table?