Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REPLACE ALL, REPLACE ALL, REPLACE ALL, only 1st one work
Message
From
15/08/2000 08:06:01
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00404856
Message ID:
00404861
Views:
19
Hello, Steve.

From the MSDN - Replace command:

"Note If the IN clause is omitted, no replacement occurs if the record pointer is at the end of the file in the current work area and you specify a field in another work area."

This seems to be your situation.

You have at least two ways to solve this:

1. Try one GO TOP after every REPLACE ALL

2. (my favourite) Try to write a single line of code. Something like this:

REPLACE ALL table1.field1 WITH "text1" FOR condition, table1.field2 WITH "text2" FOR condition, table1.field3 WITH "text3" FOR condition.

Hope this helps.
Grigore Dolghin
Class Software.
Previous
Reply
Map
View

Click here to load this message in the networking platform