Multitable Update using PowerBuilder Datawindow
Published on 03 September 17
Venkatesh Guptha
0
// Data Source - Query
SELECT product.productname,
product.supplierid,
product.unitprice,
supplier.contactname,
supplier.city,
supplier.country,
supplier.companyname,
supplier.contacttitle,
product.id,
supplier.id
FROM product,
supplier
WHERE ( supplier.id = product.supplierid )
-- Datawindow is Tabular with SQL Select Datawindow
-- In Datawindow Constructor Event
this.settransobject(SQLCA)
This.retrieve()
In the Button Clicked event
integer rtn_1,rtn_2
// Here in below code the product table is the first table and the Supplier table is the second table
rtn_1 = dw_3.update(true,false)
IF rtn_1=1 THEN
dw_3.modify('product_productname.update=No')
dw_3.modify('product_unitprice.update=No')
dw_3.modify("product_id.Key=No")
dw_3.modify( "DataWindow.Table.UpdateTable = ~"supplier~"")
dw_3.modify("supplier_city.update=Yes")
dw_3.modify("supplier_country.update=Yes")
dw_3.modify("supplier_companyname.update=Yes")
dw_3.modify("supplier_contacttitle.update=Yes")
dw_3.Modify("supplier_contactname.update=Yes")
dw_3.modify("supplier_id.Key=Yes")
rtn_2 =dw_3.update(true,true)
If rtn_2 = 1 then
dw_3.modify('product_productname.update=Yes')
dw_3.modify('product_unitprice.update=Yes')
dw_3.modify("product_id.Key=Yes")
dw_3.modify("supplier_city.update=No")
dw_3.modify("supplier_country.update=No")
dw_3.modify("supplier_companyname.update=No")
dw_3.modify("supplier_contacttitle.update=No")
dw_3.Modify("supplier_contactname.update=No")
Commit using sqlca;
dw_3.retrieve ()
messagebox ('message', 'updated successfully!')
Else
Rollback using sqlca;
MessageBox("Table2 Update Failed", "Error : "+SQLca.sqlerrtext)
END IF
Else
Rollback using SQLCA;
MessageBox("Table1 Update Failed", "Error : "+SQLca.sqlerrtext)
end if 
This blog is listed under
Development & Implementations
Community
Related Posts:
Post a Comment
