| prob in record group poplist select [message #79030] |
Mon, 15 April 2002 22:18  |
annu
Messages: 34
Registered: February 2002
|
Member |
|
|
hello Dear experts.
I have a problem in making record group poplist select.. .which is just like ..
rg_id2 :=create_group_from_query ( rg_name2,'select a.item_name||b.book_no||b.qlty_no,b.item_code into :packinglist_master.item_code from item_master a, contract_detail b WHERE B.ITEM_CODE=A.ITEM_CODE');
it gives me reslt but all are concatinated and un easy to understand ...
my first requrment is i want to use any Separator in b/w these concatinating fields like '-','|' .. i do lot of tries but i cant get any Solution. Because all the select is already packed in quoted signs and submitt as a string .. so i think there is i make a mistake ... tell me how to do this ...
and my second question is just u see that i want to insert b.item_code into :packinglist_master.item_code as same i want that b.book_no||b.qlty_no also insert some other form feild is it possiable ...
Can Sombody help me out of this prob ... that would be highly appreciatable
Annu
|
|
|
|
| Re: prob in record group poplist select [message #79034 is a reply to message #79030] |
Tue, 16 April 2002 09:18  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
First answer is that between concatination operator's you just have to add an extra quote because your already in quotes...
rg_id2 :=create_group_from_query ( rg_name2,'select a.item_name||'',''||b.book_no||'',''||b.qlty_no,b.item_code into :packinglist_master.item_code from item_master a, contract_detail b WHERE B.ITEM_CODE=A.ITEM_CODE');
Unfortunately, I don't really understand what your trying to do in the second question.
T
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
