Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 610
  • Last Modified:

Validating Social Security Number

I'm using Powerbuilder 5.  I found a way to make sure the number is always entered with ###-##-#### using the edit mask.  I also found a way to default the value to 000-00-0000.  Now I need a way to validate the field to make sure it doesn't have spaces.  The #'s make sure it's numeric but it still lets the user enter spaces.  How can I make sure my #'s are numeric within the mask?
0
jasonboetcher
Asked:
jasonboetcher
1 Solution
 
BhattiCommented:
Is it in datawindow control or window control.

If it is a datawindow control then it must be number field and you will get no spaces.
If it is a window control then it will accept only numeric values if you will give in format ###-##-####.


Please let me know where you have this control in datawindow or window.

If in datawindow then must be number field.


Best regards


Bhatti
0
 
sunpatilCommented:
jasonboetcher,

u have to select string in edit mast and then u have to validate the user input by writing script. otherwise i don't think it is possible using number editmask.

regards

sunpatil
0
 
levrCommented:
Hi,
put in Validation Expression
   isNumber(GetText())
it will catch the situation with spaces.

Lev
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now