I have a query that runs perfect in my MySQL clients connected to my DB. I have a CONCAT in the field list of the select query. Whenever I run this query in a scriptcase application it formats the query to the point where it adds and around the concat statement. how do I stop it from doing this?
My Concat:
CONCAT( dialog.t_target, ’ ', uunit.unit, ’ +/- ', ROUND(( dialog.t_upper - dialog.t_target), 2)) as spec
My Concat after scriptcase messes it up:
CONCAT( dialog.t_target,' ',uunit.unit,' +/- ',ROUND(( dialog.t_upper - dialog.t_target),2)) as spec