MultiTable Update

[Vidhi]

Having trouble with multitable updates.
In the constructor of dw (u_dw) have this code
//Begin
//Set Trans Object
This.of_SetTransObject(sqlca)

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

// Register the "client_product" table and its key columns.
ls_tablename = "client_product"
ls_keycols1[1] = "client_product_client_id"
ls_keycols1[2] = "client_product_supplier_id"
ls_keycols1[3] = "client_product_sku"
ll_ret = This.inv_multitable.of_Register(ls_tablename, ls_keycols1)

// Register the "product" table and its key columns.
ls_tablename = "product"
ls_keycols2[1] = "product_sku"
ls_keycols2[2] = "product_supplier_id"
ll_ret = This.inv_multitable.of_Register(ls_tablename, ls_keycols2)

// Register the "product_updates" table and its key columns.
ls_tablename = "product_updates"
ls_keycols3[1] = "product_updates_sku"
ll_ret = This.inv_multitable.of_Register(ls_tablename, ls_keycols3)

//End

On a CB_SAVE, I have the code
//
dw_1.AcceptText()
parent.event pfc_save()
//

When I click the SAVE, it does something without any errors, but when I
retrieve the data, nothing
has changed. I have doubly checked Table/Column Name, the retun values of
of_Register return 1 for all of them. One more thing to note
In my DW SQL, i have table select as
catelog..client_product
catalog..product
catalog..product_updates
Has this got to do anything.

Please help.

[PowerObject!]

Vidhi,

Try specifying the UpdateableColumns (3rd) argument of the of_Register()
function.

---
PowerObject!
-----------------------------------------
http://Groups.Yahoo.com/group/PowerObject
PowerBuilder / PFC Developers' Group