Community
Showing results for 
Search instead for 
Do you mean 
Reply

Numeric field with Variable Length

Tuned Listener
Posts: 5
Country: USA

Numeric field with Variable Length

[ Edited ]
Hi All,
 
After a recent upgrade to version 10.0.2, some fields in our database are causing a mask error - "The value doesn't match the data entry mask ################." It was working before so the update some how is the reason this error is being caused.
 
The field is an all numeric field like Account Number, but can be of variable length. It is currently setup with Charater data type and a field format of "################" which allows for digits only but also restricts the length of the field. I tried to use Number as the datatype but that results in commas (,) in the field (like 111,111,111 instead of 111111111). Is there a way to allow the user to type any number of digits (of course with a max length limit) in a particular field?
 
Any help will be appreciated!
 
Thanks,
Sudha


Message Edited by sjoga on 04-11-2008 11:04 AM
Tuned Listener
Posts: 5
Country: USA

Re: Numeric field with Variable Length

I wasn't able to find any way of doing this. I am guessing that there isn't a way to do it since no one replied.

 

Thanks!

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Numeric field with Variable Length

Have you made sure the number of characters defined for the field is the same as the length of the mask?