Solved

Validating Social Security Number

Posted on 2002-05-23
3
552 Views
Last Modified: 2013-12-26
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
Comment
Question by:jasonboetcher
3 Comments
 
LVL 4

Expert Comment

by:Bhatti
ID: 7031392
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
 

Expert Comment

by:sunpatil
ID: 7086554
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
 
LVL 1

Accepted Solution

by:
levr earned 50 total points
ID: 7094010
Hi,
put in Validation Expression
   isNumber(GetText())
it will catch the situation with spaces.

Lev
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now