本文介绍了一种多表更新服务的实现方法，通过示例代码展示了如何注册不同的表及其主键列进行批量更新操作。涉及customer、sales_order及sales_order_items三张表。
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()
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
