How to use ManyDelete and BatchDelete together

corchi72 · 2011-09-12 08:55:18

I wanted to replace

1)ADatabase.Delete (TSQLField, FIDS [i]);

with

2)ADatabase.BatchDelete (FIDS [i]);

but I have not figured out how do I delete table relationships TSQLField with TSQLQvw? (AQvw.Fields)

I have to do a cycle and delete one at a time?

if ADatabase.TransactionBegin(TSQLField) then
begin
 ADatabase.BatchStart(TSQLField);
          for I := 0 to Length(fIds) - 1 do
          begin
              if not (Progress.fCancel) then
              begin
       
//              ADatabase.Delete(TSQLField,fIds[i]);
              ADatabase.BatchDelete(fIds[i]);
              AQvw.Fields.ManyDelete(ADatabase, AQvw.ID, fIds[i]);
              Progress.Position := i;

              end
              else
               begin
                 
                 ADatabase.BatchAbort;
                 ADatabase.RollBack;
                 exit;
               end;
          end;

          ADatabase.BatchSend(Results);
          ADatabase.Commit;
end;

Thanks corchi

corchi72 · 2011-09-16 07:03:40

please help? how to use manydelete in a batch

ab · 2011-09-16 09:24:00

There is no batch version of the ManyDelete method (yet).

You'll have to call ManyDelete multiple times, but you should not mix it with BatchDelete/BatchSend commands, because batch deletions are performed only on BatchSend.

corchi72 · 2011-09-16 11:56:56

I imagined it, but i have one table and more relations and anywhere i delete the record i must to remeber to delete all relations connected to the record.

You know a better way to delete a record and all relationships without having to cycle all the records one by one?

thanks

corchi72 · 2011-09-21 07:42:54

There is a "procedure/function" that erases all the relationships are no longer valid?
How to delete a record in one table and automatically to delete all the relationships of same record?

Thanks corchi

mvddoes · 2012-08-19 10:15:58

Hello,

I am also curious to the answer on the question above.

in code below, a cascaded delete as defined in the database does not work...

      bRC:=Database.Delete(TSQLPatients, iID);

While when deleting the record in a database tool, the cascaded delete works fine... how come?

Regards,
Maurijn

ab · 2012-08-20 07:49:15

I've added an aUseBatchMode optional parameter to TSQLRecordMany.ManyDelete() method.
See http://synopse.info/fossil/info/c0c4838f26

It may help you calling ManyDelete() within a BATCH sequence.

Thanks for the feedback.

mORMot Open Source

#1 2011-09-12 08:55:18

How to use ManyDelete and BatchDelete together

#2 2011-09-16 07:03:40

Re: How to use ManyDelete and BatchDelete together

#3 2011-09-16 09:24:00

Re: How to use ManyDelete and BatchDelete together

#4 2011-09-16 11:56:56

Re: How to use ManyDelete and BatchDelete together

#5 2011-09-21 07:42:54

Re: How to use ManyDelete and BatchDelete together

#6 2012-08-19 10:15:58

Re: How to use ManyDelete and BatchDelete together

#7 2012-08-20 07:49:15

Re: How to use ManyDelete and BatchDelete together

Board footer