Re: Master/Detail Deletions

K - Thanks! I will give that a try

IELite

"Robert J Emmons" <catch22@xxxxxxxx> wrote in message
news:ANxce.21029$RP1.10384@xxxxxxxxxxx
> ielite wrote:
>> 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
>>
>
> I would use one TADOQuery and 2 delete queries. Delete all records from
> the child first. Here is some C++ code. I don't do Delphi.
>
> TADOQuery qry;
> qry->SQL->Clear();
> qry->SQL->Add("DELETE * FROM ");
> qry->SQL->Add(outTblName + ";");
> qry->ExecSQL();
>
>
>
> --
> Robert Emmons
> remmonsREMOVECAPS@xxxxxxxxxxx


.