Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Jefferson Aguilar
  Where is Jefferson Aguilar?
 Cabanatuan
 Philippines
 Jefferson Aguilar
 Tags
Subject: RE: RECCOUNT() - is there other way??
Thread ID: 50646 Message ID: 50767 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: Other
Date: Monday, September 06, 2004 7:12:08 AM         
   


> 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Ā®ink
There are 10 types of people: Those that do understand binary calculations and those that do not.

ENTIRE THREAD

RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/4/2004 8:28:56 AM
RE: RECCOUNT() - is there other way?? Posted by Eric den Doop @ 9/4/2004 11:15:41 AM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:18:25 AM
RE: RECCOUNT() - is there other way?? Posted by Boudewijn Lutgerink @ 9/4/2004 11:20:53 AM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:30:05 AM
RE: RECCOUNT() - is there other way?? Posted by Boudewijn Lutgerink @ 9/6/2004 7:12:08 AM
RE: RECCOUNT() - is there other way?? Posted by Andy Kramek @ 9/4/2004 1:24:34 PM
RE: RECCOUNT() - is there other way?? Posted by Pete Sass @ 9/4/2004 5:27:24 PM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:44:37 AM
RE: RECCOUNT() - is there other way?? Posted by Jefferson Aguilar @ 9/5/2004 11:38:28 AM