帆软报表调用mysql存储过程没执行

[casperchen]

一个mysql 5.x用navicat建立一个存储过程
CREATE DEFINER=`root`@`%` PROCEDURE `myproc`(in `project` varchar(200))
BEGIN
DELETE FROM AList WHERE ProjectName= `project` ;
select * from AList WHERE ProjectName= `project` ;
END

通过帆软报表调用存储过程执行，

执行成功，但数据未删除，经过测试，发现将输入参数`project` 去掉`',变成

CREATE DEFINER=`root`@`%` PROCEDURE `myproc`(in project varchar(200))
BEGIN
DELETE FROM AList WHERE ProjectName= project ;
select * from AList WHERE ProjectName= project ;
END

帆软报表调用成功