Hi All, want to restrict user id to a range of 0-9 or A-Z before my form can be saved. In order word the userid can be K111222 of BBR222111 but no spaces or special characters in the userID. I want this to be a function that will return True of False as I will need this test outside the form too.
In pre_insert of the form, i want to call this function
function checkID(userid) return Boolean is
IF usreid not between 0-9 or A-Z -- please provide the logic to use here thanks.
then Return false;
You can use TRANSLATE for this:
So, your IF would be:
if rtrim ( ... etc. ) is not null then