Copy Table

Thema durchsuchen

Ansicht

Themen-Optionen

Ein Thema von danten · begonnen am 30. Aug 2013 · letzter Beitrag vom 1. Sep 2013

Vorheriger Beitrag

Nächster Beitrag

Medium

Registriert seit: 23. Jan 2008
3.688 Beiträge

Delphi 2007 Enterprise

AW: Copy Table

30. Aug 2013, 13:47

Zitat von danten:

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)