OraFAQ Forum: Forms » Problem in when-new-item-instance when date is called from Calender

Home » Developer & Programmer » Forms » Problem in when-new-item-instance when date is called from Calender

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

Problem in when-new-item-instance when date is called from Calender [message #589883]

Thu, 11 July 2013 11:03

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

i have two block .one is control block in which one field of month.... i have button to called the calender and return the date in the month field...it is ok...date is return but i want when the date is return only the month and year of that field is return in the month field....this one problem... how i can handled it .???

in next block the detail of that item which is sold in the month above selected....so when the month selected in control block then cursor go to next block and execute query and brought those soled item in above mentioned month

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589884 is a reply to message #589883]

Thu, 11 July 2013 11:07

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use to_char on the returned value?

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589885 is a reply to message #589884]

Thu, 11 July 2013 11:11

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

where is to use to_char....i called the calender in button and return the value to month field...
please give me sample...how i can do this...

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589887 is a reply to message #589885]

Thu, 11 July 2013 11:13

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

give the sample code and trigger...

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589893 is a reply to message #589887]

Thu, 11 July 2013 13:10

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

waiting>>

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589895 is a reply to message #589893]

Thu, 11 July 2013 13:34

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Since I don't know exactly how your calendar returns data I can't really give an example.
Do you not know how to use to_char to format a date?

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589900 is a reply to message #589895]

Thu, 11 July 2013 16:52

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

the calender is returned 12/july/2013 formate now the problem is when-new-item-instance is fired before the valued return to text field ......so how i can do it using to-char field...please give sample code

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589901 is a reply to message #589900]

Thu, 11 July 2013 17:06

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

actually i can't do it like select to_char(:txt_feild,'month') into variable from dual
becuase the calender rturned the valued after when-new-item-instance so in :txt_field the value is null then exception is generated???

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589902 is a reply to message #589901]

Thu, 11 July 2013 17:10

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

How, precisely, is the calendar called?

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589903 is a reply to message #589902]

Thu, 11 July 2013 17:21

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

with text-field small button is to called the calender and return the val to txt-field

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589904 is a reply to message #589903]

Thu, 11 July 2013 17:38

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

The exact code.

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589905 is a reply to message #589904]

Thu, 11 July 2013 17:43

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

yes data is called from calender...now which code is you neede....nothing code is used...
code is needed to handled to get the month from date returned to feild that is my requirement..

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589906 is a reply to message #589905]

Thu, 11 July 2013 17:49

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

i need code handeled this problem...when date is return to filed the value in field is month and year of selected field....like when i select 12/jul/2013 from calender it should return to field july-2013....now how i can do this and in which trigger..???

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589907 is a reply to message #589906]

Thu, 11 July 2013 17:52

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Until you tell us how the calender is called we can't answer that.
Form date items do not have calenders as standard - so you did something to the form to make it use one. What, exactly, did you do?

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589909 is a reply to message #589907]

Thu, 11 July 2013 21:00

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

calender is called from the library and used as date_lov.date_choosen(name the field,ok,cancel,....)

Report message to a moderator

Re: Problem in when-new-item-instance when date is called from Calender [message #589929 is a reply to message #589909]

Fri, 12 July 2013 02:31

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

So you use date_lov.date_choosen somewhere.
Which trigger?
What parameters do you pass?

Report message to a moderator

Previous Topic:	Ora -08177 Error
Next Topic:	NEED TO UPDATE PARTICULAR ROW FROM....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 15:12:50 CDT 2024