Thema: Copy Table

Einzelnen Beitrag anzeigen

Medium

Registriert seit: 23. Jan 2008
3.686 Beiträge
 
Delphi 2007 Enterprise
 
#2

AW: Copy Table

  Alt 30. Aug 2013, 14:47
Hi all.
How can I copy data from one table to another table...
up until here, I can follow.
Zitat:
...for DBGrid.Visible conditions.
this part however needs some explaining.

Copying tables in SQL is rather easy. Create a second table with an identical structure like the one you want to copy, and then INSERT INTO myNewTable SELECT * FROM originalTable will fill it with a full copy. (It gets a bit trickier when triggers and/or constraints are present.) So far, I don't know how a DBGrid is relevant to the copying itself.
"When one person suffers from a delusion, it is called insanity. When a million people suffer from a delusion, it is called religion." (Richard Dawkins)
  Mit Zitat antworten Zitat