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]
