>Hi Group.
>
>Is there a way to show the results of an UPDATE command? Example:
>
>UPDATE Client SET CurrAge = CurrAge + 1
>
>From this UPDATE, I want to show the new value for CurrAge. There's a need to commit this result to another table.
>
>We should consider a nethood with N users, and this result should be individual for each user.
What do you mean with "the" new value? The command above will change ALL records in the table.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
