Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert
Message
De
08/05/2000 01:14:33
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Re: Insert
Divers
Thread ID:
00367149
Message ID:
00367152
Vues:
20
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform