点击登记的时候插入表中内容。插入成功给出提示。如果再输入信息点击登记,程序报这个错误。
登记 按钮代码:
procedure TForm4.Button1Click(Sender: TObject);
var
sqlstr,edxingming,eddianhua,edcardno,ednianling,edzhuzhi,dengjisj:string;
begin
edxingming:=trim(edtxingming.text);
if length(edxingming)<1 then
begin
showmessage('请输入姓名');
edtxingming.SetFocus;
exit;
end;
eddianhua:=trim(edtdianhua.text);
if length(eddianhua)<1 then
begin
showmessage('请输入联系电话');
edtdianhua.SetFocus;
exit;
end;
edcardno:=trim(edtno.text);
if length(edcardno)<1 then
begin
showmessage('请输入身份证号');
edtno.setfocus;
exit;
end;
ednianling:=trim(edtnianling.text);
edzhuzhi:=trim(edtzhuzhi.text);
// dengjisj:=datetostr(DateTimePicker1.datetime);
sqlstr:='insert into wym_dengji (xingming,lianxidh,shenfenzheng)values('''+edxingming+''','''+eddianhua+''','''+edcardno+''')';
with query1 do
begin
//try
Close;
SQL.Clear;
SQL.Add(sqlstr);
ExecSQL;
Close;
//finally
free;
end;
showmessage('登记成功');
edtxingming.Text:='';
edtdianhua.Text:='';
edtno.Text:='';
edtnianling.Text:='';
edtzhuzhi.Text:='';
end;