Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace all for NOT WORKING
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00285991
Message ID:
00286047
Views:
24
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform