Oracle Forms

Hi,

Please guide for the following

I have a detail block, containing various columns like dmonth, dyear, locationid, itemcategoryid etc. I want to filter out only those records which match four parameters. I wrote like this( mentioned below) but it is not giving the correct result.

GO_BLOCK('dep_vw');
set_block_property('dep_vw',default_where,'locationid ='||''''||:cb1.locid||''''||' and
trim(dmonth)='||''''||:cb1.monthh||''''||' and dyear='||''''||:cb1.yearr||''''||'and itemcategoryid='||''''||:cb1.catgry_id||'''' );

Control Block (cb1) has parameter variables.

Any solution please.

Regards.