Board index » delphi » HOW TO TAKE COLUMN OF DATA FROM ONE DBF and MOVE to ANOTHER DBF?

HOW TO TAKE COLUMN OF DATA FROM ONE DBF and MOVE to ANOTHER DBF?

What is the best way to take a column of data from one DBF and INSERT it
into another DBF at run time?  I have tried browsing through quite a bit of
the help info and through various books, but have not come up with a clear
answer.   What I have so far
is a Table1: TTable pointing to one DBF and another TTable pointing to
other DBF file.  I have a TDBGrid on the form to display the data from
Table1.  I would like to take a column from Table2 and insert say in
between columns one and two in Table1 and have it appear on the TDBGrid
display.  I am new at this and a few detailed pointers on how to do this
would be greatly appreciated.
Thank you.

Paul Hooper
unit...@execpc.com

 

Re:HOW TO TAKE COLUMN OF DATA FROM ONE DBF and MOVE to ANOTHER DBF?


Paul!
Can you be more specific?
Are you trying to move data from table2 to table1 or do you only wan't
to display columns from different tables in one DBGrid?
-----------------------------
Ingemar Magnusson, Oxel?sund, Sweden
ingemar.magnus...@swipnet.se

Re:HOW TO TAKE COLUMN OF DATA FROM ONE DBF and MOVE to ANOTHER DBF?


I would like to take specific columns of data from two existing files, and
combine them into a third file.

Ingemar Magnusson <ingemar.magnus...@swipnet.se> wrote in article
<6969oo$7...@forums.borland.com>...

Quote
> Paul!
> Can you be more specific?
> Are you trying to move data from table2 to table1 or do you only wan't
> to display columns from different tables in one DBGrid?
> -----------------------------
> Ingemar Magnusson, Oxel?sund, Sweden
> ingemar.magnus...@swipnet.se

Re:HOW TO TAKE COLUMN OF DATA FROM ONE DBF and MOVE to ANOTHER DBF?


  Use Database Desktop to develop a *.QBE or *.SQL that accomplishes what
you want, then look in the BDE help file under DBIMakePermanent if you need
a physical table.

Paul Rice

P.S.  The database.desktop newsgroup will get you quicker answers.

Quote
Paul Hooper wrote in message <01bd1f84$e5a805a0$0c29cfa9@p590>...
>I would like to take specific columns of data from two existing files, and
>combine them into a third file.

>Ingemar Magnusson <ingemar.magnus...@swipnet.se> wrote in article
><6969oo$7...@forums.borland.com>...
>> Paul!
>> Can you be more specific?
>> Are you trying to move data from table2 to table1 or do you only wan't
>> to display columns from different tables in one DBGrid?
>> -----------------------------
>> Ingemar Magnusson, Oxel?sund, Sweden
>> ingemar.magnus...@swipnet.se

Other Threads