procedure TPunitive1.Button4Click(Sender: TObject);
var
sqlstr:string;
begin
if (edit1.Text='')or(edit2.Text='')or(edit3.Text='')or(edit4.Text='')or(edit5.Text='')or(edit6.Text='')
or(edit7.Text='')or(edit8.Text='')then
begin
application.MessageBox('下面内容不能为空','提示',0+64);
exit;
end;
if whatsave=0 then begin
sqlstr:='select * from Punitive where number=0000';
with ADOquery2 do begin
if active then close;
SQL.Clear;
SQL.Add(SQLstr);
open;
end; ADOquery2.Append;
ADOquery2.fieldvalues['number']:=edit1.text;
ADOquery2.fieldvalues['name']:=edit2.text;
ADOquery2.fieldvalues['glass']:=edit3.Text;
ADOquery2.fieldvalues['level']:=edit4.Text;
ADOquery2.fieldvalues['yuanyin']:=edit5.Text;
ADOquery2.fieldvalues['unit']:=edit6.Text;
ADOquery2.fieldvalues['c_time']:=edit7.Text;
ADOquery2.fieldvalues['j_time']:=edit8.Text;
try
ADOquery2.post;
ADOquery1.Requery;
except
application.MessageBox('学号重复请重新输入','提示',mb_ok);
ADOquery2.delete;
edit1.SetFocus;
edit1.SelectAll;
exit;
end;
end
var
sqlstr:string;
begin
if (edit1.Text='')or(edit2.Text='')or(edit3.Text='')or(edit4.Text='')or(edit5.Text='')or(edit6.Text='')
or(edit7.Text='')or(edit8.Text='')then
begin
application.MessageBox('下面内容不能为空','提示',0+64);
exit;
end;
if whatsave=0 then begin
sqlstr:='select * from Punitive where number=0000';
with ADOquery2 do begin
if active then close;
SQL.Clear;
SQL.Add(SQLstr);
open;
end; ADOquery2.Append;
ADOquery2.fieldvalues['number']:=edit1.text;
ADOquery2.fieldvalues['name']:=edit2.text;
ADOquery2.fieldvalues['glass']:=edit3.Text;
ADOquery2.fieldvalues['level']:=edit4.Text;
ADOquery2.fieldvalues['yuanyin']:=edit5.Text;
ADOquery2.fieldvalues['unit']:=edit6.Text;
ADOquery2.fieldvalues['c_time']:=edit7.Text;
ADOquery2.fieldvalues['j_time']:=edit8.Text;
try
ADOquery2.post;
ADOquery1.Requery;
except
application.MessageBox('学号重复请重新输入','提示',mb_ok);
ADOquery2.delete;
edit1.SetFocus;
edit1.SelectAll;
exit;
end;
end
ADOquery2.FieldByName('name').AsString := edit2.text;
number似乎是数值型,所以要 STrToInt(edit1.text);对字段赋值时,最好给明字段类型
ADOquery2.FieldByName(字段名).AsString 字符型
ADOquery2.FieldByName(字段名).AsInteger int型
ADOquery2.FieldByName(字段名).AsFloat 浮点型
.
.
.