OraFAQ Forum: Forms » urgent: how to pass datetime type from form to form

Home » Developer & Programmer » Forms » urgent: how to pass datetime type from form to form

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

urgent: how to pass datetime type from form to form [message #82395]

Fri, 23 May 2003 14:08

SA
Messages: 37
Registered: March 2002

Member

Hi,

I need to pass a datetime type data from one form to the other using call_form. I used parameter list, but the parameter only has date type (I'm using 6i, the help says it has datetime type for parameter, but the drop down for parameter data type only has date, char, number to choose). I also tried :global, but it only got date passed. Could someone help me with this? Thank you very much!

Sa

Report message to a moderator

Re: urgent: how to pass datetime type from form to form [message #82396 is a reply to message #82395]

Fri, 23 May 2003 20:27

ash
Messages: 43
Registered: February 2001

Member

Hi, pls try to employ this algo in your code..
to pre-assign a datetime datatype to a global var:

SELECT TO_CHAR(Date_Created,'DD-MON-YYYY HH24:MI:SS')
INTO :Global.MyDate FROM Your_Table;

Report message to a moderator

Previous Topic:	ORA-00600: internal error code, arguments: [12700], [25019], [67115126], [45]
Next Topic:	Everytime i face the same with MDR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 19 05:38:34 CST 2025