Skip to main content

Hi, I need to create syntax check that will allow to enter values consisting of digits and letters only (no sign etc)

Example: A1A1A or 1A1A1 (so it can be mix of digits and letters only without any particular sequence). And no sign allowed like: /, *, _, % etc. 

How should the ENT((X)) in field syntax property look like? 

Best Regards,

Jozef



------------------------------
Jozef Prokopovic
Uniface Community Edition Shared Account
US
------------------------------

Hi, I need to create syntax check that will allow to enter values consisting of digits and letters only (no sign etc)

Example: A1A1A or 1A1A1 (so it can be mix of digits and letters only without any particular sequence). And no sign allowed like: /, *, _, % etc. 

How should the ENT((X)) in field syntax property look like? 

Best Regards,

Jozef



------------------------------
Jozef Prokopovic
Uniface Community Edition Shared Account
US
------------------------------

Hi Jozef,

Quick response: without reading (again) documentation and testing it I would give a try to "#*&*#*"...

Gianni



------------------------------
Gianni Sandigliano
IT
------------------------------

Hi Jozef,

Quick response: without reading (again) documentation and testing it I would give a try to "#*&*#*"...

Gianni



------------------------------
Gianni Sandigliano
IT
------------------------------

Hi Josef

The solution I proposed works only partially...

AFAIK the only real solution is:
- ENT(@*)
Accepting digit + alpha + underscore then check for underscore in the VALIDATE FIELD. It can be defined at model level.

Regards,
Gianni



------------------------------
Gianni Sandigliano
IT
------------------------------