DateFormat Problems [message #573425] |
Fri, 28 December 2012 06:06 |
|
Lasera
Messages: 2 Registered: December 2012 Location: Turkey
|
Junior Member |
|
|
This is my first topic
##Forms6i & 10g XE Windows7 32 bit##
Dear All,
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
begin
declare
a char;
mshow number;
begin
select to_char(:tarih1,'D') into a from dual;
:gun_ne:=a;
message(a,no_acknowledge);
if (:gorevatama.a between 1 and 5 )
then
mshow := show_alert('HICI');
elsif (:gorevatama.a in (6,7))
then
mshow := show_alert('HSONU');
end if;
end;
end;
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.
query is:
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.
|
|
|