Help....Strange Error...
Date: 17 Jul 2005 01:25:39 -0700
Message-ID: <6c999f04.0507170025.53bbffd_at_posting.google.com>
[Quoted] Hai all...
I am stuck with this piece of code...which I wrote inside a trigger....but it shows error for set_lov_property function...Can anyone help me please?!
*************************Here is the code************************************** declare time_group recordgroup; query_result NUMBER; lovid LOV;
begin
time_group := find_group('appointment.LOV_APPOINTMENT_SPECIFIED_DAY'); lov_id := Find_LOV('LOV_APPOINTMENT_SPECIFIED_DAY');
if :APP_DATE is not null then
time_group := Create_Group_From_Query('time_group','select available_times from apptimes where available_times not in (select to_char(APPDATE,''HH:MI:SS'') from appointment WHERE TRUNC(APPDATE)= :APP_DATE)'); query_result :=populate_group('time_group');
***Set_LOV_Property(lovid, GROUP_NAME ,time_group);
else
Set_Item_Property('CONTROLAPPOINTMENT.APP_DATE',LOV_NAME
,'APPOINTMENT_DAY');
end if;
end;
Thanks,
Rashrashetta
Received on Sun Jul 17 2005 - 10:25:39 CEST