Uniface User Forum

 View Only
  • 1.  How to create syntax check only for digits (0-9) and letters (A-Z)?

    Posted 12-05-2023 08:27

    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
    ------------------------------


  • 2.  RE: How to create syntax check only for digits (0-9) and letters (A-Z)?

    Posted 12-05-2023 11:00

    Hi Jozef,

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

    Gianni



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



  • 3.  RE: How to create syntax check only for digits (0-9) and letters (A-Z)?

    Posted 12-06-2023 09:28

    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
    ------------------------------