Valid settings for the Initial Value property

In an Order Entry form, the Order_Items block has a text item called Shipping_Date, which is of the Date data type The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item.
Assuming that all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three)
A. $$DBDATE$$
B. :Orders.Order_date+3
C. SYSDATE
D. :GLOBAL.SHIP_DATE
E. :PARAMETER:SHIP_DATE
F. ORDER_ITEMS_SEQ

amazingrajiv
Profile Answers by amazingrajiv Questions by amazingrajiv
May 31st, 2011
1
12929

Questions by amazingrajiv

Oracle Forms 4.0

Answer

Showing Answers 1 - 1 of 1 Answers

dornalpr
Profile Answers by dornalpr

Jun 2nd, 2011

Valid values are: A, B & D

In forms, to give initial value as sysdate, we should user $$DBDATE$$ which gives the current time of server, which stores date of DD-MON-YYYY format. If you want to store, you should use $$DBDATETIME$$ which stores upto DD-MON-YYYY HH:MI:SS format.
$$DBTIME$$ which stores only HH:MI:SS format.

If you want to give local system time i.e. operating system time..then use $$DATE$$, $$DATETIME$$, $$TIME$$.

You cannot use SYSDATE as initial value in property for date type.
Parameter can be given but syntax is not correct. it should be :parameter.date

last option - sequence id cannot be used as many reasons ex. datatype mismatch