Re: Forms: problem with parameter

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 25 Jul 1999 18:44:11 GMT
Message-ID: <7nfltr$3p4$1@nntp.csufresno.edu>

In article <379A4F1B.588B0D62_at_ieee.org>, Breno de Avellar Gomes <brenogomes_at_ieee.org> wrote:
>I am experiencing some trouble with Developer 2.1
>When calling Reports 3.0 from Forms 5.0, I am passing the following
>parameter
>
> sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN ''' ||
>:DATE_BLOCK.START_PLAN || ''' AND ''' || :DATE_BLOCK.END_PLAN || '''
>ORDER BY CALIBRACAO.PROXIMA';
>
>the field uses date formated as YYYY/MM/DD
>
>The line appears as DD-MM-YY, when year is greater than 1999 results are
>null.

It does not matter how the field is formatted. When you build the where clause, the client's default date format is used unless you specify the format. Try this:

sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN To_date('''

  ||to_char(:DATE_BLOCK.START_PLAN,'YYYYMMDD')
  ||''',''YYYYMMDD'') AND To_date('''
  ||to_char(:DATE_BLOCK.END_PLAN,'YYYYMMDD')
  ||''',''YYYYMMDD'')'
  ||' ORDER BY CALIBRACAO.PROXIMA';

Steve Cosner Received on Sun Jul 25 1999 - 13:44:11 CDT