Fernando,

I don't know about Oracle, but in SQL Server you could do this with one statement on the server without going through the client. This should be much faster. Something like this:

*-- if the databases are on the same server
INSERT INTO TargetDb.dbo.TargetTable SELECT * FROM SourceDb.dbo.SourceTable WHERE WhereClause

*-- if the dbs are on different servers, you'd have to create a linked server and then use syntax like this:
INSERT INTO TargetServer.TargetDb.dbo.TargetTable SELECT * FROM SourceServer.SourceDb.dbo.SourceTable WHERE WhereClause

Since the table structures are identical, you wouldn't even have to mess with fieldnames.

HTH

>Hi,
>
>I need to create a VFP program that will copy selected records from one table to another (via SPT). For that purpose I must open two different ODBC connections, because the origin tables and destination tables reside in different Oracle databases.
>
>The origin and destination tables have the same structure. This program will be in charge of extracting selected records from a production database to a test database.
>
>If I new, in advance, the tables involved think it should be easy, but the issue is that the copy program will read parameters from a VFP table contaning wich tables to copy (table name), and what is the criteria to extract records from the origin table (the "where" clause).
>
>I thought doing something like the following (for each table to be copied):
>

>SqlExec (nOrigTableHandle, "Select * from " + cTableName + "... where " + cWhereClause, "TempCursor")
>
>Select TempCursor
>Go     Top
>
>Scan
>
>*   Here I must move each field of each row of TempCursor to temporary variables
>
>    . . . . (?)
>
>*   Here I must build a string with the Insert SQL
>
>    cInsertSqlString = "Insert Into " + cTableName + "...(?)..."
>
>    SqlExec (nDestTableHandle, cInsertSqlString, "")
>
>EndScan
>

>What is the best way to do this?
>
>Any ideas will be highly apreciated.
>
>Regards,
>
>Fernando