>>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.
In my
Query tool, a data source (i.e Collection, array, etc.) is converted to a cursor. The original SQL statement is parsed into a executable version of the SQL statement. The new SQL statement is executed. The _TALLY is saved. The resulting cursor is then convert to a destination data source, and saved tally is returned. But the INSERT - SQL is returning the zero. By work-around was saving the reccount before executing the SQL statement and calculating the difference afterwards and updating the _TALLY variable.
Greg Reichert