Description Eswar 2010-09-13 02:33:03 EDT

Build Identifier: Version: 3.4.2 Build id: M20090211-1700

Hi. I have focused to create optional parameter .such that if i didn't give the values of the parameters the default query has to run.
here is my query :
select * from APPA.APPA_JOURNAL_VOUCHERS where APPA.APPA_JOURNAL_VOUCHERS.JV_DATE > = ?
and
APPA.APPA_JOURNAL_VOUCHERS.JV_DATE < = ?  
and
APPA.APPA_JOURNAL_VOUCHERS.BRANCH_CODE is NULL 



andd i have used beforeopen script for dataset as :
if(params["branch_code"].value)
{
this.queryText = " select * from APPA.APPA_JOURNAL_VOUCHERS where APPA.APPA_JOURNAL_VOUCHERS.JV_DATE > = ? and APPA.APPA_JOURNAL_VOUCHERS.JV_DATE < = ?   and branch_code = " + params["branch_code"];
}



error i got is :
org.eclipse.birt.report.engine.api.EngineException: Cannot get the result set metadata. SQL statement does not return a ResultSet object. SQL error #1: ORA-00904: "HYD": invalid identifier 


Reproducible: Always