I have a While drSQL.Read()
do something
End While

I need the While so I can't use the else and don't know what the
alternate condition of the drSQL.Read() could be.

BUT, if the While loop is not entered I need it to do something
different.
Any help is appreciated.
Thanks,
Trint

..Net programmer
(E-Mail Removed)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Trint,

You can develop an 'if' condition inside the while loop and use 'loop' to
loop out of it if appropriate.

HTH,

Bernie Yaeger

"Trint Smith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a While drSQL.Read()
> do something
> End While
>
> I need the While so I can't use the else and don't know what the
> alternate condition of the drSQL.Read() could be.
>
> BUT, if the While loop is not entered I need it to do something
> different.
> Any help is appreciated.
> Thanks,
> Trint
>
> Net programmer
> (E-Mail Removed)
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

You can use a flag to test if you entered the while loop

Dim bFoundSome = false
While drSQLRead()
bFoundSome = true
End while
If not bFoundSome then ....

There are a bunch of other ways to do.
"Trint Smith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a While drSQL.Read()
> do something
> End While
>
> I need the While so I can't use the else and don't know what the
> alternate condition of the drSQL.Read() could be.
>
> BUT, if the While loop is not entered I need it to do something
> different.
> Any help is appreciated.
> Thanks,
> Trint
>
> .Net programmer
> (E-Mail Removed)
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>

Thanks, this will work
Trint

.Net programmer
(E-Mail Removed)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!