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