Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access selected table???
Message
 
To
15/12/2000 12:30:15
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00453886
Message ID:
00454102
Views:
27
>I did not know this was a know problem.

Actually, it's not a "known problem" -- it's exactly what's supposed to happen. REPLACE can operate on multiple tables. If the table in the current work area is at EOF(), you'd be left with a half-completed update. This would be a Bad Thing, so REPLACE doesn't do anything.
USE tableA IN 0
USE tableB IN 0

SELECT tableB
GO BOTTOM
SKIP
REPLACE tableB.field1 WITH "fred",
   tableA.field1 WITH "wilma"
Strangely enough, it doesn't seem to check in the other direction....
SELECT tableA
GO BOTTOM
SKIP

SELECT tableB
REPLACE tableB.field1 WITH "fred",
   tableA.field1 WITH "wilma"
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Reply
Map
View

Click here to load this message in the networking platform