| List of values contains no entries [message #82900] |
Tue, 15 July 2003 14:33  |
Yomar
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
I`m having problems with the following trigger key-listval:
BEGIN
IF :CJME.CJME_TIPO_AUXILIAR_2 >= 100 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CONT_MAESTRO_AUXILIAR_2');
ELSE
IF :CJME.CJME_TIPO_AUXILIAR_2 = 1 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CAJT_CUENTAS_BANCARIAS');
ELSE
IF :CJME.CJME_TIPO_AUXILIAR_2 = 2 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CART_BANCOS');
ELSE
IF :CJME.CJME_TIPO_AUXILIAR_2 = 3 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CART_COMPANIAS');
ELSE
IF :CJME.CJME_TIPO_AUXILIAR_2 = 4 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CART_PROVEEDORES_SERVICIOS');
ELSE
IF :CJME.CJME_TIPO_AUXILIAR_2 = 5 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CART_RAMOS_CONTABLES');
ELSE
IF :CJME.CJME_TIPO_AUXILIAR_2 = 15 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CART_CANALES_DIS');
ELSE
IF :CJME.CJME_TIPO_AUXILIAR_2 = 10 THEN
SET_LOV_PROPERTY('AUXILIAR_2',GROUP_NAME,'CJOS_CJOS_CD_PRO_LOV13');
END IF;
END IF;
END IF;
END IF;
END IF;
END IF;
END IF;
END IF;
LIST_VALUES;
END;
The problem is that when it enters the selection for :CJME.CJME_TIPO_AUXILIAR_2 = 15 in runtime it gives the message "list of values contains no entries" only for this selection.. Can it be a problem with the table? Is there any property for the record group that is missing or erroneous?. The record group has entries when we execute the query. Thanks to everyone for your help...
|
|
|
|
| Re: List of values contains no entries [message #82904 is a reply to message #82900] |
Wed, 16 July 2003 00:41  |
Indrani
Messages: 14
Registered: June 2003
|
Junior Member |
|
|
Hi,
No this is not a prob with ur table,this error is coming as because there is no record in ur table against this selection.So here you will have to handle this exception.
where you are writting this lov property after that write the following:
if error_code = 41830 then
message('NO MORE RECORDS ');
raise form_trigger_failure;
Hope this will help u.Try.
end if;
|
|
|
|
|
|
| Re: List of values contains no entries [message #82918 is a reply to message #82904] |
Thu, 17 July 2003 01:09 |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
hi,
First populate your record group.If it fetches 0 rows then display aalert that no record present.
Declare
n number;
b boolean;
begin
n := populate_group('rg_record_group');--your Record Group Name
if n<>0 then
---NO RECORD PRESENT
else
show_lov('LOV_NAME');
end if;
Sujit
|
|
|
|
| Re: List of values contains no entries [message #82919 is a reply to message #82904] |
Thu, 17 July 2003 01:10 |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
hi,
First populate your record group.If it fetches 0 rows then display aalert that no record present.
Declare
n number;
b boolean;
begin
n := populate_group('rg_record_group');--your Record Group Name
if n<>0 then
---NO RECORD PRESENT
else
b:= show_lov('LOV_NAME');
end if;
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
