Home » Developer & Programmer » Forms » DateFormat Problems (Forms 6i & Windows 7 32 bit)
icon4.gif  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 Smile


##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.
Previous Topic: Function Keys
Next Topic: icon in unix forms 6i [merged 2 by jd]
Goto Forum:
  


Current Time: Tue Sep 30 06:51:29 CDT 2014

Total time taken to generate the page: 0.17909 seconds