>>>Re-selecting doesn't seem to help. I did notice something strange, though. I watched the DataSession window while the code was being executed and when MyView was selected, I saw the cursor flash to the view and then back to the other table. I don't know why. Does it have anything to do with the fact that the view is based on this other table?
>>>
>>>Elyse
>>
>>Elyse, is anything changing data in the view? Could it be issuing an update for some reason that causes the SELECT are to move to a table?
>>
>>Barbara
>
>No, there aren't any updates being issued.
>
>Elyse
If you have so persistent problem, why not to try something simple, like
Select View1
COPY TO tmp1
Select 0
Use tmp1
REPORT FORM ...
Edward Pikman
Independent Consultant