SMARTFORMS

[Former Member]

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?

[Former Member · Accepted solution]

remove address window and

write your own select query from adrc table and print the fields according to your client requirment.

[Former Member]

help full

[Former Member]

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&

[Former Member]

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.

[former_member585060]

Interchange the lines in POSTCODE and CITY in ADDRESS and ENDADDRESS.

make it as

/:ADDRESS

.

.

/:CITY&xxxxxx-xxxxx&

/:POSTCODE&xxxxx-xxxxx&

'

;

/:ENDADDRESS

[Former Member]

this is not a script. here we have to give address number. smartform will pick automatically from adrc table