Complex issues concerning data reproduction ...

yihuagong

Main table one:
boxID is the primary key,
list:
Auto ID, BoxID ..........

Associated child table of the schedule (associated by ID)
Automatic ID, mainID (Save the automatic ID of the above list)


At this time I was copying all the contents of this list according to the boxID, including the schedule and its subtables.
Because the schedule is multiple records, and the records are generated before they are generated.
In this way, only after copying, use the cursor to get the automatic ID of the detail table, and then store the corresponding sub-table records.

Is there any good way to complete the copy?

sinexe

Don't understand what it means

yihuagong

It means that the three tables are related.
such as
An order form (order number)
Two ordered bills of materials (single number associated)

Three pieces of fine code number of a material (associated with the automatic ID of the two tables.)

So I want to copy the entire order form. One table and two tables are easy to handle. Press the old order number to copy to the new order number, but the three tables are troublesome. Because the second table ID is automatically generated.

wgfxman

select * from three tables where ID= (SELECT ID FROM two tables where single number = new/old single number)

yihuagong

Can it be rolled back once it fails?