Hi,

I am running Pervasive 2003

I need to copy some data from a table to a table on diferent database

Thank you all,

Bre-x

Assuming Pervasive.SQL 2000i...

INSERT INTO TargetDB.TargetTable
SELECT FROM SourceDB.SourceTable

You can also add fields to the select and/or insert sections to have a
bit more control over it.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: June, 2004: See our web site for details!


Bre-x wrote:

Pervasive.SQL does support running a single query against multiple
databases as well as multiple tables.

Providing both tables already exist and the database engine has access
to both databases (both defined on the same server) you should be able
to just perform a simple insert query from one to the other.

For more specifics see: http://www.pervasive.com/library/ or your
on-line documentation if you have Pervasive.SQL installed.
specifically the "SQL Engine Reference" manual.
http://www.pervasive.com/library/doc...40.html#166164

Leonard

On 9 Jun 2004 10:44:27 -0700, cholotron (AT) hotmail (DOT) com (Bre-x) wrote: