> *(It's inefficient in your coding to have TWO Fetch commands, one inside the > loop and one outside > Fetch Rt1 into vProjID INDIC ivPJD, vQT1 INDIC ivQT1, vCODE INDIC ivCODE, + > vSTARTDTE INDIC iVSTARTDTE, vENDDTE INDIC ivENDDTE
I agree with your changes Except for the theory on the Fetch... With the first Fetch before the beginning of the While loop, Fetch is called the Exact "number" of times to circumvent the recordset, so the Only thing that is different is writing the Fetch statement Twice in Code. This is small potatoes compared to the Condition checking in your While Loop. Having the While check for the SqlCode Once per Loop would be more desirable than Checking Twice per Loop in your scenario, Once for the While condition and Once for the If condition... I understand the desire to use the Fetch only once, because you have reduced the chance for error in the Fetch by Half, but for my money, I'll stick to the old way.
