Hi Dragan,
>It has always worked this way. Even deleted records count ... It would be just damn too slow if it counted visible records each time. So... an updatable parametrized view, or a simple cursor with properties set so that it would be updatable, is your ticket.
OK, you sold me! Back to my original plan A which was a seperately maintained cursor. (Thank god for source control!)
Thanks for setting me straight,
Malcolm