problem caused by DB triggers

[garwain]

I have a program that retrieves about 99.9% of it's data from a MSSQL database, and now there are getting to be several triggers on key tables in the database to try to centralize more code. For example since a couple other program deal with the ordering and receiving of materiel, there is a trigger that will set a part's status to received when the quantity ordered = the quantity received.

Now this is causing problems for my. When a person opens a form that contains information on the part and changes the quantity Received, as soon as the changes are posted the trigger is executed (that's good, works as it's supposed to) but then I get an exception saying "Row cannot be located for updating. Some values may have been changed since it was last read."

The data is actually saved to the data, and I've tried using
try
qMateriel.post;
finally
qMateriel.requery;
end;

but I still get the exception.


Ben Martin

If this helps you please accept my response.

[jdawkins]

My recommendation would be to perform updates with the sql update function rather than Edit and Post of the dataset. Datasets are very particular about data being updated behind their backs =)