You have 2
While DataReader.Read loop. Each read makes the record pointer advances by 1!
>Dear The Expert,
>I don't understand .. why my looping process below (with level break condition) does not working ..I meant the "mTotalFreq" always has incorrect value.. it seems like the looping process has skipped one or some records, am I missing something?
>
>DataReader = Cmd.ExecuteReader
>While DataReader.Read
> mHostCode = DataReader("HostCode")
> While DataReader.Read = True And DataReader"HostCode") = mHostCode
> mTotalFreq = mTotalFreq + DataReader("TotalCost")
> End While
>End While
>DataReader.Close()
>SQLTemp.Close()
>
>I need advise .. many thanks in advance
>
>Regards
>Winanjaya
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com