Cal wrote:

> How to
> get current amount of rows from table without disconnecting/connecting?

To supplement Galen's explanation, you're asking the wrong
question here. A transation is considered an atomic unit
of work, so "current" has no meaning to other users. To
others, the table is either in the "before" state or the
"after" state, and nothing in between.


Larry Coon
University of California