Home » Developer & Programmer » Forms » Calendar Problem in Forms
Calendar Problem in Forms [message #165052] Tue, 28 March 2006 03:27 Go to next message
boseinfo
Messages: 22
Registered: December 2005
Location: Bahrain
Junior Member
Hi

I have attached the calendar object provided by Oracle (i.e, Calendar.pll etc from Oracle Forms Demo) to my EMP form at HIREDATE field.

When I call calendar form using F9 and click on OK button I am getting today's date correctly (i.e, 28-Feb-2006) but when I select other date (Say 14-Mar-2006) I am getting 14-Mar-0006 instead of 14-Mar-2006.

Could anybody please help to resolve this.

Rgds
Bose

Report message to a moderator

Re: Calendar Problem in Forms [message #165216 is a reply to message #165052] Tue, 28 March 2006 23:36 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Is '14-Mar-0006' appearing on the screen or in your database? Check that your fields are long enough to handle both the formatted and unformatted data strings.

David

Report message to a moderator

Re: Calendar Problem in Forms [message #165429 is a reply to message #165216] Thu, 30 March 2006 02:18 Go to previous messageGo to next message
boseinfo
Messages: 22
Registered: December 2005
Location: Bahrain
Junior Member
Halo David,

It appears in Database too.

When I change the Format Mask of HIREDATE field to DD-Mon-YY then the date stored correctly(i.e, 14-Mar-2006 only).

If I change Format Mask as DD-Mon-YYYY then it is getting sored as 14-Mar-0006.

IF I dont give any Format Mask then also it is getting stored as 14-Mar-0006 only.

I am litrally confused what is happening.

Please find the attached .rdf I have developed.

It is based on EMP table of SCOTT Schema.

Regds
Bose
  • Attachment: EMP.fmb
    (Size: 128.00KB, Downloaded 1077 times)

Report message to a moderator

Re: Calendar Problem in Forms [message #165564 is a reply to message #165429] Thu, 30 March 2006 23:08 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Quote:

When I change the Format Mask of HIREDATE field to DD-Mon-YY then the date stored correctly(i.e, 14-Mar-2006 only).
Where are you 'seeing' the value '14-Mar-2006'? If the field format is DD-Mon-YY then that is what the field will show you.

Again, how long is your field!!

David

Report message to a moderator

Re: Calendar Problem in Forms [message #165751 is a reply to message #165564] Sat, 01 April 2006 04:50 Go to previous messageGo to next message
boseinfo
Messages: 22
Registered: December 2005
Location: Bahrain
Junior Member
Hi David

I've seen that value in Database.

I mean 'Stored' means value stored in Database.

Detail Explnation for what you have asked
Format Mask is DD-Mon-YY on HIREDATE Field. When I select date from calendar the date appears on HIREDATE Field is 14-Mar-06 and stored in database as 14-Mar-2006.

HIREDATE Field length is 11.

Rgds
Bose

Report message to a moderator

Re: Calendar Problem in Forms [message #165856 is a reply to message #165751] Mon, 03 April 2006 02:19 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
When I say that I 'see a value in the database' it means I am looking at the 7-byte hexadecimal value in the raw database file. Again, how are you 'seeing' the data? Are you using SQL*PLus, or TOAD, or Oracle SQL Developer, or Access?

I believe that you have a NLS_DATE_FORMAT issue. this means that you will need to determine the NLS_LANG and NLS_LANGUAGE settings as well as NLS_DATE_FORMAT.

Are you running your form through a Developer Server or an Application Server? If DS then check the NLS_DATE_FORMAT in your registry and forms_web.cfg file. If AS then check its settings. If you are looking through SQL*Plus then check the databases NLS values.

David

[Updated on: Wed, 05 April 2006 01:59]

Report message to a moderator

Re: Calendar Problem in Forms [message #166164 is a reply to message #165856] Tue, 04 April 2006 23:17 Go to previous message
ahmad_uaf
Messages: 68
Registered: March 2006
Location: Pakistan
Member
Check this Form,
It's Ok.
Regards,
Ahmad

Report message to a moderator

Previous Topic: listbox
Next Topic: Intergrating Oracle Forms and Reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:41:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.