Devart Forums

Posted: **Wed 16 Jan 2008 17:40**

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

Posted: **Thu 17 Jan 2008 13:40**

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

Posted: **Thu 17 Jan 2008 13:52**

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

Devart Forums

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

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