Formatting Datetime in Forms

[Andreas Doerfler]

Using Oracle Forms 4.5 for Windows, I am trying to use a DateTime Field with
the format mask

DD-MM-YY HH24:MI:SS

which makes a width of 17. However, forms accepts only a field width of 9.
Otherwise, an error

"FRM-30045 Query length of item must be 0 (default) or
greater than actual length"

occurs. Using nothing, 0, or an arbitrarily large number won't work :-(

Has anyone any suggestions how to solve this problem?

---
Andreas Doerfler
Telenet GmbH Kommunikationssysteme Tel. : +49 6151 733345
Marburger Strasse 14 Fax. : +49 6151 733325
D-64289 Darmstadt E-Mail: adoe...@telenet.de

[dmo...@gpu.com]

Change the query length property of the item to 17 or 0. The default is not
set to zero in any of the forms that I have created, so I think the message is
bogus. However the query length must always be greater than or equal to the
item length.

D. Scott Moyer, Jr. dmo...@gpu.com (work)
GPU Service Corporation dsm...@enter.net (home)
Reading, PA

[Vijay Banda]

and...@telenet.de (Andreas Doerfler) wrote:
>Using Oracle Forms 4.5 for Windows, I am trying to use a DateTime Field with
>the format mask
>
> DD-MM-YY HH24:MI:SS
>
>which makes a width of 17. However, forms accepts only a field width of 9.
>Otherwise, an error
>
> "FRM-30045 Query length of item must be 0 (default) or
> greater than actual length"
>

Go the Property called the Query Lenght and make it also 17, this will
solve your problem.

Note :- Always the querylength should be <= maxlength.

Hope this helps!!

Vijay Kumar Banda
Ford Motors..
>

[Chris W.]

n'abend Herr Doerfler

könnte es sein, das vielleicht in der oracle.ini der NLS_DATE_FORMAT -Parameter auf
'DD-MON-YY' steht. Das ergäbe eine maximale Feldlänge von 9 Zeichen.
Auf meiner Forms45 Umgebung (4.5.6.3.3) fand sich diese Problem nicht.

bitte mailen Sie mir zurück, falls sich etwas disegezüglich ergeben sollte, da
es mich interessieren würde.

C. Wittlich (freiberuflicher Oracle-Entwickler)