Home » SQL & PL/SQL » SQL & PL/SQL » Why won't my date stay when I create a new record
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?
Previous Topic: schema
Next Topic: regd database
Goto Forum:
  


Current Time: Fri Apr 26 07:48:50 CDT 2024