Page 1 of 1

System date automatically come in date column

Posted: Tue Dec 23, 2008 8:23 am
by shahzaibismail
Hellow
Experts

I Create a table which relate 3 column Date,Emp no and name

Now when i enter record in form why always enter date in form

i need system date automatically come in date column


Thanks

Shahzaib Ismail

Posted: Tue Jan 06, 2009 6:43 am
by haseebkhatri
create trigger When New Record Instance

:DateTextbox:=sysdate;

OR

select sysdate into :DateTextbox from dual;