多表更新

 

string ls_tablename
string ls_keycols[]

of_SetTransObject(sqlca)

// Start the Multi-Table Update Service.
of_SetMultiTable(true)

// Register the "customer" table and its key columns.
ls_tablename = "customer"
ls_keycols[1] = "customer_id"
inv_multitable.of_AddToUpdate(ls_tablename, ls_keycols)

// Register the "sales_order" table and its key columns.
ls_tablename = "sales_order"
ls_keycols[1] = "sales_order_id"
inv_multitable.of_AddToUpdate(ls_tablename, ls_keycols)

// Register the "sales_order_items" table and its key columns.
ls_tablename = "sales_order_items"
ls_keycols[1] = "sales_order_items_id"
ls_keycols[2] = "sales_order_items_line_id"
inv_multitable.of_AddToUpdate(ls_tablename, ls_keycols)

of_Retrieve()