Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB-Aware

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 01-21-2002, 08:08 AM
garwain garwain is offline
Member
 
Join Date: Jun 2001
Posts: 50
Default problem caused by DB triggers

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.
Reply With Quote
  #2  
Old 01-21-2002, 09:47 AM
jdawkins jdawkins is offline
Member
 
Join Date: Jul 2001
Posts: 42
Default RE: problem caused by DB triggers

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 =)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:12 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.