Hi to everyone, to those that Responded to my posted message "Oracle Woes" all your advices have been really insightful.

here is another problem that I encountered with Visual FoxPro 7.0 thistime.

i have used several types of looping statements like scan...endscan, do while !eof(), and do while (lCondition), but they all return the same problem, sometimes the loop would fail and not pick up the very last record in the loop even though if the condition right. so what seems to be the problem?