Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace table1.field while table2 is selected fails
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00996391
Message ID:
00996397
Views:
15
Well naturellement, as you don't have the table selected. Try:

use table1 in 0
use table2 in 0
select table2
replace field with anothervalue in Table1

Terry

>This behavior continues to vex me
>
>use table1 in 0
>use table2 in 0
>select table2
>replace table1.field with anothervalue
>
>This occassionally fails on me for no apparent consistent reason.
>If you issue a select table1 first as such:
>
>select table1
>replace table1.field with anothervalue
>
>Then Fox never fails to replace the field.
>
>Does anyone have any ideas?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform