Multitable Update DataWindow Service FAQ

Table of Contents

I don't get any error message, but none of my tables are getting updated.

Contributed by Sharon Buntz

1. Try adding a simple MessageBox in the PFC function that strings together the big modify statement to see what is happening behind the scenes.

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

2. Double-check the spelling of your table name and your key columns.

• The table name should not include any owner name.
• The key column names must match exactly how they are seen when you select menuoption "Rows/Column Specifications" in your DataWindow painter for that particular DataWindow object. Also, try checking the return code from your of_AddToUpdate( ) function [returns 1 if the function succeeds and -1 if an error occurs].

In your constructor event for your MultiTable DataWindow control:

string ls_table
string ls_keycols[]

this.of_SetMultiTable (TRUE)

// Register the update characteristics for the Staff Demographics table
ls_table = "pf_staff_demo"
ls_keycols[1] = "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[1] = "pf_staff_experi_staff_id"
this.inv_MultiTable.of_AddToUpdate(ls_table,ls_keycols)

3. If you notice from your MessageBox results that none of your columns are being set to .Update=Yes...

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.