Re: Forms5 help
From: The Horse's Mouth <mouth_at_primus.com.au>
Date: Fri, 3 Dec 1999 07:47:03 +1100
Message-ID: <hOB14.404$V14.2014_at_nsw.nnrp.telstra.net>
Date: Fri, 3 Dec 1999 07:47:03 +1100
Message-ID: <hOB14.404$V14.2014_at_nsw.nnrp.telstra.net>
The following works but you will need to add some code to handle the situation where or both 'start' 'end' is null (ie NVL)
DECLARE l_query VARCHAR2(1000);
BEGIN l_query := 'hiredate between TO_DATE(' || ''''
|| TO_CHAR(:start_date) || '''' || ')'
|| ' AND TO_DATE(' || ''''
|| TO_CHAR(:end_date) || '''' || ')' ;
SET_BLOCK_PROPERTY('emp',DEFAULT_WHERE,l_query);
END; '''' puts a single quote into the strig - The actual query becomes
hiredate between TO_DATE('01-JUN-1980') AND TO_DATE('31-DEC-1999' Received on Thu Dec 02 1999 - 21:47:03 CET