table clone/copy

  • Thread starter Thread starter EMW
  • Start date Start date
E

EMW

Is it possible to copy an Oracle database table with a SELECT command or
something else?

I tried reading the data from one table in a dataset, then renaming the
table to the one in the database and then do an UPDATE on it, but it didn't
work.

rg,
Eric
 
If the rowstate of a given row isn't modified/deleted/inserted then it's not
going to update. You could manually walk through the table and add them,
but that would be ugly. The easy way is to set the AcceptChangesDuringFill
property of the adapter to false. By default, it's set to true. When you
fill the new table, if this is set to false, all of the filled rows will be
marked as inserted, so when you call DataAdapter.Update, everything should
work provided your update logic is legit.

HTH,

Bill
 
thanks!

William Ryan eMVP said:
If the rowstate of a given row isn't modified/deleted/inserted then it's not
going to update. You could manually walk through the table and add them,
but that would be ugly. The easy way is to set the AcceptChangesDuringFill
property of the adapter to false. By default, it's set to true. When you
fill the new table, if this is set to false, all of the filled rows will be
marked as inserted, so when you call DataAdapter.Update, everything should
work provided your update logic is legit.

HTH,

Bill
Click to expand...
 
Back
Top