过程代码如下
procedure TAddDpt.Insert(DptNo, DptName, DptMark: string);
var
strsql:string;
begin
strsql:='insert into department ([组室编号],[组室名称],[备注]) values (:DptNo,:DptName,:DptMark)';
with QrAddDpt do
begin
Connection:=MyDataModule.ConnServer;
Active:=false;
SQL.Clear;
SQL.Add(strsql);
Parameters.ParamByName('DptNo').Value:=DptNo;
Parameters.ParamByName('DptName').Value:=DptName;
Parameters.ParamByName('DptMark').Value:=DptMark;
Prepared;
end;
try
QrAddDpt.Active:=true;
QrAddDpt.ExecSQL;
except
ShowMessage('数据插入出错!!!');
end;
end;
执行时出现的异常如下
---------------------------
Debugger Exception Notification
---------------------------
Project SchoolManage.exe raised exception class EDatabaseError with message 'QrAddDpt: CommandText does not return a result set'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
ExecSQL不是不用返回数据集的嘛,怎么解决啊?
procedure TAddDpt.Insert(DptNo, DptName, DptMark: string);
var
strsql:string;
begin
strsql:='insert into department ([组室编号],[组室名称],[备注]) values (:DptNo,:DptName,:DptMark)';
with QrAddDpt do
begin
Connection:=MyDataModule.ConnServer;
Active:=false;
SQL.Clear;
SQL.Add(strsql);
Parameters.ParamByName('DptNo').Value:=DptNo;
Parameters.ParamByName('DptName').Value:=DptName;
Parameters.ParamByName('DptMark').Value:=DptMark;
Prepared;
end;
try
QrAddDpt.Active:=true;
QrAddDpt.ExecSQL;
except
ShowMessage('数据插入出错!!!');
end;
end;
执行时出现的异常如下
---------------------------
Debugger Exception Notification
---------------------------
Project SchoolManage.exe raised exception class EDatabaseError with message 'QrAddDpt: CommandText does not return a result set'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
ExecSQL不是不用返回数据集的嘛,怎么解决啊?
解决方案 »
- 很茫然~DELPHIER何去何从?
- delphi,idhttp如何获取网页中hidden类型的value值
- 钩子问题
- 套用一句广告词“这么多年,Delphi从没让我失望!”
- 急急!!!医院影像信息信号到达工作站的电脑上,怎么样在DELPHI中捕捉将信号转化为图像??求救!!
- 提取字符串的问题
- win2000server,怎么得到当前用户的登录密码?
- 给动态创建的组件加事件
- DELPHI的程序最小多大?
- 本来想放假之前专家分达到2000分,现在看来没什么希望了(还差352分)。我想网上也许有人象我一样,在期待着分数的突破,故散分。/踢踏
- 奇怪的问题,关于有类型的常量和数组
- IXMLDOMNodeList里怎么加入IXMLDOMNode的?
QrAddDpt.Active:=true;