Data type problem

[Former Member]

Hi,

I have created a field with NUMC data type..Becoz when we enter any characters means it willnot accept tht..

When i call this field in the screen it is showing zeros in it..We want to delete this zeros and then only we want to enter our numbers..

How to make these zeros to not to display on the screen when we call this screen..

Otherwise is anyother way tht field only should accept numerics

[Former Member · Accepted solution]

hi mahesh..........

you can give data types like int4 or directly assign a field from a table which does not have numc as the data type but contains only numbers.

---regards,

alex b justin

[Former Member · Accepted solution]

In int4 when we give means (length 10)..It will store with the commas in the database..

For ex : I want to phn num 9986260614

In DB when we use int4 it will store like

998,62,60,614

[Former Member · Accepted solution]

hi mahesh......

that will not be a issue....

or else you need to specify a database field that suits your need.

---regards,

alex b justin

[Former Member]

thanks

[Former Member]

Hi,

It is always better to have character data type for field you mentioned. While saving action, validate that field and then save the data. If entered is not numeric give some message in message log.

Reward point if useful.

Regards,

Karthick S