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?
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.