Re: forms 5 - LOV & WHERE condition
Date: Fri, 16 Jul 1999 15:13:29 +1000
Message-ID: <7mmfed$c8913_at_atbhp.corpmel.bhp.com.au>
Inbar,
Regarding the where clause, you can preserve the single quotes inside your
text by adding a second single quote after each existing single quote, eg.
'and TO_CHAR(disc_end,''DD-MM-YYYY'') = TO_CHAR(v_disc_end,''DD-MM-YYYY'')';
These are two single quotes, not double quotes.
inbar_at_my-deja.com wrote in message <7mfifu$k38$1_at_nnrp1.deja.com>...
>LOV -
>How Can I Force The Cursor ( When User Open Lov)
>To Stand In Search Field And Not On First Record ?
>
>WHERE Condition -
>In Pre-Query Trigger , I Have Variable , v_where VARCHAR2.
>I Would Like To Put This
> 'and TO_CHAR(disc_end,'DD-MM-YYYY') = TO_CHAR(v_disc_end,'DD-MM-YYYY')';
>
>
>Thanks
>Inbar
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 07:13:29 CEST