Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set fields problem
Message
From
14/06/2005 17:58:16
 
 
To
14/06/2005 17:27:21
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01023288
Message ID:
01023294
Views:
17
This message has been marked as the solution to the initial question of the thread.
COPY TO has it's own EXCEPT list.
COPY TO (yourfilevar) FIELDS EXCEPT notes, notinmodel TYPE FOX2X
>The following code dies with an error.
>
>
>sele countmaster
>set fields to all except notes, notinmodel && we want to exclude these 2 fields from the copy
>copy to (savefile) type foxplus
>
>
>Countmaster is a parent table in a parent/child relationship. The error states that variable 'P1' cannot be found. P1 is a fieldname in the child table. What I don't understand is why this would fail since only the parent table is being copied. I thought it might be a problem with the screen refresh so I set lockscreen to .T. which didn't help. I also tried breaking the relation before the copy which also didn't help.
>
>Can someone explain what's going on and how to resolve this?
>
>Thanks
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform