AlphaNumeric Check

[extempore]

whats the easiest way of finding out if the user entered value for a column is alphanumeric r not? The column should not accept anything other than alphabets or numbers. Can I validate this in the datawindow itself? Please advise.

Thanks

Extempore

 

[zibi]

Yes, you can.
When you edit your dw use menu View->Column specifications.
Place your validiation expresion and message (if you want to do it).
The validiation expresion you can build by your own, please check html help:
User's Guide/Working with Databases/Chapter 16.../Working with validation rules
Regards,
Zbyszek Zibi
--
Zbyszek Ogledzki, email:zbyszek@pangea.com.pl

 

[extempore]

can u send me the link to this example again please. Thanks for answering th question.

Extempore

 

[zibi]

Wow, In my previos post you have exactly patch to help (HTML help!)
Generally, you have to you validiation rule in window "Column specyfication"
As validiation expresion you can use something like this:

Match(GetText( ),"^[0-9A-Za-z]+$&quot

or (if it shout accept null values):

Match(GetText( ),"^[0-9A-Za-z]*$&quot

you can also read about function Match and patterns (also in normal, not html help)
hope this helps,
zibi
Zibi
--
Zbyszek Ogledzki, email:zbyszek@pangea.com.pl