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:
Quote:
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 |