}
$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!'));
do_query($form, $dbh, $query, $form->{"id"}, $form->{"accno"});
}
- my @values;
+ @values = ();
if ($form->{id}) {
taxkey,
taxdescription,
round(rate * 100, 2) AS rate,
- chart_id
+ chart_id,
+ (id IN (SELECT tax_id
+ FROM acc_trans)) AS tax_already_used
FROM tax
WHERE id = ? |;