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
>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