_______ 不知何故,始终不能将参数传入存储过程中?__________
此存储过程可执行,但就是参数不能从ADOStoredProc传入到存储过程中?
...
DM->stAlarmSearch->Close();
DM->stAlarmSearch->ProcedureName = "p_realtime_alarm";
DM->stAlarmSearch->Parameters->Clear();
DM->stAlarmSearch->Parameters->CreateParameter("@starttime",ftString,pdInput,19,NULL);
DM->stAlarmSearch->Parameters->CreateParameter("@stoptime",ftString,pdInput,19,NULL);
DM->stAlarmSearch->Parameters->ParamByName("@starttime")->Value = startDt;
DM->stAlarmSearch->Parameters->ParamByName("@stoptime")->Value = endDt;
try
{
DM->stAlarmSearch->Prepared = true;
DM->stAlarmSearch->ExecProc();
}
...
如:startDt = '2004-11-17 21:13:36'
endDt = '2004-12-4 21:13:36'
在存储过程中构造的动态查询串如下:
SELECT * FROM alarm
WHERE AlarmTime BETWEEN ' ' AND ' '
不知何故,始终不能将参数传入存储过程中?
多谢!!!