You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Originally posted by wlclifford January 2, 2025
This seems to have started with update from 3.4.10 to 3.4.13. Screen shot below of what seems to be valid syntax. Also happens with red underline of just the semicolon when the last line of a script contains WHERE and LIKE - again the script below works fine.
UPDATE NHPProductLicence
SET product_name = REPLACE(product_name, CHAR(10), '')
WHERE product_name LIKE '%' || CHAR(10) || '%';
The text was updated successfully, but these errors were encountered:
Discussed in #5195
Originally posted by wlclifford January 2, 2025
This seems to have started with update from 3.4.10 to 3.4.13. Screen shot below of what seems to be valid syntax. Also happens with red underline of just the semicolon when the last line of a script contains WHERE and LIKE - again the script below works fine.
UPDATE NHPProductLicence
SET product_name = REPLACE(product_name, CHAR(10), '')
WHERE product_name LIKE '%' || CHAR(10) || '%';
The text was updated successfully, but these errors were encountered: