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.
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
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]+$"
or (if it shout accept null values):
Match(GetText( ),"^[0-9A-Za-z]*$"
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.