i'm having problem exporting my data. my last item data went mising and not display out in the text file after the program has been ran. but i've run the query in sql everything works well.what is the problem, anyone please help me to check why did the data went missing?is there any problem with my query or my looping?


---results from program---
**************************************** BOF ****************************************
Production reported from : 24/09/2007 23:00 to : 25/09/2007 23:00
Report run at : Wednesday 26/09/2007 11:53
=====================================================================================

WKSFCL: BE1PE| WKSPRD: SFH6156-4-ASY| WKSROU: DIP4-MAIN| FT1OPR: 7310|

WKSLOT| OUTDTE| INPUT_| OUTPUT| REJECT| YIELD|



WKSFCL: BE1PE| WKSPRD: IL205AM-ASY| WKSROU: SO8AMATRIX| FT1OPR: 7310|

WKSLOT| OUTDTE| INPUT_| OUTPUT| REJECT| YIELD|
1|M1738468| 1|9/25/2007 4:04:18 AM| 1|9506| 1|9258| 1|248| 1|0.9739|
2|M1738470| 2|9/25/2007 4:05:52 AM| 2|9702| 2|9582| 2|120| 2|0.9876|



WKSFCL: BE1PE| WKSPRD: LH1510-ASY| WKSROU: SSR-MAIN| FT1OPR: 7320|

WKSLOT| OUTDTE| INPUT_| OUTPUT| REJECT| YIELD|
1|M1737704| 1|9/25/2007 4:23:32 AM| 1|3345| 1|3217| 1|128| 1|0.9617|




---results retrieve directly from db---
WKSFCL| WKSLOT| WKSPRD| OUTDTE| INPUT_| OUTPUT| REJECT| YIELD| TIMESTAMP|
BE1PE M1738468 IL205AM-ASY 9/25/2007 4:04:18 AM 9506 9258 248 0.9739 9/26/2007 8:20:37 AM
BE1PE M1738470 IL205AM-ASY 9/25/2007 4:05:52 AM 9702 9582 120 0.9876 9/26/2007 8:20:37 AM
BE1PE M1737704 LH1510-ASY 9/25/2007 4:23:32 AM 3345 3217 128 0.9617 9/26/2007 8:20:37 AM
BE1PE M1737B92 SFH6156-4-ASY 9/25/2007 7:23:16 AM 45852 44004 1848 0.9597 9/26/2007 8:20:37 AM
BE1PE M1738978 SFH6156-4-ASY 9/25/2007 3:49:08 PM 84306 82131 2175 0.9742 9/26/2007 8:20:37 AM



---missing data from the program results---
BE1PE M1737B92 SFH6156-4-ASY 9/25/2007 7:23:16 AM 45852 44004 1848 0.9597 9/26/2007 8:20:37 AM
BE1PE M1738978 SFH6156-4-ASY 9/25/2007 3:49:08 PM 84306 82131 2175 0.9742 9/26/2007 8:20:37 AM