13问答网 > delphi2010下使用TMyQuery调用mysql的存储过程传时间参数的问题

delphi2010下使用TMyQuery调用mysql的存储过程传时间参数的问题

2025-03-07 00:04:03

推荐回答（1个）

回答1：

MySQL的存储过程定义为：
BEGIN
SELECT * FROM(select 派单时间,派单人,流水号,车辆单位,车牌号码,cast(GPS北斗维修派单 as DECIMAL) as GPS北斗维修派单
from all_in
WHERE 派单时间 BETWEEN strBeginTime AND strEndTime ORDER BY 派单时间 DESC)t3
union all
SELECT * FROM(selectcast('合计' as CHAR) as 派单时间,cast('' as CHAR) as 派单人,cast('' as CHAR) as 流水号,cast('' as CHAR) as 车辆单位,cast('' as CHAR) as 车牌号码,sum(GPS北斗维修派单)
from all_in
WHERE 派单时间 BETWEEN strBeginTime AND strEndTime ORDER BY 派单时间 DESC)t4;
END