| DateFormat Problems [message #573425]
||Fri, 28 December 2012 06:06
Registered: December 2012
This is my first topic |
##Forms6i & 10g XE Windows7 32 bit##
I've 2 blocks.
1. block - 2 textbox Branch and foundation
and there are two date textbox.
2.block - gorevid,perid. we choose the employee and the duty fom lov.
In first block, if the first date is on weekend or not, i raise the warning below
select to_char(:tarih1,'D') into a from dual;
if (:gorevatama.a between 1 and 5 )
mshow := show_alert('HICI');
elsif (:gorevatama.a in (6,7))
mshow := show_alert('HSONU');
In second block trouble begins.When i choose the employee from the LOV, i want to do something like this in post change trigger
If 1. block 1. date is on weekend,
And if there are other tasks assigned (more then 3 tasks) to choosen employee we must raise warn and stop records
"there are 3 tasks assigned to this employee, you cant assign one more...."
Problem1. In my table, i've date column and insert data as 28.12.2012 16:00.
But when i select from db, query returns 0.
select to_char(:date1,'D') into a from dual;
if i delete the time and insert as 28.12.2012, there is no problem. But time is more important for me.Because i cant assign a task to the employee in the same time and in 4 hours.
i can assign 3 tasks to the employees in the same day.
Now please help ASAP,
how can i handle this.