>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.

Can you post code that demonstartes the problem? So far im my tests in VFP9 regular INSERT-SQL does not affect _TALLY.