Contributed by Sharon Buntz
In pfc_n_cst_dwsrv_multitable's of_update() function [Format 3]:
[line 128]// Modify the datawindow object.
// Temporarily add a MessageBox here to show ls_mod_string MessageBox ( "Temporary Debug Message", ls_mod_string )
IF idw_Requestor.Modify ( ls_mod_string ) <> "" THEN Return -2
In your constructor event for your MultiTable DataWindow control:
string ls_table string ls_keycols
// Register the update characteristics for the Staff Demographics table ls_table = "pf_staff_demo" ls_keycols = "pf_staff_demo_staff_id" this.inv_MultiTable.of_AddToUpdate(ls_table,ls_keycols)
// Register the update characteristics for Staff Experience table ls_table = "pf_staff_experi" ls_keycols = "pf_staff_experi_staff_id" this.inv_MultiTable.of_AddToUpdate(ls_table,ls_keycols)
Note that the table owner is disregarded in the logic in the PFC's Multitable update code. Therefore, your problem could be that the of_Update( ) function never finds any matches for columns for each table name. If this is the case, then you will need to make sure that each user is defined as a member of the group for which the table's owner is specified. Ask your DBA for assistance on setting up groups for your users.
Note that the Filter window handles the table owner differently. In the Filter window, the table owner is fetched from the PBODB050.INI file and then appended to the file name.
Contributed by PFCGuide staff, except
where noted otherwise.
PFCGuide is sponsored by Dynamic Technology Group
The information provided is for advice only and not to be considered a contract or a liability against Dynamic Technology Group.
Last revised: February 15, 2004 03:58 AM.