>Can you think of any reason why this code would cause some, but not all, of my insert triggers to fail? Update triggers seem to work ok. All seemed to work ok until I upgraded to VFP9.
>
If the parent record is locked by another client, the new code causes the trigger to fail.
The difference between UPDATE and INSERT scenario can be due to the fact that the new code is not executed for an UPDATE when foreign key is changed (which would be a bug) or due to the fact that the UPDATE doesn't change foreign key.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only