OraFAQ Forum: Forms » date problem

Home » Developer & Programmer » Forms » date problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

date problem [message #199099]

Fri, 20 October 2006 02:49

arcangulac
Messages: 16
Registered: October 2006
Location: izmir

Junior Member

i have database item that is date format and format mask hh24:mi
i want to sysdate on in when the new form instance i wrote this select sysdate from dual ;
but item shows 00:00 can anoybody help me

Report message to a moderator

Re: date problem [message #199207 is a reply to message #199099]

Sat, 21 October 2006 04:36

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Hi,
Change the Data Type of your database column to Datetime instead of Date in forms. It should work this way.

regards,
Saadat Ahmad

Report message to a moderator

Re: date problem [message #199249 is a reply to message #199099]

Sun, 22 October 2006 20:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Put the code into the When-New-Form-Instance trigger. Please read the 'Pre-Form' entry in the documentation for reasons why you shouldn't do this type of operation in that trigger.

David

Report message to a moderator

Re: date problem [message #199270 is a reply to message #199249]

Mon, 23 October 2006 01:23

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

But he did put it there Smile

(OK, he didn't spell exact trigger name, but that's how I understood it).

in when the new form instance

Report message to a moderator

Re: date problem [message #199369 is a reply to message #199270]

Mon, 23 October 2006 18:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Oops, oopsie oops, mega-oops! I think I put the answer into the wrong thread!! Buggar, now I will have to find the one that I thought I was answering.

David

Report message to a moderator

Re: date problem [message #199417 is a reply to message #199369]

Tue, 24 October 2006 03:10

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Report message to a moderator

Re: date problem [message #199505 is a reply to message #199099]

Tue, 24 October 2006 18:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I think you had better post the code that you have in your WNFI trigger. By the way, have you defined a 'default value' for this field in its property sheet?

David

Report message to a moderator

Re: date problem [message #199760 is a reply to message #199207]

Thu, 26 October 2006 02:32

arcangulac
Messages: 16
Registered: October 2006
Location: izmir

Junior Member

ş�kran saadahmet it works (datetime)

Report message to a moderator

Previous Topic:	FRM-11009 failed to load the color palette file
Next Topic:	report send direct to printer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:39:18 CDT 2024