Help....Strange Error...

From: Rashrashetta <rasha_cs_99_at_hotmail.com>
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

Original text of this message