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