I need to know how can we use setrange , and findset().

(0) Share

Report

Posted on by ALICE THOMAS

I need to know how can we use setrange , the differnce between DocAtt("No.",rec."No."); see over here inside the bracket we are using the same fields ,whereas over here we are mapping 2 tables like this ItmCharPch.SetRange("Document No.", PurchOrderLine."Document No");

i need to know the differnce?

One more doubt which i have is findset what happens when we give untill SOHeader.Next() = 0;

if SOHeader.FindSet() then

repeat

until SOHeader.Next() = 0;

All responses (2)

Answers (1)

Sort by

Suggested answer

JAngle 159 on at

Like (1)

Report
Copy link

Link copied!

Context dependent. DocAttach one you are referring to the current record with “rec.”. The DocAttach table just happens to have a generic field name that exists in a lot of places in the database.

The second example is using a variable. So not the current record the user is accessing. It will be whatever record or set of records you determine for that instance of the table in the database. Both cases are legitimate.

The repeat until next()= 0; will loop through all records/values found/in the variable used. So if ten records are found it counts down from 10 on each loop. Once it is 0 the loop stops.
Verified answer

ALICE THOMAS 65 on at

Like (0)

Report
Copy link

Link copied!

Really appreciate your timely response and also thanks sharing the info !! now its understood.

Join the conversation

Community site session details

I need to know how can we use setrange , and findset().

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the August Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

I need to know how can we use setrange , and findset().

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the August Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates