NTH select in VFP6

[Guest_imported]

Hello all, I have a database, that I want to set up nth selects based on a number of available records to fill a certain qty, and I need to know the best way to do this.

for example if my database is say 1000 records, and I want to pull a total of 100 records, I will NTH across the file to pull 10 percent, or every 10th record. Of course, it wont always be those nice whole numbers.

Please help,

Thanks in advance.
-Mike

 

[rajeevnandanmishra]

Hi,

You can use following query to select desired no. or percent of record.

SELECT TOP 10 PERCENT * FROM myTable ORDER BY myColumn

Ofcourse, if you omit "PERCENT" clause then there will be no need to give fraction numbers (e.g. 10.5). In that case it always make the integer part of fraction and then give you the result.

 

[jimstarr]

Hi Mike,

You can do something like:

SELECT * from tablex WHERE MOD(RECNO(), qty) = 0 INTO CURSOR cursorx

Jim