>>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.
If it's not broken, fix it until it is.
My Blog