🚀 go-pugleaf

Thanks.
I was doing something like that, but now I am doing the insertion with a
TADOCommand that seems to be a little faster.
What I would like to know is if is there any structure that would allow me
to copy all records from the DBase table to it, then add two more fields to
each record with some calculations, and after that save all records to de
SQL server table. I am thinking about an intermediary, or something like
that.
Thanks again:
Ines

"Max Luzin" <maksim.luzin@wsy.lt> escribi� en el mensaje
news:3e51e988@newsgroups.borland.com...
>
> "In�s Fern�ndez" <ifernandezmed@terra.es> wrote in message
> news:3e4cf489$1@newsgroups.borland.com...
> > Hi all!
> > I am working in a program that must import data from a DBase table to
> > another table in an SQL server database. The second table has two more
> > fields than the first one, but the rest of the fields are the same.
>
>
> You can use two ADO datasets: one for import (dBase) and second for export
> (SQL Server). Something like this:
>
> ImpTable->First();
> while (!ImpTable->Eof)
> {
>     // Process each record here
>     ExpTable->Append();
>     ExpTable->Fields->Fields[0]->Value = ... // Process field values from
> ImpTable (conversion, etc)
>     ExpTable->Fields->Fields[1]->Value = ...
>     ExpTable->Fields->Fields[2]->Value = ...
>     // ... and so on
>     ExpTable->Post();
>     ImpTable->Next();
> }
>
> Max
>
>
>