Home » Developer & Programmer » Forms » forms 6i (windows xp)
forms 6i [message #586902] Tue, 11 June 2013 10:23 Go to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
how to insert or update a number which is having value like 08,09 in forms 6i
while insert its inserting only 8 and 9 not 08 or 09 the first digit zero is not inserting
i want to use time file which is 24 hrs format, so i am giving value like 0835 (08:35) but 835 only saving.

Report message to a moderator

Re: forms 6i [message #586904 is a reply to message #586902] Tue, 11 June 2013 10:31 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
Numbers do not have leading zeros.
If you really want to store a leading zero you need to use a character datatype.
If you're storing times why don't you use the correct datatype - date.

Report message to a moderator

Re: forms 6i [message #587200 is a reply to message #586904] Thu, 13 June 2013 03:45 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
ya i am using character data type but same like before the leading zero is not saving.

Report message to a moderator

Re: forms 6i [message #587201 is a reply to message #587200] Thu, 13 June 2013 03:53 Go to previous message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
The datatype of the form item and the database column both need to varchar.

Report message to a moderator

Previous Topic: Giving label to push button in form 6i
Next Topic: FRM-30047
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 05:14:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.