While loop

[Ali Rizwan]

Hi
I want to make a loop which will be terminated when data record ends or statement will be true.

[Killer42]

I want to make a loop which will be terminated when data record ends or statement will be true.

What do you mean exactly by "when data record ends"? Are you looping through the fields in the record, or what? As far as "statement will be true", in VB a statement isn't True or False. You must be referring to some sort of expression or condition that you want to be True. To drop out of a While loop when a condition is true, you just code that condition in the While statement.

[Ali Rizwan]

What do you mean exactly by "when data record ends"? Are you looping through the fields in the record, or what? As far as "statement will be true", in VB a statement isn't True or False. You must be referring to some sort of expression or condition that you want to be True. To drop out of a While loop when a condition is true, you just code that condition in the While statement.

I want to add items from a database in combobox using loop.
I dont know which loop is used is it do while?
Plz tell how can i do

[QVeen72]

Hi Ali,

Use DO Loop:

[code=vb]
Combo1.Clear
RST.MoveFirst
Do While Not RST.EOF
Combo1.AddItem RST(0)
RST.MoveNext
Loop
[/code]

Regards
Veena

[Killer42]

Use DO Loop ...

Good advice. But personally, I feel the Until seems more sensible in such a situation (though of course, the end result is the same). For example...

[code=vb]Combo1.Clear
With Rst
.MoveFirst
Do While Until .EOF
Combo1.AddItem .Fields(0)
.MoveNext
Loop
End With[/code]

[pureenhanoi]

Good advice. But personally, I feel the Until seems more sensible in such a situation (though of course, the end result is the same). For example...

[code=vb]Combo1.Clear
With Rst
.MoveFirst
Do While Until .EOF
Combo1.AddItem .Fields(0)
.MoveNext
Loop
End With[/code]

i havenot try your code yet. But the standard Loops in VB maybe haven't Do While Until.
some standard loops are:
Do While (condition)
.........
Loop

Do Until (condition)
..........
Loop

While (condition)
..............
Wend

Ofcourse, its great if we have many out of standard loops.

[Killer42]

Sorry, Do While Until was an error. I failed to remove the While.