Dynamics Community Forum Thread Details

x++ while select "next" record

Hi all,

Have some pseudo code:

SalesTable s;

SalesLine sl;

;

while select s where s.someconditions...

{

//do some stuff 1

sl = SalesLine::find(......);

if(sl.someFunctionThatReturnsAnInt < 300)

{

next s;

}

//do some stuff 2

}

-----------------------------

Question. The keyword "next" simply moves to the next record and continues down to "do some stuff 2?"

What I want is to recognize that my Int function is < 300 and then jump to the next record in the while select statement but I want it to jump to "do some stuff 1" instead of "do some stuff 2."

So basically how do you jump to the next record in SalesTable and continue at the top of the while select statement and bypass "do some stuff 2"

What I believe is happening now is that using "next" fetches the next s record but continues on to "do some stuff 2" which is not my desired results. I want to not continue on and start my with the next record at the top of the while select ("do some stuff 1")

Any ideas?

Thanks in advance!

----------

Edit: It seems like the "next" call isn't moving to the next record in SalesTable at all... Just pointing this out.

Quick Links

Leaderboard