| List Item Problem [message #399572] |
Thu, 23 April 2009 01:18  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Dear All
I have a form contains two list items and their list style is combo box, they are populating properly at run time but when I execute query they are displaying their codes instead of description.
Please suggest me, what should I do?
Regards,
|
|
|
|
| List Item Problem [message #399579 is a reply to message #399572] |
Thu, 23 April 2009 01:29  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Dear All
I have a form contains two list items and their list style is combo box, they are populating properly at run time but when I execute query they are displaying their codes instead of description.
Code and description both fields' data types are varchar2.
Please suggest me, what should I do to show description in my list item when user execute query.
Regards,
[Updated on: Thu, 23 April 2009 01:36] Report message to a moderator |
|
|
|
|
|
| Re: List Item Problem [message #399598 is a reply to message #399592] |
Thu, 23 April 2009 02:12 |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Thanks for the reply but sorry I couldn't understand so would you please tell me clearyly.
I will be very grateful to you for this kind favor you give me.
Regards,
|
|
|
|
|
|
| Re: List Item Problem [message #399602 is a reply to message #399601] |
Thu, 23 April 2009 02:22 |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
|
Dear, I didn't define any object_group. I am creating GROUP by query at run time and populating my list furthermore as I wrote in my problem it is a LIST_ITEM not a LOV.
|
|
|
|
|
|
|
|
| Re: List Item Problem [message #399623 is a reply to message #399605] |
Thu, 23 April 2009 02:54 |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
sorry, by mistakenly I wrote 'object_group' instead of 'record_group'.
Now, you are saying I have to create a record_group in which I set column width 0 then my problem will resolve.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: List Item Problem [message #399859 is a reply to message #399572] |
Fri, 24 April 2009 05:11 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Why don't you just post create table statements for the tables referenced by the form.
A dump is truly unnecessary - and let's be honest, most company's would be VERY unhappy about a full dump of one of their DB's being posted on the internet.
|
|
|
|
|
|
|
|
|
|
| Re: List Item Problem [message #400293 is a reply to message #399572] |
Mon, 27 April 2009 07:54 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
To clarify what's going on:
You've got a record group called rg_orders that contains the following query:
Select com_code, com_id
From customer_order_mast
Where com_cis_id = :ocm_cis_id
And not exists (select 1 from order_confrm_mast, order_confrm_detl
where ocm_id = ocd_ocm_id And ocm_cis_id = com_cis_id)
Order by 1
You're then using the following code in a when-list-changed on ocm_list_id to populate the list item ocd_com_id:
Declare
rn number;
Begin
rn := populate_group('rg_orders');
populate_list('ocd_com_id','rg_orders');
End;
This should give you a list item that displays com_code and stores com_id.
Is this what is happening?
And if it isn't can you specify in detail what it is displaying and storing.
By the way - it's always good practice in forms to qualify item names with their conresponding block name.
|
|
|
|
| Re: List Item Problem [message #400373 is a reply to message #400293] |
Mon, 27 April 2009 23:24 |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Thanks cookiemonster for the reply.
Dear,
My queries are running successfully and populating list item correctly and also storing data correctly (com_id) but as you know a list item contain a displaying value (for end user) and database value (for storing).
When end user execute form then form should display end user (com_code) instead of stored values (com_id).
My form is simply displaying com_id instead of com_code when user execute records in form.
|
|
|
|
|
|
|
|
|
|
| Re: List Item Problem [message #401948 is a reply to message #401823] |
Thu, 07 May 2009 02:18 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
If you are storing 'com_id' in the table then to see 'com_code' after retrieval you will need to have a non-database item in your record which you display instead of 'com_id' and populate it in the 'Post-query' trigger.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
