Board index » delphi » copying data from one table to another

sam washkansky

Delphi Developer
Sat, 31 May 2003 17:59:23 GMT

copying data from one table to another

I need to copy data from one table to another which has the colmn names
altered. This must be done at runtime.The Table are created at run and the
column names are changed so that there are no field names containing
reserved words. Can anybody help me?

sam

 
Smol

Delphi Developer
Sat, 31 May 2003 18:14:22 GMT

Re:copying data from one table to another


Quote
sam washkansky <s...@testladigital.com> wrote in message

news:914su3$b61$1@ctb-nnrp2.saix.net...

Quote
> I need to copy data from one table to another which has the colmn names
> altered. This must be done at runtime.The Table are created at run and the
> column names are changed so that there are no field names containing
> reserved words. Can anybody help me?

Take a look at the BatchMove component (and Mapping property).

--
Smola
--
"And once again, the day is saved"
(http://supersmola.tripod.com/index.htm)

Jake Anderso

Delphi Developer
Sun, 01 Jun 2003 01:51:02 GMT

Re:copying data from one table to another


if it is to a table component that you want to copy then the table component
has a batchmove method that will let you copy some other dataset into the
table.

Jake

Quote
"sam washkansky" <s...@testladigital.com> wrote in message

news:914su3$b61$1@ctb-nnrp2.saix.net...
Quote
> I need to copy data from one table to another which has the colmn names
> altered. This must be done at runtime.The Table are created at run and the
> column names are changed so that there are no field names containing
> reserved words. Can anybody help me?

> sam

Other Threads

1. Copy data from one table to another

2. HELP!! Copying data from one table field to another.

3. MSSQL7: How to copy data from one table to another without logging?

4. Copy data from table to another one?

5. Copy Table Data from one DB to Another

6. How to: copy a record from one table to another one

7. Copying one record from one table to another

8. New Table pointer and/or copying a tables data

9. Prob moving data from one table to diff table with array

10. pump data from one database table to another database table