looking for T[ODACClass].CreateTable to create table as a copy without using SQL

[Andreas Mosmann]

Hi, I still work with ODAC 4.50.0.15 on Delphi6.
I look for a possibility to create a table as a copy of another, something like

Code: Select all

Destination.FieldDefs.Clear;
for i:=0 to Source.FieldDefs.Count-1 do 
  Destination.FieldDefs.Add(Sorce.FieldDefs ...);
Destination.CreateTable;
Destination.Open;

Can someone tell me, howto? What type Destination has to be? What's the name of the CreateTable- command?

Many thanks
Andreas Mosmann

[Plash]

ODAC does not have such feature. You should use SQL statement to create a table.

[Andreas Mosmann]

It's a pity.
I hoped I could easily transfer a temp table from a dbf- file into an Oracle- DB. So I have to do more work.
Thank you
Andreas Mosmann