Lov not work [message #602026] |
Thu, 28 November 2013 23:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi,
When i select lov value from one column and select find button, but, it move to next cloumn not displays records to me
Please suggest me
Thank you
|
|
|
Re: Lov not work [message #602027 is a reply to message #602026] |
Fri, 29 November 2013 00:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
List of values is used to display a choice of values so that user could pick one of them. This part works for you, right? Therefore, you select a value: does it end up in an item it is mapped to? I suppose so.
What do you do then? Press <Enter> and focus is set into the next item? If so, that's expected.
If you want to see (query) records whose column's value match the one you picked from the LoV, you first have to enter query mode, select a value from a LoV, and - finally - execute query. Did you do that?
If nothing of the above fixes the issue, please, explain what you do, in details.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Lov not work [message #602058 is a reply to message #602057] |
Fri, 29 November 2013 02:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
ORGANIZATION_CODE is VARCHAR2(3). It means that you'll have to enclose it into single quotes. Try this:
finalStr := ' and Organization Code = '||chr(39)|| :BLOCKNAME.ORGANIZATION_CODE || chr(39);
[Updated on: Fri, 29 November 2013 02:25] Report message to a moderator
|
|
|
Re: Lov not work [message #602059 is a reply to message #602058] |
Fri, 29 November 2013 02:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
calling Organization_Code by it's actual name would help:
finalStr := ' and Organization_Code = :BLOCKNAME.ORGANIZATION_CODE';
|
|
|
Re: Lov not work [message #602100 is a reply to message #602059] |
Fri, 29 November 2013 07:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi Littlefoot and cookiemonster,
I am having 2 database block with having 2 DB Items(ORGANIZATION_CODE,FISCAL_YEAR) and I Created one FORECASTCONTROL non-database block and 2 non-database items(ORGANIZATION_CODE,FISCAL_YEAR) with adding 1 find button and below is the code and where (1) see below in the code , i wrote first begin working fine to me and add another begin -->(2) , not working when after i select FISCAL_YEAR LOV ,it points to the Previous Record in the ORGANIZATION_CODE.
Can we please help me what is the problem and how can i fix this issue?
DECLARE
finalstr VARCHAR2(100);
dfinalstr VARCHAR2(100);
BEGIN
BEGIN -->(1)
IF :FORECASTCONTROL.organization_code IS NOT NULL THEN
Go_block('BLOCKNAME');
dfinalstr := Get_block_property('BLOCKNAME', default_where);
finalstr := 'where ORGANIZATION_CODE = ' ||( ':BLOCKNAME.ORGANIZATION_CODE' );
Set_block_property('BLOCKNAME', default_where, finalstr);
Execute_query();
END IF;
END; -->(1)
BEGIN -->(2)
IF :FORECASTCONTROL.fiscal_year IS NOT NULL THEN
Go_block('BLOCKNAME');
finalstr := 'where FISCAL_YEAR = ' ||( ':BLOCKNAME.FISCAL_YEAR' );
Set_block_property('BLOCKNAME', default_where, finalstr);
Execute_query();
END IF;
END; -->(2)
END;
Thank you
|
|
|
Re: Lov not work [message #602101 is a reply to message #602100] |
Fri, 29 November 2013 07:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
mist598 wrote on Fri, 29 November 2013 13:02not working when after i select FISCAL_YEAR LOV ,it points to the Previous Record in the ORGANIZATION_CODE.
I have no idea what that means
|
|
|
|
Re: Lov not work [message #602103 is a reply to message #602102] |
Fri, 29 November 2013 07:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
That doesn't actually help me understand what this bit means:
Quote:
it points to the Previous Record in the ORGANIZATION_CODE
I'm trying to understand what it's currently doing in order to work out what the problem is, your vague explanation isn't helping.
|
|
|
|
|
Re: Lov not work [message #602156 is a reply to message #602120] |
Sat, 30 November 2013 08:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi littlefoot,
I wrote the below code in the FIND Button for oranization_code and fiscal_year, i create one non-database (FORECASTCONTROL) block and put the 2 items oganisation_code, fiscal_year and those items are also in the DB Block, code is work for me only organisation_code only , when i add same code for the fiscal year , other items are display except organisation_code.Why it is not working? Please suggest...
DECLARE
finalstr VARCHAR2(100);
dfinalstr VARCHAR2(100);
BEGIN
IF :FORECASTCONTROL.organization_code IS NOT NULL THEN
Go_block('BLOCKNAME');
dfinalstr := Get_block_property('BLOCKNAME', default_where);
finalstr := 'where ORGANIZATION_CODE = ' ||( ':FORECASTCONTROL.ORGANIZATION_CODE' );
Set_block_property('BLOCKNAME', default_where, finalstr);
Execute_query();
END IF;
IF :FORECASTCONTROL.fiscal_year IS NOT NULL THEN --->Non-database block.item name
Go_block('BLOCKNAME');
dfinalstr := Get_block_property('BLOCKNAME', default_where);
finalstr := 'where FISCAL_YEAR = ' ||( ':FORECASTCONTROL.ORGANIZATION_CODE' );
Set_block_property('BLOCKNAME', default_where, finalstr);
Execute_query();
END IF;
END;
Thank you
|
|
|
|
|