Datatype

[Former Member]

Hi experts,

i have a address col, in that i have PIN, what datatype i need to take in order to avoid

that following : ex:405,001, and 502,006 in place of 405001 and 502006

and same as for mobile no: field its stores : 98,145,612,58 in place of 9814561258

thank you ,,

any help on this issue

-

---

vijai

[Former Member]

Hi Vijay

If your PINCODE's datatype is an Integer then do the following

1) Go to <b>DICTIONARIES -->LOCAL DICTIONARY -->SIMPLE TYPES</b>->

2)Select the <i>Pincode</i> datatype

3) Goto <b>REPRESENTATION</b> tab

4)*In <b>EXTERNAL REPRESENTATION -->FORMAT</b> , Specify '<b>0</b>' (<u>ZERO</u>)

this will solve your problem

a) Before doing this the result will be like this <i>405,001</i> and <i>98,145,612,58</i>

b) After making the above changes output will be <i><u>405001</u></i> and <i><u>9814561258</u></i>

Regards

Chaitanya.A

[Former Member]

Hi,

Look at the NumberFormat Class

<a href="http://java.sun.com/j2se/1.4.2/docs/api/java/text/NumberFormat.html">Class NumberFormat</a>

Aviad

[Former Member]

Hi,

Make the DataType as String.

-np

[Former Member]

Hi,

Make the datatype string and assign a format (according to the string format pattren) - if I remember correctly it is ######.

Aviad