>>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.
Actually, that is the problem. INSER-SQL does not effect _tally. But, according to Help it should.
create cursor test (name c(10))
_TALLY=99
insert into test values ("greg")
? _tally
Greg Reichert