Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Param views not updating properly in 2 separate exes
Message
De
23/07/1999 13:42:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00244820
Message ID:
00245427
Vues:
17
>>>
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform