SQL Validation error Server 7.2


I have some sql code that was working in a report, after upgrading from 6.3 > 7.2 comunity version I now get an validation error.

I have tracked this down to  this section of code

regexp_replace(replace(customer.accounts_note,',',''), E'[\\n\\r]+', ',,', 'g' ) as reg_rep

if I change the \\n\\r for something else all is ok. where is this turned off as I have to remove blank lines from my output

any help would be good

markbeardhome's picture
Joined: Mar 5 2012 - 2:00am
Last seen: 6 days 5 hours ago

0 Answers:

No answers yet