Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Merge multiple address lines in 1 display field

690743Jun 4 2009 — edited Jun 4 2009
I want to merge the address1+address2+country fields values and display it in 1 text field.
address1 & 2 are varchar2(100). and country is char(15).
user while entering the addresses press enter key on each line of address.
like the following;
SQL> SELECT supl_NAME,supl_address||' '||supl_CNTRY_CODE
  2  FROM SUPPLIER_MASTER
  3  WHERE  supl_CODE = 'S1000';

SUPL_NAME                      SUPL_ADDRESS||''||SUPL_CNTRY_CODE
------------------------------ ---------------------------------------------------------------
SUPLLIER 1                     NVDN KJDK JPO 98029,
                               LFHFE HWIUR WERPI ,
                               KFJOEJI MPR[POEWR[PW
                               JFLEIJRPEUWRP CANADA
i am populating the above result of address+cntry in 1 of my display field (add_disp) on my form.
i want to display the result of address+cntry field values in Max. of 2 lines,
thus eliminating the enter-key line-feed value ( i dont whether chr(13) or so..), that the user entered while inserting.
SUPL_NAME                      SUPL_ADDRESS||''||SUPL_CNTRY_CODE
------------------------------ ---------------------------------------------------------------
SUPLLIER 1                     NVDN KJDK JPO 98029,LFHFE HWIUR WERPI ,KFJOEJI MPR[POEWR[PW
                               JFLEIJRPEUWRP KREKO CANADA
one more thing this display field is a non-db field, so i kept it as display_type item, but display_type field properties does not have Word like wrap stlye. so how could this be accomplished?

kindly suggest.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2009
Added on Jun 4 2009
1 comment
627 views