OK, I've created a template in Avante 9.2. It has this field called 'ThisCompany Account Code'. It's a number field, it's required and these codes are always in the form ##-###-###-###. So I'm trying to create a constraint that looks like this:
\d\d-\d\d\d-\d\d\d-\d\d\d
This is almost identical to the syntax used in the design guide examples, so should work, but instead generates this 9337 syntax error. The online help helpfully says 'This is a syntax error'. Awesome.
As a larger problem, it appears that the regular expressions don't work at all in any of the fields I create. Every regex throws this 9337 syntax error, even the most basic, like '\d' or '[0-9]'. Relational operators seem fine, like '=<1' for example, works as expected.
Not sure what to do next. Is there maybe a global setting to enable regular expressions somewhere that I need to turn on?
Dale.