>>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
Elyse Pomerantz