Re: Is Forms 5.0 reaaly Y2K compliant?

Breno,

You need to preserve the TO_DATE in the literal, and resolve the TO_CHAR, ie.

sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN TO_DATE(''' ||TO_CHAR(:DATE_BLOCK.START_PLAN,'YYYY-MM-DD') || ''',''YYYY-MM-DD'') AND etc.

Breno de Avellar Gomes wrote in message <379B87AF.87EC5171_at_ieee.org>...
>First I would like to thank those who sent me suggestions (posting
>Forms: problem with parameter)
>
>After several attempts I am suspecting of Oracle Forms 5.0 minor Y2K
>incompatibilities.
>I have a block with two date fields, formatted as YYYY-MM-DD. The
>application is working correctly, except when calling Reports 3.0.
>
>I am passing the following parameter line to Reports:
>
>sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN ''' ||
>:DATE_BLOCK.START_PLAN || ''' AND ''' || :DATE_BLOCK.END_PLAN || '''
>ORDER BY CALIBRACAO.PROXIMA';
>Works fine until 31-DEC-99. Returns 00 for 2000. (where are the other
>two digits, even for 1999?)
>
>
>Trying to convert back and forth
>sql_stat := 'WHERE CALIBRACAO.PROXIMA BETWEEN ''' ||
>TO_DATE(TO_CHAR(:DATE_BLOCK.START_PLAN,'YYYY-MM-DD'),'YYYY-MM-DD') ||
>''' AND ''' ||
>TO_DATE(TO_CHAR(:DATE_BLOCK.END_PLAN,'YYYY-MM-DD'),'YYYY-MM-DD') || '''
>ORDER BY CALIBRACAO.PROXIMA';
>Same result above.
>>
>Please send me suggestions and comments.
>
>Thanks in advance.
>
>Regards,
>
>Breno
Received on Mon Jul 26 1999 - 05:59:09 CEST