>>>>
>>>>I suspected that I was dealing with a VMP problem, and now it looks like it has to be a problem with the view itself.
>>>>
>>>>Dan
>>>
>>>
>>>Ok. Next round of tests... If you close VFP session B, reopen it, and REQUERY(),does the data show up? What about if you TABLEUPDATE from A, and close session A? IOW, does the view update ever work? This will determine if it is a view definition, or a network buffering problem...
>>
>>I just received a message from Drew's message board that this is a problem across the network, and that they have implemented a similar solution.
>>
>>I was using a multi-table view that updated only one table. After simplifying the view to a simple parameterized view the problem goes away.
>>
>
>I fixed the problem by moving the LEFT OUTER JOIN logic to the WHERE clause, obviously making it an INNER JOIN.
>
>Two problems with this approach. 1st, I'm not 100% sure that I don't need the outer join. 2nd, the WHERE clause approach is much slower.
>
>Dan
Howsabout posting the posting the SQL? Maybe someone here can help you optimize it.
Erik Moore
Clientelligence