4Site
Support Request System
View Patch #50.037.014
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02907 -
SQL syntax error running Daily PO report
Symptoms:
If you put a single quote character in the message when e-mailing the report output, you get an SQL syntax error.
Solution:
Used the Replace function to substitute any single quote character with two single quotes in the SQL insert into quetasktext statement, to satisfy SSQL syntax.
Browse Patches
Find a Patch
Return to Request System Menu