> Hellow Sir Boudewijn..> > Thanks...> Just like what I replied to Sir Eric Doop, I haven't used _tally system variable for a very long time,> that's why i have almost forgotten what was that for (which is correct)... > > Your code is the same with (if i weren't mistaken):> SET DELETED ON> SELECT * FROM INTO CURSOR cTemp> ?RECCOUNT('cTemp')> > Deleted records are not included if you transfered them into a cursor (if you didnt omit SET DELETED ON)> My problem occurs when I issue DELETE in a cursor-to-cursor (from SELECT SQL command) table, and> I have to return the total records of the active cursor...> > Thanks!> GOD bless...> > > Jefferson Aguilar of Nueva Ecija Philippines> jeffaguilar_pyc@yahoo.com> "There is only one GOD... and He loves us all..."

No, SQL - Select ignores the deleted() setting, therefore you need that in the where clause.

Boudewijn Lutge®inkThere are 10 types of people: Those that do understand binary calculations and those that do not.