[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

DB Append & Update at Runtime

Posted on 1997-08-16
1
Medium Priority
?
326 Views
Last Modified: 2010-04-06
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
Comment
Question by:d4jaj1
1 Comment
 
LVL 1

Accepted Solution

by:
jturpin earned 80 total points
ID: 1341637
Try looking at TTable.BatchMove.

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

0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses
Course of the Month9 days, 11 hours left to enroll

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question