Master/Detail Deletions
- From: "ielite" <ielite@xxxxxxxxx>
- Date: Thu, 28 Apr 2005 21:46:00 -0400
Delphi 7 + ADO + MS ACESS
I am trying to accomplish to delete all records from my tables utilizing
this method below - It deletes 3/4 of all the records, but not all - what am
i doing wrong?
If you know a better way to delete all records from tables during runtime
(and resetting the autoInc indexes AND/Or compacting & repairing etc) I
would appreciate any suggestions
Thanks
IElite
procedure TfrmMain.btnEmptyClick(Sender: TObject);
begin
with frmData do
begin
tblParents.last;
while not tblParents.bof do
begin
tblChildren.last;
while not tblChildren.bof do
begin
tblChildren.delete;
tblChildren.prior;
end;
tblParents.delete;
tblParents.prior;
end;
end;
end;
.
- Prev by Date: Re: MS Access and Delphi?
- Next by Date: Re: Unexpected error from external database driver (15877)
- Previous by thread: MS Access and Delphi?
- Next by thread: Re: Master/Detail Deletions
- Index(es):
Relevant Pages
|
