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]
