OraFAQ Forum: Forms » Unable to read list of values...

Home » Developer & Programmer » Forms » Unable to read list of values...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to read list of values... [message #488314]

Thu, 06 January 2011 05:45

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

I read article about this error...but still i cant solv it..

so i send it my form...

I hope somebody will help me to solve my form problem...

Thanks in advance...

Attachment: MODULE7.fmb
(Size: 48.00KB, Downloaded 1000 times)

Report message to a moderator

Re: Unable to read list of values... [message #488315 is a reply to message #488314]

Thu, 06 January 2011 05:48

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Never use select * (Ever, for any purpose in production code). That's just asking for problems. Change it to query the columns you want specifically.

Report message to a moderator

Re: Unable to read list of values... [message #488316 is a reply to message #488315]

Thu, 06 January 2011 05:54

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

thanks you..

But sir, nw i change my lov query like this
select empno from emp;

But i want to populate below query result instead of above query result

populate_group_with_query('RG_EMPLOYEE','SELECT EMPNO,ENAME,SAL FROM FAS.EMP');

but my lov show result of tht query : select empno from emp;

Report message to a moderator

Re: Unable to read list of values... [message #488317 is a reply to message #488316]

Thu, 06 January 2011 06:00

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

The LOV has one column. You're trying to change it to a query with two columns. That's never going to work.
If you want to the change an LOV at runtime then you must keep the number and type of columns selected the same.

Report message to a moderator

Re: Unable to read list of values... [message #488319 is a reply to message #488317]

Thu, 06 January 2011 06:10

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Thanks you sir..
Now my concept become clear ...
but sir, i want to ask another one if i want to populate lov programmatically...then how to i create it.
But at same time i didnot create any lov on design time.

i write code like this

declare
rg_id RecordGroup;
errcode NUMBER;

begin
rg_id := create_group_from_query('RG_EMP','SELECT EMPNO,ENAME FROM EMP');

errcode := POPULATE_GROUP('rg_id');

end;

but my lov not pop up;;
my question is to pop up lov , should it necessary to create lov at design-time....or if not then how to create lov without using design time..

Report message to a moderator

Re: Unable to read list of values... [message #488320 is a reply to message #488319]

Thu, 06 January 2011 06:18

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Of course you need to create an LOV at design time. An LOV is not a record group.
LOV's have a graphical interface, they have column lists, they have return values set, prompts etc...
How do you expect to define all that with your sample code above?

And if you want to change the query at run time I'd create multiple record groups at desing time and just change the one the LOV is using programmatically.

Report message to a moderator

Re: Unable to read list of values... [message #488322 is a reply to message #488320]

Thu, 06 January 2011 06:38

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Thanks a lot..

Report message to a moderator

Previous Topic:	auto-complete combo box using webutil
Next Topic:	search

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:15:26 CDT 2024