![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Sat, Aug 8 2009 4:00 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Very simple After Insert script on a table to update a second table
BEGIN EXECUTE IMMEDIATE 'UPDATE MailBoxes SET _OnFile = _OnFile + 1 WHERE _BoxNo = '+CAST(NEWROW._fkMailBoxes AS VARCHAR); END How, in a multi user environment do you make sure it gets executed. In Delphi I'd simply add a loop and a try..except block to make sure. Is that approach the best one for triggers or is there a better way? Roy Lambert |
Mon, Aug 10 2009 2:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< How, in a multi user environment do you make sure it gets executed. In Delphi I'd simply add a loop and a try..except block to make sure. Is that approach the best one for triggers or is there a better way? >> I assume that you're talking about a possible row lock issue ? If so, then you would simply hande the exception (1005) in a BEGIN..EXCEPTION block and use an outer WHILE loop to keep trying until it succeeds. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |