X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FAM.pm;h=c7a88d2df81c26044b7fe66f1e93624e65c16711;hb=41b9f5c7c8067d67326c83e2d26df0898bc279ca;hp=6862eb7732a8b399fca4a4815497344616401d66;hpb=8d771986641efbc83911b0ba007e6c240daea550;p=kivitendo-erp.git diff --git a/SL/AM.pm b/SL/AM.pm index 6862eb773..c7a88d2df 100644 --- a/SL/AM.pm +++ b/SL/AM.pm @@ -244,11 +244,18 @@ sub save_account { } $query = ' - SELECT - accno + SELECT accno FROM chart WHERE accno = ?'; - my ($accno) = selectrow_query($form, $dbh, $query, $form->{accno}); + + my @values = ($form->{accno}); + + if ( $form->{id} ) { + $query .= ' AND NOT id = ?'; + push(@values, $form->{id}); + } + + my ($accno) = selectrow_query($form, $dbh, $query, @values); if ($accno) { $form->error($::locale->text('Account number not unique!')); @@ -262,7 +269,7 @@ sub save_account { do_query($form, $dbh, $query, $form->{"id"}, $form->{"accno"}); } - my @values; + @values = (); if ($form->{id}) {