Page 1 of 1

SQL thown off by {} symbols

Posted: Wed Jul 03, 2019 3:30 am
by 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?

Re: SQL thown off by {} symbols

Posted: Thu Jul 04, 2019 7:47 am
by Lech Kulikowski
Hello,

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

Thank you.

Re: SQL thown off by {} symbols

Posted: Thu Jul 11, 2019 3:57 am
by TestBoy
That worked!

Thanks.

Re: SQL thown off by {} symbols

Posted: Thu Jul 11, 2019 7:11 am
by Lech Kulikowski
Hello

We are always glad to help you!

Thank you.