sql语句在MYSQL里能用 调用到DELPHI里就报错。该怎么解决

sql语句在MYSQL里能用 调用到DELPHI里就报错。。。
SQL语句:有两张表 t_approve ,t_fundsflow 
t_approve.approveDateTime = t_fundsflow.LocalDateTime 都为时间列

select t_approve.approveDateTime as 纠错时间, t_approve.postDateTime as 提交时间, t_approve.approveman as 纠错员,t_fundsflow.balance_old as 初期卡余额 ,t_approve.money as 纠错金额,
case when t_approve.TYPE='1' then '卡多充钱' when t_approve.Type='2' then '卡少充钱' when t_approve.TYPE='3' then '多收钱' when t_approve.TYPE='4' then '少收钱' else '123' end as 错误类型,
case when t_fundsflow.actionflag='+' then (t_fundsflow.Balance_Old + t_fundsflow.Amount) when t_fundsflow.actionflag='-' then (t_fundsflow.Balance_Old - t_fundsflow.Amount) else '321' end as 调整后卡内余额
from t_approve inner join t_fundsflow on t_approve.approveDateTime = t_fundsflow.LocalDateTime

在DELPHI里的写法:
'select t_approve.approveDateTime as 纠错时间, t_approve.postDateTime as 提交时间, t_approve.approveman as 纠错员,t_fundsflow.balance_old as 初期卡余额 ,t_approve.money as 纠错金额,'+
'case when t_approve.TYPE='+#39'1'#39+' then '+#39'卡多充钱'#39+' when t_approve.Type='+#39'2'#39+' then '+#39'卡少充钱'#39+' when t_approve.TYPE='+#39'3'#39+' then '+#39'多收钱'#39+' when t_approve.TYPE='+#39'4'#39+' then '+#39'少收钱'#39+' else '+#39'123'#39+' end as 错误类型,'+
'case when t_fundsflow.actionflag='+#39'+'#39+' then (t_fundsflow.Balance_Old + t_fundsflow.Amount) when t_fundsflow.actionflag='+#39'-'#39+' then (t_fundsflow.Balance_Old - t_fundsflow.Amount) else '+#39'321'#39+' end as 调整后卡内余额'+
'from t_approve inner join t_fundsflow on t_approve.approveDateTime = t_fundsflow.LocalDateTime

哪位高手 帮帮忙啊
报错位置主要在 ‘错误类型’和‘调整后卡内余额’这两块 很奇怪在MYSQL里就运行正常 可在DELPHI里调用就报错了

------解决方案--------------------
至少发现一个错:
调整后卡内余额 后面少空格,而上面mysql中的是有回车的
在你from前加空格试试