>>I just try it in my 9.0 and too return 0. I ask a few colleages, and too got 0. Could Vista effecting this?
>
>Hi Greg,
>
>Sorry for confusion but INSERT-SQL command does not change _TALLY unless it's used with SELECT as in
>

>INSERT INTO...SELECT FROM...
>

>I'm not sure what you're trying to check because regular INSERT-SQL inserts exactly 1 record.

And we all took the bat :)

Now I checked correctly and yes, it doesn't change the _TALLY variable.