Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Empty Storage DB with different Dataset

Status
Not open for further replies.

Ragnarox

Programmer
Oct 2, 2003
141
US
Hello all,

I am attempting to update an empty database with information from another database. I have tried many different approaches as follows (shortened for general understanding) :

1. while loop
drStore = New rows for storage ds
drInfo = info ds row at count
drStore = drInfo
add drStore to storage ds
inc count
end while

2. while loop
drStore = New rows for storage ds
drStore = info ds row at count
add drStore to storage ds
inc count
end while

3. open connection
daStore.Update(infods, "Info")
close connection

The first trwo attempts would not let me copy the info into the other and the last attempt, which was done on MSDN website under Q310347, gave me a concurrency error. Affected no rows.

Is there something that I am missing? I know there has to be a way to do this, but I am stumped as to how to go about figuring it out. If anyone out there can point me in the right direction to finding the correct way this can be done would help out tremendously.

Any help, as always, is greatly appreciated.

Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top