zlink.AdoConnection1.BeginTrans;
Try zlink.ADOTableSZ.Locate('项目','计费',[]);
zlink.ADOTableSZ.Edit;
zlink.ADOTableSZ.FieldByName('单价').AsFloat:= strtofloat('0'+edit1.Text);
zlink.ADOTableSZ.FieldByName('计费周期').AsInteger:=strtoint('0'+combobox1.Text);
zlink.ADOTableSZ.FieldByName('收费日').AsInteger:=strtoint('0'+combobox2.Text);
zlink.ADOTableSZ.FieldByName('期限').AsInteger:=strtoint('0'+edit2.Text);
zlink.ADOTableSZ.FieldByName('日滞纳金').AsFloat:= strtofloat('0'+edit3.Text);
zlink.ADOTableSZ.Post; showmessage('资料已经保存');
Except
zlink.AdoConnection1.RollBackTrans;
End ;
不提示错误,也没有保存在数据库中,何解?????????????
Try zlink.ADOTableSZ.Locate('项目','计费',[]);
zlink.ADOTableSZ.Edit;
zlink.ADOTableSZ.FieldByName('单价').AsFloat:= strtofloat('0'+edit1.Text);
zlink.ADOTableSZ.FieldByName('计费周期').AsInteger:=strtoint('0'+combobox1.Text);
zlink.ADOTableSZ.FieldByName('收费日').AsInteger:=strtoint('0'+combobox2.Text);
zlink.ADOTableSZ.FieldByName('期限').AsInteger:=strtoint('0'+edit2.Text);
zlink.ADOTableSZ.FieldByName('日滞纳金').AsFloat:= strtofloat('0'+edit3.Text);
zlink.ADOTableSZ.Post; showmessage('资料已经保存');
Except
zlink.AdoConnection1.RollBackTrans;
End ;
不提示错误,也没有保存在数据库中,何解?????????????
zlink.ADOTableSZ.insert;试试
那样的话应用update吧?
不会用缓存
更不会update
望赐教
zlink.ADOTableSZ.UpdateBatch();
locktype ltbatchOtimistic
在修改完后
adotabel1.updatebatch;
Try
Except
END
注释掉再运行,便于找错!