on 09-12-2008 8:59 AM
THIS IS REGARDING ADDRESS
in address field if i gave address no i am getting city and postal code as eg: 67868-mumbai
which is not accepting by client . they want it as mumbai-6786786.
actually this address is getting from adrc table when we gave address number.
how to resolve this?
remove address window and
write your own select query from adrc table and print the fields according to your client requirment.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
help full
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
here is the sample code-
data: zcity like adrc-city1,
zpcode like adrc-post_code1.
select single city1 post_code1 from adrc
into (zcity,zpcode)
where addrnumber = "your address no".
create text element in that window-
write - address-
&zcity& , &zpcode&
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
data:v_address(50) type c.
we have retrieve city and postal code from ADRC table and concatenate as per client requirement.
CONCATENATE city '-' postalcode INTO v_address.
give v_address in text editor smart form as a &v_address&
Regards,
Bhupal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Interchange the lines in POSTCODE and CITY in ADDRESS and ENDADDRESS.
make it as
/:ADDRESS
.
.
/:CITY&xxxxxx-xxxxx&
/:POSTCODE&xxxxx-xxxxx&
'
;
/:ENDADDRESS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.