>Hi Naomi, No... in your case i was referring to the actual coding of my mind.. I just use the curtemp for illustration purposes... sorry for the confusion. Again let me revise my example. This is my actual coding:
>
>cSelectStat = "select "+lcfields +;
> " FROM dride "+;
> " left Join dtpprates On dtpprates.ratespk = dride.ratedtppfk "+;
> " left Join dtpp On dtpp.tpppk = dtpprates.tppfk "+;
> " left Join CRSCHOSEN On CRSCHOSEN.tpppk = dtpp.tpppk "+;
>" left Join dpass On dpass.passpk = dride.passfk "+;
>" left Join CLIENT On CLIENT.personid = dpass.personidfk "+;
>" INTO Cursor crsbilling"
>
>&cSelectStat
>
>It triggers an error when excuting this statment:
>
>select crsbilling
>
>For the mean time I will try your advice.. Will get back to you. I going to my client right now and debug.

Perhaps you closed the cursor in between these two lines (or timer closed it)?