Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to replace
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00352784
Message ID:
00352801
Views:
8
Hi Deamon

You should put ALL after REPLACE:

REPLACE table2.field1 WITH table1.field1, ;
table2.field2 WITH table1.field2, ;
table2.field3 WITH table1.field3 ALL;
FOR table1.field5 = table2.field5 AND ;
table1.field6 = table2.field6

Cause by default, REPLACE only change the next one!

Hope this help! :)
Merci!!!

--Séb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform