求助:用delphi向数据库里插入数据 但是数据库里没数据
我用delphi向数据库里插入数据 没有出现任何错误 但数据库里就是什么数据都没有 特别奇怪!!!部分代码如下:
var
xiaobanhao,strcodexiaoban,linban,tongjiyear:string;
zyflag:integer;
begin
tongjiyear:=edit1.Text ;
zyflag:=1;
linban:='001';
adoqs.Close;
adoqw.Close; //在找到所有的小班
ADOQS.SQL.Clear ;
ADOQS.SQL.Add('execute mytfdarea_XiaobanSelect '+LinBan);
try
ADOQS.Prepared ;
ADOQS.Open;
ADOQW.Close;
while not ADOQS.Eof
do
begin
xiaobanhao:=trim(ADOQS.Fields.fieldbyname('xb').AsString);
strcodexiaoban:=trim(adoqs.Fields.fieldbyname('id').AsString );
xiaobanhao:=' '+xiaobanhao;
ADOQW.SQL.Clear ;
if trim(ADOQS.Fields.fieldbyname('dl').AsString)='针叶林' then
begin
ADOQW.SQL.Add('execute tfdarea_insertrecord '''+strcodexiaoban+''','''+tongjiyear+''','''+xiaobanhao+''','''+ADOQS.Fields.fieldbyname('qs_td').AsString+''','''+ inttostr(zyflag)+''',');
ADOQW.SQL.Add(floattostr(ADOQS.Fields.fieldbyname('mj').AsFloat) +','+floattostr(ADOQS.Fields.fieldbyname('mj').AsFloat) +','+floattostr(ADOQS.Fields.fieldbyname('mj').AsFloat) +','+floattostr(ADOQS.Fields.fieldbyname('mj').AsFloat) +','+floattostr(ADOQS.Fields.fieldbyname('mj').AsFloat) +',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100');
end
else
begin
showmessage('没有进行以上选择!');
end;
ADOQW.Prepared ;
ADOQW.ExecSQL ;
ADOQS.Next;
end;
showmessage('成功!');
except showmessage(adoqw.SQL.Text);
showmessageadoqs.SQL.Text); exit;
end;
ADOQW.Close;
ADOQS.Close;
end;
其中有用到存储过程的 程序的结果就是显示 ‘成功!’
大家都来帮帮忙了 很急