Setrange

(0) Share

Report

Posted on by Community Member Microsoft Employee

When we apply setrange for customers. How to show from first range to last range through setrange. I tired with CustomerRec.FINDfirst then its showing 10000 and with findlast its showing 90000. How to show from 10000 to 90000 continuously? Please help me.

CustomerRec.SETRANGE("No.",'10000','90000');
IF CustomerRec.FINDSET THEN
MESSAGE('%1',CustomerRec."No.")
ELSE
MESSAGE('Not Found')

Thanks

*This post is locked for comments

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Setrange

Thank you so much guys.
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Setrange

Hello Madhavi,

Agree with [tag:Mohana]

you need to use REPEAT UNTIL

//CustomerRec.SETRANGE("No.",'10000','90000'); Instead of setrange use setfilter.

CustomerRec.SETFILTER("No.",'%1..%2','10000','90000');

IF CustomerRec.FINDSET THEN BEGIN

REPEAT

MESSAGE('%1',CustomerRec."No.");

// Here is your all records.

UNTIl CustomerRec.Next = 0;

END ELSE

MESSAGE('Not Found');
Verified answer

Mohana Yadav 59,114 Super User 2024 Season 2 on at

Like (0)

Report

RE: Setrange

you need to use REPEAT UNTIL

CustomerRec.SETRANGE("No.",'10000','90000');

IF CustomerRec.FINDSET THEN

REPEAT

MESSAGE('%1',CustomerRec."No.");

UNTIl CustomerRec.Next = 0;