1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Query1.SQL.Clear;
Query1.SQL.Text:='CREATE TABLE TMP (C1 CHAR(2),C2 CHAR(3),C3 CHAR(4),C4 CHAR(5))';
Query1.ExecSQL;
Query1.SQL.Clear;
Query1.SQL.Text:='INSERT INTO TMP SELECT * FROM T1';
Query1.ExecSQL;
Query1.SQL.Clear;
Query1.SQL.Text:='DROP TABLE T1';
Query1.ExecSQL;
Query1.SQL.Clear;
Query1.SQL.Text:='CREATE TABLE T1 (C1 CHAR(2),C2 CHAR(3),C5 CHAR(2),C3 CHAR(4),C4 CHAR(5))';
Query1.ExecSQL;
Query1.SQL.Clear;
Query1.SQL.Text:='INSERT INTO T1(C1, C2, C3, C4) SELECT * FROM TMP';
Query1.ExecSQL; |
Partager