OraFAQ Forum: Forms » How to commit current "database time" through forms 6i .

Home » Developer & Programmer » Forms » How to commit current "database time" through forms 6i .

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

How to commit current "database time" through forms 6i . [message #85631]

Wed, 14 July 2004 20:13

mehbub
Messages: 7
Registered: December 2003

Junior Member

Hello.....

I am trying to get the current "database time" in a forms item (text item or display item) and then to commit the time to the relevent database column. Setting "initial value" property�for the item to $$dbtime$$, does not solve my problem as i need to�commit the time while updating ,�but �"initial value" works while a new record is being inserted. Please help me solving the problem below,

Suppose a table�tab1 , owns a column�A and B;�the column A is of number data type and�B is�of date datatype, and,�one form is created with�text items,�item_A and�Item_B, which�are linked to the column�A and�B of table tab1. Suppose a record is inserted with the value 2 and null for the column�A and�B through the form. Then the record is queried throgh the form. NOw, I like to get the current "database time" in the item item_B and then store the current "data base time" in the data base by commiting the form. I can select the sysdate into the item_B but when it is commited , I find the "time" part of the value is "00:00:00', the current time is not saved !!!! Somebody please help me regarding this , how can i assign the current database time in a forms field and then save the "time value" in the database. Well, database means "Oracle 8i/9i".

Somebody please help me , this is really urgent for me.Many many thanks in advance.

Report message to a moderator