Kim,
No, I didn't try to run it, though I may run it today in the evening. It looks OK from the logical point of view, but I try to run it to see, that's wrong.
>Dear Nadya,
>
>The second BEGIN TRANSACTION is just a typo on my part due to a bunch of cutting and pasting I was doing trying to get the code
>to behave. It should not be there and the code still works improperly with it removed. Sorry for the confusion.
>
>Your cleaned up code is more readable and I thank you, but the improper updating of field values still occurs on my system with
>your changes.. Did you actually run the code to see if your results are the same?
>
>Thanks,
>
>Kim
If it's not broken, fix it until it is.
My Blog