I am trying to append data from various files of varioius formats. for now: dbf, txt, cvs and txt.
I want to block my primary key field from the fields being appended. I have a default set for it, and that is what I want to assign pk's. the rest of the fields (name, addr...) I want to append from.
If the source is dbf, I don't know what fields will and won't be there, so I can't just list out all the fields in the destination table (less the pk), because they may not exist in the source.
I have tried using
SET FIELDS TO ALL EXCEPT PKAD
but the APPEND FROM command seams to ignore it.
APPEND FROM (LCFILNAM) FIELDS ALL EXCEPT PKAD
is a syntax error.
anyone got any interesting ideas?