PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 2024 → Return Range of Records
Return Range of Records
Débuté par Mister RUAN, 08 sep. 2017 13:10 - Aucune réponse
Membre enregistré
208 messages
Popularité : +1 (1 vote)
Posté le 08 septembre 2017 - 13:10
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