1:做Tdateset.delete是否會把移標指到下一筆?, 若會,問題2是否就不能做Tmp.delete的動作了.會破壞while迴圈了, 若要讀一筆刪一筆是否要另外方式刪除呢? 2:以下with Tmp 用locate是否不能用 QTmp.Delete 這個指令? with Tmp do begin First; try while not eof do begin if Dcd.Locate('RFMNO', Tmp.FieldByName(PKey).AsString, [loCaseInsensitive]) then raise Exception.Create('該筆單號資料已存在, 不可再挑進來!'); end; Dcd.edit; ..... Tmp.Delete; ...... Dcd.post; finally end; END;

vivi666666 你好: 可能妳寫的程序有錯,稍微在除錯一下    1.with Tmp do begin    First; ... .. . // 要給他     next; // 一下 2.沒關係用就用了唄!!   反正還不都是~找~   只是要在那兒給它變一下 3.改了如下

引言: with Tmp do begin First; try while not eof do begin if Dcd.Locate('RFMNO', Tmp.FieldByName(PKey).AsString, [loCaseInsensitive]) then raise Exception.Create('該筆單號資料已存在, 不可再挑進來!') esle Dcd.edit; ..... Tmp.Delete; ...... Dcd.post; Next; end; finally end; END;

引述一段 help 中的資料: Delete method (TDataSet) Deletes the active record and positions the dataset on the next record. Description Call Delete to remove the active record from the database. If the dataset is inactive, Delete raises an exception. Otherwise, Delete: Verifies that the dataset is not empty (and raises an exception if it is). Calls CheckBrowseMode to post any pending changes to a prior record if necessary. Calls the BeforeDelete event handler. Deletes the record. Frees any buffers allocated for the record. Puts the dataset into dsBrowse mode. Resynchronizes the dataset to make the next undeleted record active. If the record deleted was the last record in the dataset, then the previous record becomes the current record. Calls the AfterDelete event handler. 所以你的第一個問題就是[會] 至於第二個問題是沒問題的, 可以操作的.

引言: 引述一段 help 中的資料: Delete method (TDataSet) Deletes the active record and positions the dataset on the next record. Description Call Delete to remove the active record from the database. If the dataset is inactive, Delete raises an exception. Otherwise, Delete: Verifies that the dataset is not empty (and raises an exception if it is). Calls CheckBrowseMode to post any pending changes to a prior record if necessary. Calls the BeforeDelete event handler. Deletes the record. Frees any buffers allocated for the record. Puts the dataset into dsBrowse mode. Resynchronizes the dataset to make the next undeleted record active. If the record deleted was the last record in the dataset, then the previous record becomes the current record. Calls the AfterDelete event handler. 所以你的第一個問題就是[會] 至於第二個問題是沒問題的, 可以操作的.

那是不是表示有做delete時,可不用做next的動作,因delete時已自動next到下一筆

您好!    當DataSet在做Delete的動作時, 資料錄指針會自動移到該刪除之筆數的后一筆, 不需要再用Next方法來移動, 比如說當前資料錄為第5筆, 當您做了Delete之后, 當前記錄指針就自動移到第6筆, 如果此時您再加以Next的話, 就會把當前資料錄指針移到第7筆了.    參考看看!    ===================== 努力,相信會獲得美麗! 忻晟

------
忻晟