>Hi Jim, thanks for the reply.
>
>>Where the procedure is working for your other child views, I would assume there is something corrupted in this one. Have you tried recreating it from scratch?
>
>I have discovered what is causing the problem. The view was a SELECT from a second view, which was updatable. Recreating the view to requery the back-end tables directly solved the problem.
>
>Regards,
>Alan
Now THERE'S a relief!
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.