Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set fields problem
Message
From
20/06/2005 12:00:30
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01023288
Message ID:
01024873
Views:
20
Thanks Fred. I'll give that a try.

>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
Previous
Reply
Map
View

Click here to load this message in the networking platform