Home » Developer & Programmer » Forms » List Item Issue (Oracle 10g)
List Item Issue [message #492506] Mon, 31 January 2011 12:54 Go to next message
piyarustagi
Messages: 38
Registered: January 2011
Member
I have a list item and a text item. I want that when a user selects a value from list item... the text item should filter and show values based on it.
How can I do that?

SAMPLE table-
list_item_column text_item_column
---------------- ----------------
     a			1
     a			2
     a			3
     a			4			
     b			5
     b			6
     c			7	
     c 			8

Eg- If user selects A in List item , the test item should show these values -- 1,2,3,4

Report message to a moderator

Re: List Item Issue [message #492508 is a reply to message #492506] Mon, 31 January 2011 13:51 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to base text_item_column's list of values query on list_item_column's value (i.e. in its WHERE clause).

Report message to a moderator

Re: List Item Issue [message #492509 is a reply to message #492506] Mon, 31 January 2011 14:15 Go to previous messageGo to next message
amorphous4u
Messages: 34
Registered: December 2007
Location: Boston, US
Member
Here is the sample how you should write it

SELECT text_item_column FROM 
SAMPLE_TABLE
WHERE list_item_column = 'a';

Report message to a moderator

Re: List Item Issue [message #492634 is a reply to message #492509] Tue, 01 February 2011 09:08 Go to previous messageGo to next message
piyarustagi
Messages: 38
Registered: January 2011
Member
i want to populate a multi line text item using the value selected in list item ... I'm using this code, but there is some mistake in it...List item is :WORK_CATEGORY.JOB_TYPE, text item is :WORK_CATEGORY.WORK_CATEGORY,
Please Help.........................................................................................

DECLARE
CURSOR cr IS
SELECT WORK_CATEGORY
FROM WORK_CATEGORY
WHERE JOB_TYPE = :WORK_CATEGORY.JOB_TYPE;
vcResult VARCHAR2(2000);
BEGIN

FOR rec IN cr
LOOP
IF vcResult IS NULL THEN
vcResult:=rec.WORK_CATEGORY;
ELSE
vcResult:=vcResult||','||rec.WORK_CATEGORY;
END IF;
END LOOP;
:WORK_CATEGORY.WORK_CATEGORY:= vcResult;
END;

Report message to a moderator

Re: List Item Issue [message #492635 is a reply to message #492634] Tue, 01 February 2011 09:17 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
So are you going to tell us what it is doing that you think it shouldn't?
Is it giving an error? wrong data?

Report message to a moderator

Re: List Item Issue [message #492637 is a reply to message #492635] Tue, 01 February 2011 09:23 Go to previous messageGo to next message
piyarustagi
Messages: 38
Registered: January 2011
Member
I've put this code in when-list-changed trigger
It's giving ORA- 06502 error...
I know the problem is in this part vcResult:=vcResult||','||rec.WORK_CATEGORY;
Please tell me any other way to do that.

Report message to a moderator

Re: List Item Issue [message #492639 is a reply to message #492637] Tue, 01 February 2011 09:34 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
That'd imply all your work categories exceed 2000 characters when combined.
How big is :WORK_CATEGORY.WORK_CATEGORY?

Report message to a moderator

Re: List Item Issue [message #492640 is a reply to message #492639] Tue, 01 February 2011 09:37 Go to previous messageGo to next message
piyarustagi
Messages: 38
Registered: January 2011
Member
It's very small...
Is it trying to insert data in first line as...
1,2,3,4,........
(in comma format?)
and rest of the lines are blank.
What I want is that it should put values in different lines in multi line text item

Report message to a moderator

Re: List Item Issue [message #492642 is a reply to message #492640] Tue, 01 February 2011 09:45 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's very small?

Report message to a moderator

Re: List Item Issue [message #492649 is a reply to message #492642] Tue, 01 February 2011 10:38 Go to previous messageGo to next message
piyarustagi
Messages: 38
Registered: January 2011
Member
 

JOB_TYPE	WORK_CATEGORY
CM_COMBO_EandG	COMBO E AND G
ELECTRIC	VAULT
ELECTRIC	CABLE
ELECTRIC	TRANSFORMER
GAS	        GD4
GAS	        GD6
GAS	        INTERFERENCE
GAS	        NEW SERVICES
CM_ELECTRIC	TRANSMISSION
CM_GAS	        TRANSMISSION
GAS	        PUBLIC IMPROVEMENT
ELECTRIC	EMERGENCY
CM_ELECTRIC	CAR
ELECTRIC	CABLE AND CONDUIT
ELECTRIC	CONDUIT
ES_ELECTRIC	CLASS IV
ES_ELECTRIC	CLASS V
ES_ELECTRIC	VAULT
ES_ELECTRIC	CLASS III
TRANSMISSION	TRANSMISSION
CITY_WATER	PLANNED
CITY_SEWER	PLANNED
GAS	        GD1
ELECTRIC	VAULT AND MANHOLE
ELECTRIC	VAULT AND TRANSFORMER
ELECTRIC	WTC
ELECTRIC	TRANSFORMER LOAD RELIEF
ELECTRIC	MAINS AND SERVICE LOAD RELIEF
ELECTRIC	FEEDER LOAD RELIEF
ELECTRIC	BURNOUTS
ELECTRIC	RELIABILITY
ELECTRIC	EAST RIVER REPOWERING
GAS	        GD10
CM_ELECTRIC	ABANDONED STRUCTURES
CM_ELECTRIC	CASTINGS
CM_ELECTRIC	COMBO E AND G
CM_ELECTRIC	TEST PITS
CM_ELECTRIC	STREET LIGHTS
CM_TELECOM	ABANDONED STRUCTURES
CM_TELECOM	CAR
CM_TELECOM	CASTINGS
CM_TELECOM	COMBO E AND G
CM_TELECOM	TEST PITS
CM_STEAM	ABANDONED STRUCTURES
CM_STEAM	CAR
CM_STEAM	CASTINGS
CM_STEAM	COMBO E AND G
CM_TRANSMISSION	ABANDONED STRUCTURES
CM_TRANSMISSION	CAR
CM_TRANSMISSION	CASTINGS
CM_TRANSMISSION	COMBO E AND G
CM_TRANSMISSION	TEST PITS
ELECTRIC	DC ELIMINATION
ES_ELECTRIC	DC ELIMINATION
CM_ELECTRIC	RETAIL SERVICES
ELECTRIC	MANHOLE REGRADE
ELECTRIC	SERVICE BOX REGRADE
ELECTRIC	TRAFFIC LIGHT
ELECTRIC	SERVICE SHUNT
ELECTRIC	MAIN SHUNT
ELECTRIC	STREET LIGHT
CM_ELECTRIC	SECONDARY RELIEF
CM_ELECTRIC	SECONDARY RELIEF W/STRUCTURE
CM_ELECTRIC	FEEDER RELIEF W/STRUCTURE
ELECTRIC	SECONDARY RELIEF
ELECTRIC	SECONDARY RELIEF W/STRUCTURE
ELECTRIC	FEEDER RELIEF W/STRUCTURE
PUBLIC_IMP	HIGHWAY
CM_ELECTRIC	TELEPHONE STAND/KIOSK
CM_ELECTRIC	TEST BORING
CM_ELECTRIC	CABLE PULL
CM_ELECTRIC	SEWER
ELECTRIC	PRIMARY MAIN SHUNT
ELECTRIC	BRIDGE
ELECTRIC	OBSTRUCTION
CM_ELECTRIC	EMERGENCY PRIMARY
CM_ELECTRIC	EMERGENCY SECONDARY
CM_ELECTRIC	EMERGENCY SERVICE
CM_ELECTRIC	EMERGENCY CARBON MONOXIDE
CM_ELECTRIC	EMERGENCY XFRMR ROOF REPLACE
CM_ELECTRIC	FEEDER LOAD RELIEF
CM_ELECTRIC	MAJOR SERVICES
CM_ELECTRIC	OBSTRUCTED SVCS (DIVERSION)
CM_ELECTRIC	OPENMAINCONDUITONLY
CM_ELECTRIC	OPENMAINCONDUIT W/STRUC
CM_ELECTRIC	OPENMAINCONDUIT W/CABLEPULL
CM_ELECTRIC	OPENMAINCONDUIT W/CABLE/STRUC
CM_ELECTRIC	RETAIL SERVICES W/CABLE PULL
CM_ELECTRIC	RETAIL SERVICES W/STRUC
CM_ELECTRIC	RETAILSERVICES W/CABLE/STRUC
CM_ELECTRIC	PLANNED PRIMARY OBSTRUCTIONS
CM_ELECTRIC	SECONDARY REBUILD
CM_ELECTRIC	STRUCTURES
CM_ELECTRIC	TRANSFORMER LOAD RELIEF
PUBLIC_IMP	MILL AND PAVE
PUBLIC_IMP	SEWER PROJECT
PUBLIC_IMP	WATER PROJECT
PUBLIC_IMP	SEWER AND WATER PROJECT
PUBLIC_IMP	TRANSIT AUTHORITY
PUBLIC_IMP	PRIVATE AGENCY
PUBLIC_IMP	BRIDGE PROJECT
PUBLIC_IMP	OTHER

Report message to a moderator

Re: List Item Issue [message #492651 is a reply to message #492639] Tue, 01 February 2011 10:57 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
cookiemonster wrote on Tue, 01 February 2011 15:34

How big is :WORK_CATEGORY.WORK_CATEGORY?

Report message to a moderator

Previous Topic: prevent an item from being copied
Next Topic: Updating table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 16:27:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.