Home » Developer & Programmer » Forms » List item? (Developer 6I, Database 10g window XP)
List item? [message #405022] Tue, 26 May 2009 01:46 Go to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Dear All


I Create a list item which is
DECLARE
  v_rg     NUMBER;
   v_grpid  RECORDGROUP;
BEGIN
  v_grpid := Create_group_from_query('style_no_mas',
'SELECT Style_no_mas, to_char(style_no_mas) style_no_mas FROM style_master ORDER BY 1');
  
  v_rg := Populate_group(v_grpid);
  
  IF v_rg = 0 THEN
    Populate_list('BLOCK314.style_no',v_grpid);
  END IF;
END; 



Its show me style_no_mas in list item


My requirement is i need 4 column information in one list item


For example there is style_no,style_name,qty,amount

when i click list item its show me all 4 column information and when i select one its return style_no


Hope you guys understand


Regards


Shahzaib ISmail
[EDITED by DJM: split one line]

[Updated on: Wed, 03 June 2009 01:54] by Moderator

Report message to a moderator

Re: List item? [message #405080 is a reply to message #405022] Tue, 26 May 2009 04:38 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
List items are not designed to work that way. Use an LOV instead.
Re: List item? [message #405082 is a reply to message #405022] Tue, 26 May 2009 05:11 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Thanks for your reply Cookiemonster


But i don't satisfied with your answer as above picture show that's this is possible but how i don't know please find the attachment and you will know whats my requirement


Any way thanks for your reply


Regards


Shahzaib ismail
  • Attachment: SHAH.bmp
    (Size: 66.09KB, Downloaded 588 times)
Re: List item? [message #405115 is a reply to message #405022] Tue, 26 May 2009 07:17 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then I have no idea.

As far as I'm aware list items can only ever display one column and I can't find anything in form builder that indicates otherwise.

Do you not have access to the fmb you've displayed to check for yourself?

Maybe someone else knows...
Re: List item? [message #405119 is a reply to message #405022] Tue, 26 May 2009 07:22 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
Random thought.

That 3 column list in the screen shot - does it appear when you click on the list item itself or when you click on the List button?
Re: List item? [message #405125 is a reply to message #405022] Tue, 26 May 2009 07:38 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Yes its appare when i click on list item


and when i click list button window appare which show in attachment please find the attachment


Regards


Shahzaib ismail
  • Attachment: SHAH2.jpg
    (Size: 110.93KB, Downloaded 551 times)
Re: List item? [message #405128 is a reply to message #405022] Tue, 26 May 2009 07:51 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then I have no idea I'm afraid.
Re: List item? [message #405133 is a reply to message #405022] Tue, 26 May 2009 08:14 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
Any way Thanks for your reply


Regards


Shahzaib Ismail
Re: List item? [message #406275 is a reply to message #405133] Wed, 03 June 2009 01:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

Have you tried retrieving three or four items in the 'select' statement of your 'create_group_from_query'?

The second example can be done by doing a 'call_form' from within the 'when_button_pressed' trigger.

David
Re: List item? [message #406295 is a reply to message #405022] Wed, 03 June 2009 03:37 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
Senior Member
No my problem is still remain


Regards


Shahzaib
Re: List item? [message #407388 is a reply to message #406295] Wed, 10 June 2009 01:17 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I repeat: "Have you tried retrieving three or four items in the 'select' statement of your 'create_group_from_query'?"

Also try using a four column Form Builder record_group instead of a dynamic one.

David
Previous Topic: sound in form
Next Topic: Hanging Excel processes after using client_ole2
Goto Forum:
  


Current Time: Mon Feb 03 23:51:36 CST 2025