2,497
社区成员
发帖
与我相关
我的任务
分享
with sp1 do
begin
close;
Prepared:=false;
ProcedureName:='cp_jccxkhbh;1';
Parameters.Refresh;
Parameters.ParamByName('@khph').Value:=Trim(cxLookupComboBox3.Text);
Open;
end;
ADOStoredProc1.Parameters.count=0
PROCEDURE `proc_HZChatRecLog`(IN _Sender varchar(20), IN _SIP varchar(15), IN _Accepter varchar(20),
IN _AIP varchar(15), IN _Msg varchar(3000))
PROCEDURE `proc_HZChatRecLog`(IN _Sender varchar(20), IN _SIP varchar(15), IN _Accepter varchar(20),
IN _AIP varchar(15), IN _Msg varchar(3000))
BEGIN
SET _Msg=replace(_Msg, '&*', '');
IF RTRIM(_Msg) <> '' THEN
insert into TABHZChatLog(Sender, SenderIP, Accepter, AccepterIP, Msg, CreateTime) values
(_Sender, _SIP, _Accepter, _AIP, _Msg, Now());
END IF;
END
ADOStoredProc1.ProcedureName := 'proc_HZChatRecLog;1';
ADOStoredProc1.Close;
ADOStoredProc1.Prepared := False;
ADOStoredProc1.Parameters.ParamByName('@Sender').Value := 'Test';
ADOStoredProc1.Parameters.ParamByName('@SIP').Value := '132323';
ADOStoredProc1.Parameters.ParamByName('@Accepter').Value := 'aaaaaaa';
ADOStoredProc1.Parameters.ParamByName('@AIP').Value := '6666666';
ADOStoredProc1.Parameters.ParamByName('@Msg').Value := 'asdfsdf';
ADOStoredProc1.ExecProc;