In the past when I used the contents of a DDDW as a criteria for dynamically
re-retrieving the contents of another DDDW, I have faced similar problems
before. I noticed that the dependent DDDWs invariably for some unknown
reasons, get nullified and become equal to null! Where they become null, I
just put in code to do a getchild etc all over again, and re-retrieve the
data based on the new retrieval argument, and that helped. I know this
problem is slightly different from yours, but I thought I would share a
similar experience with you.
May be just try this and hope that helps you too.
>From: rizwan hussain <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: PFCSIG DDDW filter
>Date: Sat, 12 Jun 1999 20:51:05 PDT
>
>Hi all,
>
>
>On a PFC inherited Tab Page, I have a DW which have 3 columns Job Class,
>Pay
>Type and Sub Pay Type (A Job Class has associated Pay Types and a Pay Type
>has associated Sub Pay Types). These columns have associated DDDWs which
>retrieve all the records from the database ( all of them have a Retrieval
>Argument which is the Language Indicator). I am first retrieving the data
>in
>the DDDWs (using pfc_populatedddw event) before retrieving the data in the
>DWControl for an employee. Then I apply the filter on Pay Types and Sub
>Pay
>Type so that only associated values can show up. Also if there are no
>associated values for a column then I am changing its color and also
>protecting it.
>
>
>JOB CLASS Pay Type Sub Pay Type
>========= ======== ============
>Salaried N/A N/A
>Hourly Full Time Regular
> Seasonal
> Part Time Regular
> Auxiliary
>
>N/A means NULL.
>
>
>This works OK when the employees are Hourly but when I select a Salaried
>employee it asks for Retreival Argument(RA) twice. I debug the application
>and find out that it does do the filter OK for Pay Type and in the Child DW
>the Rowcount is 0 which is OK. So it goes for protecting the column and
>then
>I get the RA box. Same thing then happen for Sub Pay Type.
>
>dw_company.GetChild ('pay_type', ldwc_pay_type)
>ldwc_pay_type.SetTransObject(SQLCA)
>ldwc_pay_type.Retreive(1) // 1 is the Languagge Indicator
>ldwc_pay_type.SetFilter("")
>// ls_value contians the job_class in string
>ls_filter = "association_primary_assoc="+ls_value
>li_rtnval = ldwc_pay_type.SetFilter(ls_filter)
>li_rtnval = ldwc_pay_type.Filter()
>ll_rowcnt = ldwc_pay_type.RowCount()
>IF ll_rowcnt > 0 THEN
> dw_aompany.Object.pay_type.Protect = 1
> dw_comapny.Modify("pay_type.Background.Mode='1'")
>ELSE
> dw_aompany.Object.pay_type.Protect = 0
> dw_comapny.Modify("pay_type.Background.Mode='0'")
>END IF
>
>Same thing happens in case of sub_pay_tpe column.
>
>Is there any solution of this problem.
>
>
>Thanks
>
>
>
>Rizwan
>
>
>
>
>
>
>
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>>[EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
>>ADDRESS
>>A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
>>SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
