Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 To: Ellen Solomon
  Where is Ellen Solomon?
 Bet Shemesh
 Israel
 Ellen Solomon
 Tags
Subject: RE: count records of closed table?
Thread ID: 155321 Message ID: 155334 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Sunday, December 30, 2007 2:31:03 PM         
   


The intention is to take a random (and somewhat evenly selected) subset of n records from a table to make some statistical assumptions about the data without processing the entire file.


Ellen,

your select statement:

SELECT * FROM myTable INTO CURSOR FieldChk WHERE MOD(RECNO(), lnDivisor) = 0


gives indeed that result. No problem

Regards,

Koen

ENTIRE THREAD

count records of closed table? Posted by Ellen Solomon @ 12/29/2007 10:38:26 PM
RE: count records of closed table? Posted by Eric den Doop @ 12/29/2007 10:50:53 PM
RE: count records of closed table? Posted by Ellen Solomon @ 12/29/2007 11:39:47 PM
RE: count records of closed table? Posted by Koen Piller @ 12/30/2007 10:24:22 AM
RE: count records of closed table? Posted by Ellen Solomon @ 12/30/2007 10:32:35 AM
RE: count records of closed table? Posted by Koen Piller @ 12/30/2007 2:31:03 PM
RE: count records of closed table? Posted by tushar @ 12/30/2007 6:34:41 PM
RE: count records of closed table? Posted by Ellen Solomon @ 12/30/2007 8:55:08 PM
RE: count records of closed table? Posted by tushar @ 12/31/2007 4:30:32 AM
RE: count records of closed table? Posted by Mike Yearwood @ 12/31/2007 4:34:49 AM
RE: count records of closed table? Posted by Ellen Solomon @ 12/31/2007 10:43:53 AM
RE: count records of closed table? Posted by Hugo Ranea @ 12/31/2007 6:17:26 PM
RE: count records of closed table? Posted by Tamar Granor @ 1/3/2008 10:45:33 PM
RE: count records of closed table? Posted by Ellen Solomon @ 1/5/2008 5:04:13 PM
RE: count records of closed table? Posted by Tamar Granor @ 1/7/2008 11:05:53 PM
RE: count records of closed table? Posted by Ellen Solomon @ 1/9/2008 10:40:36 AM
RE: count records of closed table? Posted by Ellen Solomon @ 1/10/2008 9:13:28 AM
RE: count records of closed table? Posted by Tamar Granor @ 1/10/2008 11:16:40 PM
RE: count records of closed table? Posted by Ellen Solomon @ 1/11/2008 9:58:29 AM
RE: count records of closed table? Posted by Cetin Basoz @ 1/4/2008 1:59:06 PM
RE: count records of closed table? Posted by Mike Yearwood @ 1/5/2008 5:04:55 PM
RE: count records of closed table? Posted by Cetin Basoz @ 12/29/2007 10:52:11 PM
RE: count records of closed table? Posted by Eric den Doop @ 12/29/2007 10:53:06 PM
RE: count records of closed table? Posted by Amphie Lucas @ 1/4/2008 6:30:58 AM
RE: count records of closed table? Posted by Nishant Gupta @ 1/4/2008 2:30:07 PM