COM Database VB6 question

[Ruslan Zasukhin]

on 2/22/04 5:17 PM, Lee Miller at leemiller at madisongrp.com wrote:

> I have 2 databases with the same exact structure.
> One has no records in any of the tables. The second database is in a
> different directory.
> All the table names are the same and all the field names within each table
> are exactly the same.
> I know how to move data from a non-Valentina database to a Valentina
> database using the ODBC tool.
> I would like to know the most efficient way to copy all the data from the
> first database to the second empty database through code.
> 
> I'm looking for something simple like:
> 
> Flush Database1.table1 To Database2.Table1
> Flush Database1.table2 To Database2.Table2

Hi Lee,

There is no such easy way.

A Little more complex.

You need make loop on each table
And in each table do loop on each record
    in this loop copy field to field


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------