John,
I apply your solution and it works perfect. So much thanks.
Rizwan
>From: John Huang <[EMAIL PROTECTED]>
>To: 'rizwan hussain' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: RE: PFCSIG DDDW filter
>Date: Tue, 15 Jun 1999 10:35:24 -0400
>
>Rizwan,
>
>Try putting this in your ELSE statement:
>
>ELSE
> ldwc_pay_type.InsertRow(0)
>
>You need to insert a blank row to "fool" the dddw from
>prompting you for the retrieval argument the second time
>if and when no rows is retrieved by your child datawindow
>when you initially retrieved the child datawindow.
>
>HTH,
>John
>
>-----Original Message-----
>From: rizwan hussain [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, June 12, 1999 11:51 PM
>To: [EMAIL PROTECTED]
>Subject: PFCSIG DDDW filter
>
>
>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 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]
