Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

DB Append & Update at Runtime

Using the Database Explorer, I can add records to a table from another table with the same structure using the Add method.  I can select the Append and Update option and the target table will update any existing records and append any new records in their proper position.  My question is, how do I do this in Delphi at runtime?  What are the methods or procedures? If this particular method doesn't exist, how would I do this using a Query?
0
d4jaj1
Asked:
d4jaj1
1 Solution
 
jturpinCommented:
Try looking at TTable.BatchMove.

Or TTable.Append;
   -- processing to load the fields --
   TTable.Post;

0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now