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.