Subject | Re: [IBO] copy table? |
---|---|
Author | nibler@t-online.de |
Post date | 2004-01-29T10:59:32Z |
Gerhard,
begin
IB_Query.GetCreateTableSql(IB_Dsql.Sql,false,false);
IB_Dsql.Sql[0] := 'Create Table ' + MyNewTableName + ' (';
try
IB_Dsql.Execute;
My_IB_Dsql_Transaction.Commit;
except
Application.HandleException(IB_Dsql);
end;
end;
... thereĀ“s allways a better way :-)
Cheers,
Harald
> what is the best way do copy programmable a table-schema?procedure CopyTable;
begin
IB_Query.GetCreateTableSql(IB_Dsql.Sql,false,false);
IB_Dsql.Sql[0] := 'Create Table ' + MyNewTableName + ' (';
try
IB_Dsql.Execute;
My_IB_Dsql_Transaction.Commit;
except
Application.HandleException(IB_Dsql);
end;
end;
... thereĀ“s allways a better way :-)
Cheers,
Harald