Home » Developer & Programmer » Forms » Is This A FORMS BUG???
Is This A FORMS BUG??? [message #79284] Tue, 21 May 2002 14:30 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Hello All,

My problem is that I have 4 max two digit text boxes on a form. These four boxes are...
month, date, year, year(century)
12 12 20 02

These boxes are database items and when entering a new century, ie. 02 and then clicking save (commit_form) the century box turn from 02 to just 2. I have not coded for this, so why is it doing it? Does it have something to do with the Y2K bug?

Thanx
T
Re: Is This A FORMS BUG??? [message #79285 is a reply to message #79284] Tue, 21 May 2002 21:45 Go to previous messageGo to next message
Remash
Messages: 52
Registered: November 2000
Member
It's not a bug in the form. Its because the data type of the text field is numeric. Make it Char.
Re: Is This A FORMS BUG??? [message #79297 is a reply to message #79285] Wed, 22 May 2002 08:18 Go to previous messageGo to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Ok, I made the text field char and when you click save now to add the new date, it seems to not change it from 02 to just 2.
But then when you leave the form and then come back in to edit it after, it's 2, not 02. Thus it's showing it as 02 just when you save it now, but it's actually saving it in the db as 2 (I don't change the datatype in the actual db do I, just the form text field right?)

Thanx
T
Please disregard last post [message #79298 is a reply to message #79285] Wed, 22 May 2002 09:29 Go to previous message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Please disregard last post, it's been figured out.

Thanx much,

T
Previous Topic: PL/SQL question - HELP!!!
Next Topic: Re: free material for oracle8i
Goto Forum:
  


Current Time: Fri Mar 29 08:03:37 CDT 2024