SQL thown off by {} symbols

[TestBoy]

So I am trying to do a one off quick report and I ran into something that stopped me cold.

If I do something like this:

Code: Select all

where process_date between '2019-01-01' and '2019-12-31' and t.code REGEXP '^[a-z|A-Z]{2}[0-9]{2}.[5-6]$'

I think it is replacing the {2} in there, or at least being confused.
If I hit "retrieve colums" a "SQL Expressions" dialog appears with two lines that have 2 for the label and 2 entered in the two textboxes next to them.

Is there any way to get it to ignore or escape the curly braces in my regular expressions?

[Lech Kulikowski]

Hello,

Please set the AllowExpressions=false property for the SQL data source.

Thank you.

[TestBoy]

That worked!

Thanks.

[Lech Kulikowski]

Hello

We are always glad to help you!

Thank you.