Very Computer

I'm writing a D2 app with paradox.

I won't to update a all fields called index in a table. But the values
must increment.
If I use a TQuery I can do this:

var
  i: Integer;
begin
  i := 1;
  mytable.First;        
  while not mytable.eof do begin
    mytable.Edit;
    mytable.FieldByName('Indeks').AsInteger := i;
    mytable.Post;
    mytable.Next;
    Inc(i);
  end;
end;

...but this is slow because the table is very big. Is there another way
to do this like:

update index increment by 1

or something (in my dreams)

Thanks!

I think I saw something like this in a book about SQL:

update table_1 set ff = ff + 1

So you should use:

Query.SQL.Add('UPDATE TABLE_1 SET FF = FF + 1');
Query.ExecSQL;

Yep, I just tested. I works.

You may wanna acquire an exclusive lock on the table. That will
help eliminate the extra over head attached with locking each
individual record.