Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace all for NOT WORKING
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00285991
Message ID:
00286047
Vues:
25
>Hi,
>
>I've just set up my first VFP APP and installed it on site(Network of 3 PC's), and its working great, apart from one area I cant understand.
>
>I have one block which is as follows:
>
>SELE CMA
>REPLACE ALL CMA.CMA_DOCK WITH 'P' ;
> FOR ;
> CMA.CMA_DOCK <> 'P'
>
>(CMA is a table. This is done after a print run to flag all records as having been printed. I also have a Tag for cma_dock)
>
>Now, on my own local PC, this works perfectly.
>On the Network, the cma_dock IS NOT REPLACED, and I cant understand why.
>
>
>In my normal screens, I have optimistic buffering on and use updatable views and run TABLEUPDATE().These work fine.
>
>The above is in a separate screen with just about no other code.
>
>I wonder can anybody throw any light on this ?

You're certain buffering is not affecting this? Could Row buffering be on?

Other than that, I've seen this a few times, when one user has a table open and a record locked, and someone else is trying to do a REPLACE ALL - the replacements do not get made properly sometimes. I had to resolve this by having only a single user allowed to open the table in the process which allowed REPLACE ALL, everyone else out of the table...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform