Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Appending data from one table to another without overwriting
Hello everyone,
This is my first time writing to this forum and I am very happy to have found this resource! I need some help with the syntax for a program I am working on.
I have a grid that pulls records from "tableA" and would like to have the information that is updated on the grid inserted into another table "tableB" without overwriting existing records from "tableA". I have tried using "Append from" in the SQL but Fox Pro won't accept it. How can this be performed?
Here's the SQL I use:
SELECT * ;
APPEND FROM tableA;
ORDER BY tableA.fieldA;
INTO TABLE tableB
Also how can I have messages automatically responed to? For example when a message box appears with yes or no response buttons how can I make it automatically select "yes" so the process is not stopped and no user input is required? The return value should be 6 but how do I implement code to make the form choose it?
Thanks in advance for your help!
Max
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement