Link to home
Start Free TrialLog in
Avatar of karthikr
karthikr

asked on

Two Database Connections

I Have a question regarding Whether i can open Two databases using CDatabase at the Same time. I have the following problem. I have to read records from one Database And then transfer those records to a different Database. I would like to know whether this is possible in any way without closing the recordsets or the databases and opening the other connection.

I would also like to know whether i can Create a Database dynamically creating also a table Dynamically.

Thanks in Advance
Karthik
ASKER CERTIFIED SOLUTION
Avatar of Liu
Liu

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wyy_cq
wyy_cq

supposing the two table have same structure.
bind proper var to each record.
for each record
{
   pRec1->Move
   copy var value from rec1 to rec2
   pRec2->Add
   pRec2->Update
}