System date automatically come in date column

To discuss Oracle Forms & Reports related technical issues.
Post Reply
shahzaibismail
Posts: 3
Joined: Sat Dec 20, 2008 5:02 am
Location: Pakistan

System date automatically come in date column

Post 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
haseebkhatri
Posts: 18
Joined: Fri Sep 19, 2008 1:11 am
Location: Pakistan

Post by haseebkhatri »

create trigger When New Record Instance

:DateTextbox:=sysdate;

OR

select sysdate into :DateTextbox from dual;
Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests