L
lmk
Unregistered / Unconfirmed
GUEST, unregistred user!
procedure TfrmSyncMain.Button1Click(Sender: TObject);<br>var<br> RemotePayDB : TADOConnection;<br> adoquery : TADOQuery;<br>begin<br> RemotePayDB := TADOConnection.Create(nil);<br> //查找费用明细信息和用户扩展信息<br> RemotePayDB.ConnectionString := strLocalPayDB;<br> RemotePayDB.Connected;<br> adoquery := TADOQuery.Create(self);<br> adoquery.Connection := RemotePayDB;<br> adoquery.SQL.Text := 'select * from readmeter where custid=''1001966''';<br> adoquery.Bookmark;<br> adoquery.Open;<br> adoquery.First;<br> adoquery.Edit;<br> while not adoquery.Eof do<br> begin<br><br> adoquery.FieldByName('isrecouppay').AsString := '3';<br> adoquery.Next;<br><br> end;<br> adoquery.Post;<br> adoquery.Close;<br> adoquery.Free;<br> RemotePayDB.Close;<br> RemotePayDB.Free;<br>end;<br>主要是想成批更改,然后一起提交的!但上面这样写报dataset not in edit or insert mode 错