>I have a question about using insert into. I have one table that I want to add records to from another. I use the code
> SCATTER MEMVAR MEMO
> INSERT INTO NEWTABLENAME FROM MEMVAR
>
>Some of the fields are not getting updated. The fieldname, type, and sizes are the same in both tables. The order of the fields are not. Each table also has other fields. Why aren't all the fields getting updated?
>
>TIA
Superficially, what you're trying to do here should work.
How many fields are common to both tables, and what are their names (looking for reserved word field names here)?
How many non-common fields are in the source and destination tables?
Do you have a primary key in the destination table? If so, and you're not supplying a unique key value for each new record INSERTed, VFP will complain.
Is the destination table part of a database (.DBC), and are there any record-level database triggers in place?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up