Home » Developer & Programmer » Forms » How to set item value to a default value on form
How to set item value to a default value on form [message #249152] Tue, 03 July 2007 09:14 Go to next message
hitme2u
Messages: 3
Registered: April 2007
Location: Atlanta
Junior Member
Hi,

I need to set the item value to a default value. The current form is defaulting to sysdate

For a release sales order form i want to set the default value for the item "scheduled ship date from" sysdate to sysdate+1. I tried to do this customization using custom.pll but not able to succeed it.

I tried to set the date in this way

SET_ITEM_PROPERTY('RELEASE.FROM_SCHEDULED_SHIP_DATE',INITIAL_VALUE,SYSDATE+1);

I am not able to succed in this way. Can anyone kindly respond me immediately

This is very high priority issue for me.
Re: How to set item value to a default value on form [message #249266 is a reply to message #249152] Tue, 03 July 2007 19:56 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Why not do it this way?
:RELEASE.FROM_SCHEDULED_SHIP_DATE := SYSDATE+1;
Re: How to set item value to a default value on form [message #415096 is a reply to message #249152] Fri, 24 July 2009 14:04 Go to previous message
ezechinedu
Messages: 8
Registered: July 2009
Junior Member
Hi,

Did you get a solution to this problem, can you share the solution
Previous Topic: Execute Query with Non database Block
Next Topic: Is Oracle Forms supported for IE8
Goto Forum:
  


Current Time: Fri Sep 20 09:34:15 CDT 2024