L
Loren S. Teillon
I'm trying to read records from a main table, along with data records
from dependant tables into a SQLAdapter. I will then need to make
some changes to certain field data. I will then need to insert these
records into another database (with same structures). Can some one
sling me some example code as how they would do this? The rudimentary
way would be to loop through each record, inserting into the
destination DB and then inserting dependant records as well.
But what would be snazzy would be to get all the data into a
SQLAdapter, with structure in place, disconnect from the original DB,
make mods as nessecary, then connect up to the destination DB and do a
one-method insert/update to the destination. Can this be done?
from dependant tables into a SQLAdapter. I will then need to make
some changes to certain field data. I will then need to insert these
records into another database (with same structures). Can some one
sling me some example code as how they would do this? The rudimentary
way would be to loop through each record, inserting into the
destination DB and then inserting dependant records as well.
But what would be snazzy would be to get all the data into a
SQLAdapter, with structure in place, disconnect from the original DB,
make mods as nessecary, then connect up to the destination DB and do a
one-method insert/update to the destination. Can this be done?