PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WEBDEV 2024 → Return Range of Records
Return Range of Records
Started by Mister RUAN, Sep., 08 2017 1:10 PM - No answer
Registered member
208 messages
Popularité : +1 (1 vote)
Posted on September, 08 2017 - 1:10 PM
Good Day

I have a Large Table and would like to bring in only certain amount of rows at a time. I have tried different methods but cannot get this to work. Here is what I have tried.

The nFirstRow and LastRow int Values will change (I have done that Calcs Already). I cannot get it to start at record 10 and run through to record 25 and add it to the table. Cannot even get it to return record 1 - 10. It returns everything or everything 15 Times.

Please can you tell me the best way to get this done.

nFirstRow is int
LastRow is int = 25

FOR nFirstRow = 10 TO LastRow
HReadSeek(MYDATA,ITEMCODE,"AAAA1111")
WHILE HFound(MYDATA) = True
TableAddLine(TABLE_NoName1,MYDATA.ItemCode,MYDATA.Description)
HNext(MYDATA,ItemCode)
END
END


Regards

Ruan