# @tag: orderitems_delivery_order_items_positions
# @description: Spalte für Positionen der Einträge in Angeboten/Auftträgen und Lieferscheinen.
# @depends: release_3_1_0
# @tag: orderitems_delivery_order_items_positions
# @description: Spalte für Positionen der Einträge in Angeboten/Auftträgen und Lieferscheinen.
# @depends: release_3_1_0
my $order_id_col = $order_id_cols{ $table };
$query = qq|SELECT * FROM $table ORDER BY $order_id_col, id|;
my $order_id_col = $order_id_cols{ $table };
$query = qq|SELECT * FROM $table ORDER BY $order_id_col, id|;
$sth->execute || $::form->dberror($query);
# set new position field in order of ids, starting by one for each order
$sth->execute || $::form->dberror($query);
# set new position field in order of ids, starting by one for each order
- $query = qq|UPDATE $table SET position = ? WHERE id = ?|;
- $self->db_query($query, bind => [ $position, $ref->{id} ]);
+ $sth2->execute($position, $ref->{id});