Why won't my date stay when I create a new record [message #1452] |
Wed, 01 May 2002 10:48 |
New To Oracle-PL/SQL
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
Okay I have a product entry form im creating that automatically produces the system date for when that product gets enetered. I used a preform trigger with the following formula
select sysdate into :date_enetered from dual;
Now the problem I'm having is I created a new button to Add product entry that which im hopingwill append a new entry. When the button gets checked the date disapears? Why would the date disapear...shouldn't it just re-run the form as if I was adding a new record?
This oen baffles me a bit?
|
|
|