community.borland.com

Article #25419: Copying data from InterBase to Paradox table

Problem:
How can I transfer data from an InterBase table to a 
Paradox table with the same field names and 
data types?		

Solution:
/*******************************************************************************/
Note: The information in this article applies to
            * Paradox for Windows version 7 (16 and 32bit versions.)
            * Database desktop version 7
            * All Delphi versions 
     
/********************************************************************************/
There are a couple of ways of accomplishing this task.

1. Use Borland's Database Desktop.
  a. Tools |Utilities |  Add
      You can use the Tools |Utilties | Add menu choices 
      in the Database Desktop to add data copied from an 
      InterBase table to an already created Paradox table.  

      In order for this to work, you must set up a BDE alias 
      to access the Interbase database. The BDE alias tells 
      the system where to find the database to pull data from.

  b. Tools | Utilities |  Copy
       You can create a new Paradox table with the data from the 
       InterBase table by copying from InterBase table.

 c. Run a query.
    The menu choices to run a query are either 
    File | New | QBE Query or File | New | SQL file,
    depending on whether you want to run a SQL Query 
    or a QBE style query.  Either kind of query will successfully 
    retrieve data from an InterBase database.  It is up to you 
    which kind  you choose to run. 

    When you  run a query to select the data from an InterBase 
    database,  the result will be in :priv:answer.db. (Paradox / DBD 
    does allow you to change the name of the table holding the 
    result set of records.  :priv:answer.db is the default name for 
    the table holding the results of the query. )   As long as the field 
    names and types completely match between the answer table 
    and the destination table, you can simply use the Tools | Utilities 
    |  Add menu choice to add the data to the already existing Paradox 
    table.

2.  Use a TBatchMove component in a Delphi or C++Builder application.

Last Modified: 27-OCT-00